8 Replies Latest reply on Jul 6, 2017 3:57 PM by Dov Isaacs

    Frustrated Adobe Acrobat Pro DC user - can't convert PDF to Excel

    Prekus Level 1

      Bank of America statements won't convert to excel. This is the only reason that I license your product. I need to convert these to Excel for tax review purposes. Nothing special about the files. I've tried changing the files (1 worksheet for all, 1 sheet per page, 1 sheet per table) but nothing works. I have read through your FAQs and other questions and there is NO HELPFUL information on this problem. Your forum admins keep marking the problem as answered after they say "its a problem with the PDF". That is not acceptable as many of the posts indicate that your competition converts the files just fine. I am requesting an escalation of this issue to the next level of support. I need this issue resolved or I need you to tell me you can't do it so I can cancel my subscription and go find a working option.

       

      This is what I get

      Some of it works...but not the actual data

        • 1. Re: Frustrated Adobe Acrobat Pro DC user - can't convert PDF to Excel
          Dov Isaacs Adobe Employee

          Generally speaking, this problem is the symptom of an improperly created PDF file in which some type of unusual font and font encoding is used. One way to check this out is to try simply copying and pasting from text from one of these PDF files to a Word document. If what you get is the same “gibberish” in the Word document using copy and paste, then in fact the issue is the PDF file's encoding and there really isn't anything that Adobe can do about that.

           

          (It may be Bank of America, but it is amazing how many PDF files coming out of “enterprise” systems have somewhat unusual and/or defective encoding of their content.)

           

          Please let us know what you find from that experiment. (We understand that you might be fairly reluctant to post the file for us to examine!)

           

                    - Dov

          • 2. Re: Frustrated Adobe Acrobat Pro DC user - can't convert PDF to Excel
            Bernd Alheit Adobe Community Professional & MVP

            Try this:

            Save the file as TIFF files, combine the TIFF files in Acrobat, and convert it to Excel.

            • 3. Re: Frustrated Adobe Acrobat Pro DC user - can't convert PDF to Excel
              Prekus Level 1

              This data will cut and paste into Word perfectly.

               

              I've downloaded a trial of Nitro Pro 11 and it works like a champ.

               

              So, your competition can do it, but again, the answer is, its a bad PDF and Adobe can't solve the problem? From one of the largest banks in the country? Isn't there a process to get a sample from the source, review it and figure this out?

              • 4. Re: Frustrated Adobe Acrobat Pro DC user - can't convert PDF to Excel
                Prekus Level 1

                Ok, that worked. Its a functional, but tedious and ugly work-around. For those that don't know how, here are the steps.

                 

                Create TIFF format file(s). I ended up with 10 TIFF files per statement

                1. Open PDF file in Adobe DC

                2. File/Save As/Choose Save location/Set "Save as type" to TIFF

                3. Save 

                You will likely get more than one TIFF file. Be sure to track this as its important in the next step. If you have multiple PDFs that you need to process through this work-around, then I recommend that you clean them up (delete TIFF files) after each file is processed.

                 

                Now you have to "combine" these files into a new PDF. You can open them all at once by selecting multiple files then combine from within Adobe or you can select files in their location without opening and then "combine"

                1. Tools

                2. Choose combine files

                3. Select method (already opened files or from their location)

                4. Select files, hit Open button

                5.You should get a screen showing your selected TIFF images/files, hit Combine in upper left of Adobe screen

                6. Green check marks will appear as they are processed, and you will get a new PDF with the name "Binder#"

                 

                Now export to Excel

                1. Tools/Export/Excel to get the date into the spreadsheet

                     a. Tested with all data imported into one worksheet

                     b. Tested with data imported into separate worksheets per page

                 

                Thank you for the work around, now, how about a fix?

                • 6. Re: Frustrated Adobe Acrobat Pro DC user - can't convert PDF to Excel
                  Prekus Level 1

                  Bernd, thank you for your support...it was helpful and very much appreciated. I did not mean to direct my frustration to you, didn't realize you weren't on Adobe staff.

                  • 7. Re: Frustrated Adobe Acrobat Pro DC user - can't convert PDF to Excel
                    Karl Heinz Kremer Adobe Community Professional

                    Most of the people you find here on the Adobe forums are not Adobe employees, but users of Adobe's different applications. As you can see when you scroll up, Adobe employees are identified with a "Staff" badge.

                     

                    The fact that you can copy and paste into Word and get the correct content does point to a problem in Acrobat. You may want to file a bug report here: Feature Request/Bug Report Form That is the only reliable way to notify Adobe of a problem in their products.

                    • 8. Re: Frustrated Adobe Acrobat Pro DC user - can't convert PDF to Excel
                      Dov Isaacs Adobe Employee

                      To be very clear, I did not say that your particular files were bad but that in the past we saw this type of symptom with some bad PDF files.

                       

                      Thanks for testing the copy-and-paste text. That would indicate that in fact you have found a real issue. What we need to be able to do is analyze the issue and fix it. However, without a sample file, that is difficult.

                       

                      If you could contact me with a private message and a pointer to such a sample, I'll gladly pursue this within Adobe and we will maintain the confidentiality of the sample file.

                       

                                - Dov