Excel – How to copy a table of data from a PDF file into Excel

adobe-acrobatcopy/pastemicrosoft excelpdf

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.