copying multiple pages of tables from pdf to excel

[talovis]

Hello,

I work at a financial data company where I have to copy and paste tables from pdf to excel...all day. My issue is that when I highlight the entire table and copy into excel, all the data gets jumbled and/or crammed into the wrong column. As a result, I have to perform the extremely tedious task of copying the tables column by column, page by page. I should mention that I cannot seem to highlight more than one page of data at a time, which is very time consuming.

I would like to know if anyone knows a way to copy tables from pdf to excel while ensuring that everything gets mapped properly. Even better would be a way to do this with multiple pages of tables. Perhaps there is a software/add-on that I need? Or does excel/adobe already this kind of function?

Your help would be very much appreciated.

Thank you!!

[minnesotaart]

If you have Adobe Acrobat, you should be able to save the PDF as an Excel file. If you don't, there are other software alternatives that will do this too (e.g., Nuance PDF Converter).