How to copy/Paste a table from PDF to Excel using AcrobatX?
I was able to do this easily using acrobat 9 but cannot do it in Acrobat10.
Has the option fgone or am I missing something?
Rather than copy and paste, Acrobat X exports to an Excel workbook from where you can transfer into an existing table if required.
To save a specific table from a PDF document, draw a selection box around it, right-click the selection and choose Export Selection As, then choose Excel Workbook from the file type menu. You can also run OCR on demand to convert a bitmap image of a table into a real table. All the formatting of the cells will be transferred across, where supported.
If you have a table alone in a PDF file, you can simply choose File - Save As - Spreadsheet to convert the entire thing.
That doesn't work for me! What used to copy and paste as a nice table is now a wreck. I have to reconcile several credit card statements in Excel at my job, it used to be so easy to copy and paste as a table. Now some of the rows paste into separate columns but most don't now. I ran the OCR and it made no difference. I've tried saving the file as an Excel spreadsheet and a Word doc, but the columns don't come up correctly. Is there a fix for this?
I am using "Copy with formatting". I've tried every different way I can see and nothing works. It's unfortunate because this feature is the reason I upgraded from Reader after doing a trial with version 9. Is there any way to downgrade to Acrobat 9 standard using the same reg key?
This is a major pain in the neck. I'm working with X and 9 Pro and whilst the latter wasn't perfect, it was easy to extract info from tables. X exports data imperfectly to Excel. Formatting looks great but what use is that when stores individual cells with multiple data. Painful painful painful. I have to downgrade to be productive. This should be a bug or feature fix if anyone at Adobe is listening.
Yes I too found the copy and paste in Acrobat 9 functional , upgraded to X which has been a huge waste of money. I started with Acrobat 4.0 and usually each version provided better features until now hopefully someone at Adobe monitors these posts and will provide a fix in the future. Will probably have to uninstall Version X and reinstall 9
Had I known that at the time would have been worth it as it was when I went to install X it told me to unistall the old version and when I did and then tried to run X it said I couldn't upgrade because it couldn't find a current version on my computer so had dig out the old copy so that the X would install and give me credit for owning a previous version. So far haven't seen X do anything better than version 9 for the purposes I use it for. I'll try installing 9 back over the top of X , thanks for the tip.
Appreciate the offer but the file is from an insurance company and the client information is protected so I can’t release. But when we use copy or copy format it puts it in an entirely different format in the excel spread sheet either all data in one column or in formatted in several columns but still the data is combined where as when you use copy as a table in Acrobat 9 it lays it out perfectly in excel just like in the pdf. After using Acrobat X now for a couple of weeks definitely wasn’t worth upgrading from 9.0 to X. Thanks for the offer though.
It's almost certain that the PDF file isn't tagged (either at all, or properly). Accessible, tagged files will export to spreadsheets as Acrobat can understand what's a table, what's a header cell, etc. whereas in an untagged file it has to make guesses based on the separation of each text block (it can't see the page visually as you do, so what looks like a perfectly-obvious table to a human is actually very difficult to detect in code).
The alternative is to do column or block copies. In the past this was done by using the alt key when selecting the area of interest (works in my AA9). That allows you to copy column by column and generally the lines separations will still be used. Hope that does it.
Thanks for the response however I've tried this and it just doesn't work right, after having worked with Acrobat X even more it just isn't as good as 9.0, documents I used to be able to OCR now have more unrecognized or miss recognized items than 9.0 and the only thing I have changed is going from 9.0 to 10.0. This appears to have been nothing but a profit move from Adobe just a few bells and whistles. This is the first time Adobe has failed to deliver a significant improvement by introducing a new version and I started with 4.0
I have discovered a work around. Select the table you are trying to copy, right click and select "export selection as" and save it as a .docx file. Open the word document, copy the table again and paste it into an open excel file. The columns will be maintained and your data will be in seperate cells instead of all of it in one cell. It's not one easy step like it used to be, but it does work.
We too work with Insurance documents where we have to pick the tables from the pdf to excel.
While googling we found the below and helped us a lot.
Give it a try , i hope this works for you.
Not the best , but does the work.
Are you using 'Copy with formatting' for copying tables or the normal 'copy' option ?
If you want to copy a table to excel, you should select the table , rightclick on selection and use the 'Copy with formatting' option. And then paste it to excel . This should paste the table correctly.
If it doesn't in your case, please let me know.
As I said you need to right click on the selection , edit menu does not show the option.
You can also make a rectangular selection by pressing the Ctrl key while you click and drag the mouse, in this case a rectange is created over the PDF content on which you can right click for 'copy with formatting' option.
I hope it helps.