I have Financial Statements like the Statement of Assets and Liabilities that I have had difficulty converting from a PDF file to an excel using Acrobat X Pro.
In the Statement of Assets and Liabilities you have one column with descriptions of Assets and Liabilities and a second column with numerical values. My problem is sometimes when converting from PDF to excel the asset and liabilities share the same cell as the numerical value and other times they are in different cells.
What I am trying to achieve is consistently having an excel file with numerical values in a separate column. I have been told that the PDF that I am trying to convert may be too complex for the optical character recognition (OCR) technology used in Acrobat X Pro. Does anyone have any suggestions?
In a practical sense there's not a lot you can do - if Acrobat is trying to export a scanned file it has no idea what the structure is, so has to make guesses based on the X/Y position of each text object (it can't see the borders or fills as those aren't OCRed). If your PDF came from an authoring application and had structure tags it would export perfectly, but putting tags onto a table in an OCRed file is a nightmare of a job - it'd be quicker to type it out again in Excel.
Europe, Middle East and Africa