Extract Image to Text – OCR Tool LogoMenu
Incorrect PDF table columns being reviewed and corrected in a spreadsheet

How to Fix Columns and Rows After PDF to Excel Conversion

Last Updated:
3 min read

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.

The PDF may repeat headers, change spacing or wrap descriptions differently. Compare the first records on each new page with the source.
No. The converter exports reconstructed values, not the formulas from the spreadsheet that may have produced the PDF.

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

Zarbaz Khan

Guides to OCR, document conversion and reviewing extracted text. Read the author profile for background and more articles.

Tags:

fix PDF to Excel errorsPDF to Excel columns wrongPDF table extraction errorsPDF to Excel formattingPDF to XLSX