A

Anonymous

Answered

How to copy/Paste a table from PDF to Excel using AcrobatX

Forum|Forum|15 years ago
January 13, 2011
13 replies
567654 views

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?

Tomas

This topic has been closed for replies.

Correct answer hughesbl

I found that both the "export selection as" and the "copy with formatting" functions were able to go directly to Excel without using Word, though that also works. The key in Excel is to simply use ctrl+v to paste, not to right-click and try to use a special paste or the default, which went to 'Keep text only'.

Show previous replies

J

jstanley5003

Participant

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

B

Bev_Meister

Participant

I have the 9 and X installed and they work fine together- got the updaters working in tandem. Strangely this is one area where Adobe apps can co-exist unlike other vendors

J

jstanley5003

Participant

Can you please share how you created the pdf you are using.

And if possible could you share the pdf so that i can reproduce the issue at my end.

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.

AbhigyanModi

Participating Frequently

When you are copying, are you using "Copy with formatting" ?

D

dissipatedfog

Participant

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?

D

Dave Merchant

Legend

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.

D

dissipatedfog

Participant

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?

D

dissipatedfog

Participant

Thank you for the information, I'll give it a try - after spending over $300 on Acrobat Standard X.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.