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

[KS3751]

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?

[Sara_Forsberg · Accepted solution]

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