Skip to main content
A
Anonymous
January 13, 2011
Answered

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

  • January 13, 2011
  • 13 replies
  • 567388 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'.

    13 replies

    Show previous replies
    J
    jstanley5003
    Participant
    January 13, 2012

    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
    January 13, 2012

    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
    January 13, 2012

    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.

    AbhigyanModi
    Community Manager
    AbhigyanModiCommunity Manager
    Community Manager
    January 20, 2011

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

    D
    dissipatedfog
    Participant
    January 20, 2011

    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
    January 13, 2011

    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
    January 14, 2011

    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
    January 20, 2011

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

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices