0

I needed to compile data from a PDF into an Excel spreadsheet for further analysis. Each PDF page begins with "Unclassified" at the top and a row with the column headings. I used NitroPDF for the conversion from PDF to Excel (pdftoexcelonline.com/en/).

PDF of data

It seemed to work great and I proceeded to convert thousands of entries. However, upon review I noticed that each new PDF page seems to have created a new column in my Excel sheet. Excel columns

Questions: I have thousands of entries.

  1. Is there any way to remove these extra columns while preserving data integrity and formatting?

OR... 2. Is this a task better handled during the initial conversion from a PDF to an Excel file and, if so, can someone recommend how to do this?

Thank you.

2
  • Can you share the PDF input file?
    – Edi
    Nov 14, 2016 at 8:38
  • Thanks for your response, I ended up converting to MS Word then to Excel which solved my problem. Here is the link, its to the US CENTCOM FOIA website (your browser will give you security warnings when you click on it, all .mil sites do for some reason): www6.centcom.mil/foia_rr/FOIA_RR.asp?Path=/…
    – Chris_80
    Jan 27, 2017 at 14:51

0

You must log in to answer this question.

Browse other questions tagged .