
How to Fix Columns and Rows After PDF to Excel Conversion
The spreadsheet has opened, but a price sits under "Quantity" and a long description has become two rows. This is often a reconstruction problem. A PDF positions text on a page, while a spreadsheet needs explicit cell boundaries. Keep the PDF visible and fix the structure before using the values in calculations.
Find where the alignment first goes wrong
Compare the header and the first several records in the PDF to Excel review grid. Follow one record from its identifier to its final amount. If the last value belongs to the next record, correct the boundary before editing individual numbers.
Check the same columns after each page break. A repeated page header can look like data, and a note below the table can become an extra row. Don't delete an unfamiliar line until you've checked whether it explains a unit, adjustment or subtotal.
Join descriptions without merging separate records
A product description may wrap onto another line while its quantity and price remain on the first line. Combine the description with the correct record only after checking the surrounding identifiers. Blank cells alone don't prove that the next row is a continuation.
For a fictional example, a row beginning "A104" followed by a line saying "blue cover" may describe one item. Another row with its own identifier is a separate record. Keep a note of ambiguous cases rather than deciding from spacing alone.
Protect values that look like numbers
An account reference such as "001028" is an identifier, not an amount. Keep its leading zeros. Dates and long reference numbers can also be reinterpreted by spreadsheet software when you open a CSV, so inspect the imported result.
Check commas, decimal points, currency signs and negative values against the source. "1,250.00" and "1.250,00" may follow different conventions. Don't remove punctuation across the entire sheet until you know what it means in that document.
Verify the export before calculating
Download a small corrected table and open it in the application you'll actually use. Check the headers, a record near the middle and the final record. Reconcile totals independently when they matter, because a well aligned table can still contain a wrong value.
If the source is an image only scan, rearranging the empty grid won't create missing text. The current converter needs selectable PDF text and doesn't run OCR on scanned pages. Obtain the digital original or choose a workflow that explicitly supports scanned tables.
Questions about this task
A few details to check before you start.
Final Verdict
Fix row and column relationships first, then check the values and the opened export. Keep identifiers as identifiers, and don't start calculations until the table agrees with its source.
Zarbaz Khan
Guides to OCR, document conversion and reviewing extracted text. Read the author profile for background and more articles.