Skip to main content
Participant
April 20, 2015
Answered

Why is data missing when pdf file is converted to excel?

  • April 20, 2015
  • 1 reply
  • 3040 views

I converted bank statements to Excel and only one statement converted correctly.  All others had lines from bank statement but no data.  Do not understand why one pdf converted correctly and others did not?

This topic has been closed for replies.
Correct answer Sara_Forsberg

Hi ks3751,

The issue is most likely with the quality of the PDF that you're converting to Excel (do they all come from the same bank)? Depending on how the bank generates those statements, it's possible that they aren't written to spec, and don't contain all the information necessary to ensure a clean conversion.  Please see Will Adobe ExportPDF convert both text and form... | Adobe Community.

You may have better luck by disabling OCR as described in this document: How to disable Optical Character Recognition (O... | Adobe Community.

Best,

Sara

1 reply

Sara_ForsbergCommunity ManagerCorrect answer
Community Manager
April 20, 2015

Hi ks3751,

The issue is most likely with the quality of the PDF that you're converting to Excel (do they all come from the same bank)? Depending on how the bank generates those statements, it's possible that they aren't written to spec, and don't contain all the information necessary to ensure a clean conversion.  Please see Will Adobe ExportPDF convert both text and form... | Adobe Community.

You may have better luck by disabling OCR as described in this document: How to disable Optical Character Recognition (O... | Adobe Community.

Best,

Sara