Adobe Acrobat DC Pro Export to Excel

New Here ,
Mar 03, 2021 Mar 03, 2021

Copy link to clipboard

Copied

I am using Acrobat DC Pro version 2021.001.20142.  I have a PDF file which I am trying to export to Excel.  When I run the process, the Excel file is missing 90 percent of the data.  The header info is there but all the lines are missing information.  I've tried this on several computers running the same version of Acrobat

If I take the same file to another computer which is running Acrobat Pro DC version 2015.006.30527, the file converts properly and I see all data.

All computers running Windows 10.

There are limited options in export settings.  Both Adobe versions match the settings.

Is there something I'm missing?

TOPICS
Acrobat

Views

52

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Mar 03, 2021 Mar 03, 2021

Copy link to clipboard

Copied

You may want to file a bug report: http://www.adobe.com/products/wishform.html

 

In general, exporting a PDF file to antoher format is one of the most complex tasks you can do with a PDF file, and the results depend highly on how the file was generated. If you started out with an Excel document, and used Adobe's tools to convert to PDF, and then try to export from that PDF again, you will usually see the best results. For other documents, Acrobat needs to analyze the structure of the data, and that's where things can go seriously wrong. Just because it's obvious to human eyes what should belong together, and where rows and columns are, that does not mean that a computer program will make the same decisioins as we do. It is possible that the change in behavior between the 2015 and 2021 version is due to an attempt to make other cases be handled better and your case just is an outlier. 

 

What I usually do when I end up with a bad result is to export the PDF page as a high resolution image (e.g. a 600dpi TIFF image), and then I import that image back into Acrobat and run OCR, and then I try to export again to MS Word or Excel, and oftentimes I get better results. There is also a dedicated free application that allows for a better data extraction than what Acrobat does: https://tabula.technology (but it's also a bit harder to use than Acrobat's one click approach)

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 03, 2021 Mar 03, 2021

Copy link to clipboard

Copied

LATEST

Thank you Karl for the the explination and also the work around.  Seems to work.  I will look into the free app.

 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines