1 Reply Latest reply on Mar 24, 2017 9:08 AM by Karl Heinz Kremer

    Problem converting PDF to Excel

    paulo13221146

      I have converted a PDF to Excel using the website converter but the results in the excel file are not recognisable - see below. Is there a way to make sure the conversion results in recognisabe text and numbers. The table below is a bank statement and the columns should show date, date, idintifier, description (text). amount from left to right.

        • 1. Re: Problem converting PDF to Excel
          Karl Heinz Kremer Adobe Community Professional

          What you see is usually the result of a bad PDF file: The file does not contain important information that is used by Acrobat (or the online service) to map "drawings of characters" (or glyphs) back to one or more characters that can then be exported in e.g. a Word or Excel document. Specifically, the "ToUnicode" table is missing or corrupt. If you only have access to the online converter, there is nothing you can do to improve the results. With the desktop version of Acrobat, there may be a workaround: 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.

           

          You may want to complain to your bank about this.