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/).
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.
- 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.