Skip to main content
rafaelr81367283
Participant
September 22, 2017
Answered

When I convert a pdf to an excel file it completely changes the format of the doc. How do I correct this?

  • September 22, 2017
  • 2 replies
  • 574 views

I have a form that I am trying to convert from pdf to an excel file. When I convert the file the format of the doc changes. How do I convert it and keep the original format?

This topic has been closed for replies.
Correct answer Karl Heinz Kremer

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

Unfortunately there is not much you can do to improve the output without spending a lot of time (e.g. by manually tagging the file). Also, if you are using Adobe's ExportPDF service and don't have access to Acrobat, that is not even an option.

The only thing you can do is complain to the original author of the file and tell them that they used a bad PDF generator to create the PDF file.

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.

2 replies

Karl Heinz  Kremer
Community Expert
Karl Heinz KremerCommunity ExpertCorrect answer
Community Expert
September 22, 2017

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

Unfortunately there is not much you can do to improve the output without spending a lot of time (e.g. by manually tagging the file). Also, if you are using Adobe's ExportPDF service and don't have access to Acrobat, that is not even an option.

The only thing you can do is complain to the original author of the file and tell them that they used a bad PDF generator to create the PDF file.

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.

Michael J. Hoffman
Community Expert
Community Expert
September 22, 2017

I’ve moved this post from the non-technical Lounge to the Acrobat specific Editing and Exporting PDF forum.

Converting a PDF to Excel is one of the most complicated things you can try, and the results are often unpredictable. It would be helpful if you can explain with a little more detail, and perhaps even show some example areas where the format is changed.

Mike