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

Converting PDF to Excel with separate cells

  • June 29, 2018
  • 1 reply
  • 13412 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.

    D
    diego24321406mncs
    Participant
    May 4, 2022

    The version that works correctly is 2017 Pro.  I have attached the PDF.  When the user with 2017 converts to Excel then each row in the table becomes a row in the spreadsheet. 

     

     

    When we use the newest version of Acrobat Pro DC, the entire column in the table becomes one row in the spreadsheet.

     


    Meenakshi, I am having the exact same problem as Paul. Has this issue been resolved?

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