Skip to main content
J
jessicaprepareproject
Participant
April 25, 2017
Answered

Export PDF to Excel comes up empty

  • April 25, 2017
  • 1 reply
  • 31401 views

Hello,

Running a PC on Windows 7 Enterprise, 32-bit. On one computer, I have Adobe Acrobat Pro 7, and on another, I have Adobe DC, and have tried using both programs to export a PDF to an Excel, without success.

A team member was able to do this a few weeks ago on Adobe DC (have never been successful with Pro 7, and it is no longer working in Adobe DC) with the particular PDF documents that we are trying to export, but we are no longer able to make this happen. In Adobe DC, we follow the standard rules of exporting PDFs (choose Export from Tool panel, choose spreadsheet, etc). It does "export" the PDF, but when the exported document opens in Excel, the Excel is completely empty. I tried exporting this same PDF to Word and it was mostly successful.

Has anyone experienced an empty export when trying to convert PDF to excel? I'm also happy to send the PDF to someone else so you can see if you experience the same problem...

Thanks for any assistance.

Jessica

This topic has been closed for replies.
Correct answer lauraa19990763

I am experiencing the same blank page popping up when I try to export PDF to WORD and EXCEL.  I have been able to this in the past, but this week I have not been able to use the tools.  The reason I purchased ADOBE was to be able to do the things I need to do.  So, I am not interesting all the complicated workarounds.  I want product to work as it used to work.  Advice appreciated.


Problem solved! When I right clicked on desktop pdf copy of data, I noticed the default was Adobe Acrobat 15......When I chose Adobe Acrobat 18.....the conversion happened easily and I got to the familiar page.  How this default was decided I have no clue.  But I am happy happy to be back in business.

1 reply

try67
Community Expert
try67Community Expert
Community Expert
April 25, 2017

Does your PDF contain actual form fields?

J
jessicaprepareprojectAuthor
Participant
April 26, 2017

It does not—it is a PDF of a web page with some data on it that we want to transform into Excel for analysis (cutting/pasting puts the columns out of order). What do form fields do when trying to convert PDF to Excel?

Karl Heinz Kremer
Community Expert
Karl Heinz KremerCommunity Expert
Community Expert
April 26, 2017

Form fields are not being converted, so if your complete document is made up form form fields, you would not get any information in your resulting Excel file.

I assume that the file you are trying to convert does not contain real text - very likely because somebody converted all text to outlines in order to make it harder to extract data. Can you select text and copy and paste it into e.g. a Word document?

Converting from PDF to Word, Excel or any other format is one of the most complex things you can try to do with a PDF file. It works very well in some cases, in other cases the output has very little to do with the original file. The key for success is that the PDF file needs to be "tagged" - which means that it contains information about the information that is displayed in the file. The best way to make sure that a PDF file is tagged correctly is by using the PDFMaker in Acrobat to create the PDF file from Word or Excel (that's the Acrobat ribbon or toolbar).

Sometimes it helps to save the PDF file as a set of high resolution (e.g. 600dpi) images, then import these images back into Acrobat, run OCR and then export to Word or Excel again.

There are other tools available that can convert PDF to Excel. Whenever I come across a file that does not want to behave (and I don't want to go through the process for converting to an image and importing again), I give Tabula (http://tabula.technology​) a chance. However, because you are not getting anything, I suspect that this will not work either.

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