Skip navigation
Currently Being Moderated

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

Jan 13, 2011 11:40 AM

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

 
Replies
  • Currently Being Moderated
    Jan 13, 2011 12:58 PM   in reply to Tomaspav

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 13, 2011 4:44 PM   in reply to Dave Merchant

    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?

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 20, 2011 12:48 AM   in reply to Tomaspav

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

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 20, 2011 9:46 AM   in reply to AbhigyanModi

    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?

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 20, 2011 9:50 AM   in reply to dissipatedfog

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

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 10, 2012 10:18 PM   in reply to dissipatedfog

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 12, 2012 7:24 PM   in reply to Tomaspav

    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

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 12, 2012 7:29 PM   in reply to jstanley5003

    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

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 12, 2012 7:36 PM   in reply to Bev_Meister

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 19, 2012 8:50 AM   in reply to Bev_Meister

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 19, 2012 9:02 AM   in reply to atir_husain

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Feb 6, 2012 10:22 AM   in reply to jstanley5003

    Which version of Microsoft Office are you using?

    If you are using office 2010 make sure that you are not pasting the table with “Keep text only" option.

     
    |
    Mark as:
  • Currently Being Moderated
    Feb 6, 2012 10:37 AM   in reply to Tomaspav

    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).

     
    |
    Mark as:
  • Currently Being Moderated
    Feb 7, 2012 5:44 AM   in reply to Dave Merchant

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Feb 7, 2012 5:56 AM   in reply to Bill@VT

    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

     
    |
    Mark as:
  • Currently Being Moderated
    Feb 7, 2012 10:30 AM   in reply to jstanley5003

    I am surprised on the OCR. Most folks have reported the OCR in AA X to be a great improvement. It may be that your original copy is just that bad and AA 9 would have done no better.

     
    |
    Mark as:
  • Currently Being Moderated
    Feb 1, 2013 11:17 AM   in reply to Tomaspav

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 4, 2013 4:34 PM   in reply to gfh2009xx

    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.

     

    http://www.w3.org/TR/WCAG20-TECHS/PDF20.html

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 12, 2013 10:36 PM   in reply to Tomaspav

    I too just updated (November 2013) to "Adobe Acrobat XI Pro" and find it disappointing that the Right Click on PDF Table & "Copy as Table" function is Not Available. Very Bummed !  

    Lost Function.jpg

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 13, 2013 4:58 AM   in reply to George_C

    Hi George,

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 15, 2013 9:07 AM   in reply to ApoorvM

    I'm in the same situation as George and I don't see "copy with formatting." I'm using AdobeXI.

     

    Adobe Help.jpg

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 15, 2013 1:11 PM   in reply to LindseyB

    Hi Lindsey,

     

    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.

    Untitled.png

    I hope it helps.

     

    -Apoorv

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 23, 2014 2:07 PM   in reply to ApoorvM

    I am having similar issues.  I am bound to X Pro as XI Pro no longer has LCD packaged with it (I am told), and the company wil not shell out another $600 for the stand alone LCD ES4.  So I need to keep my X Pro and LCD ES2 for now.  I get this very helpful error when I try to save as an Excel file, or try to Export Selection As:

     

    Save As failed to process this document.  No file was created.

     

    It seems to be hit and miss, as I was able to File - Save As - Spreadsheet a few times, but then not.  I have a form with many differing pages, layouts, tables, etc.  My users are complaining that copy/paste sucks.  So what is wrong here?

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (1)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points