Fix Numbers and Columns After PDF to Excel Conversion
Check text-formatted amounts, dates, merged cells and missing columns after extracting PDF tables.
A PDF can display a neat table without storing spreadsheet cell boundaries. When converting a text-based PDF to Excel, review the generated workbook before using it for totals or reports.
Check rows and columns
Compare the PDF's first and last rows with the XLSX output. Wrapped descriptions may appear on separate lines, repeated page headers may appear inside the data, and visually aligned columns can require manual adjustment.
Make values usable in formulas
Check whether numeric amounts were imported as text. Remove unintended spaces or currency characters only after checking their meaning. Preserve leading zeros in account identifiers and reference numbers. Check decimal separators, percentages and dates against the original PDF.
Reconcile totals
Pick a subtotal or total shown in the original PDF and calculate it again in Excel. If values differ, inspect skipped rows, signs, duplicate headings and shifted columns. Do not use converted financial figures without validation.
Try the converter
Use PDF to Excel for selectable-text PDFs up to 20 MB. Scanned images need OCR first; the converter does not automatically recognize scanned text. For a general walkthrough, see extracting PDF tables to Excel.