Skip to main content
earlw79954880
earlw79954880
Participant
June 29, 2018
Answered

Converting PDF to Excel with separate cells

  • June 29, 2018
  • 1 reply
  • 13279 views

Hello,

I am trying to export a report PDF to excel. When I convert it, it puts all of the information from one row of the report into one cell. Is there a way to dictate it to go into multiple cells?

There is also a ridiculous amount of spacing between rows. How would I change this?

Thanks for your help.

    Correct answer MichaelKazlow

    The way that pdf files get exported to Excel depends upon how the files are created. Some pdf files will have information contained in the file to make the conversion easier. Frequently, I find it easier to covert to text and use a good text editor to massage the data for ease of entry to a Excel. By text editor, I mean just that and not a Word Processor, they are two different animals.

    1 reply

    MichaelKazlow
    MichaelKazlowCorrect answer
    Legend
    June 29, 2018

    The way that pdf files get exported to Excel depends upon how the files are created. Some pdf files will have information contained in the file to make the conversion easier. Frequently, I find it easier to covert to text and use a good text editor to massage the data for ease of entry to a Excel. By text editor, I mean just that and not a Word Processor, they are two different animals.

    P
    Paul236171821y2n
    Participant
    March 16, 2022

    Adobe HAS changed the way the export to Excel over the years.  We still have users using Acrobat Pro 2017 and that version works as intended.  Instead of exporting one giant column with all the rows combined into one row of text (like the current version)... it will export each row in a table as its own row. We are using the exact same source file. We have checked the preferences and all of the settings are the same for the export.

     

    Adobe changed something and they need to change it back... what is the point of paying for this feature if it doesn't work.

    Meenakshi Negi
    Community Manager
    Meenakshi NegiCommunity Manager
    Community Manager
    March 30, 2022

    Hi Paul,

     

    Thank you for reaching out, and sorry about the trouble.

     

    As mentioned above, the Export PDF feature does not convert the Excel files correctly. We have tried exporting Excel files, and it works fine on our end. 

    Please try exporting files on the Acrobat Online account and see if you receive the same results. Open the following link and sign in using your Adobe credentials. Then go to Convert > Export PDF.

     

    Would you mind sharing more details about the issue to investigate this issue further?

    Please share the sample PDF and the Excel file created from the PDF. It will help us to understand the issue better.

    Please check if it is an issue with all the files.

    Share the Acrobat And OS version you are using.

     

    Let us know if you need any help.

     

    Thanks,

    Meenakshi

     

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices