I have a table of data and I need to get it into Excel. I found a few websites that suggested copy and paste into MS Word and then use the "Convert Text to Table" which unfortunately doesn't work as the columns come in with a space in between them but if I choose space as the column separator it breaks up columns that have multiple words in them into different columns.
Is there a better recommended way to get a table from a PDF file into Excel?
Best Answer
The whole thing is much simpler than mentioned in the other answer.
In Acrobat/Reader, choose the Text Selection tool, and bring your table into full view.
Now press the Ctrl/Option key and select the table. You will notice that the cursor changes. When the selection is complete, you can copy and paste into Excel.