Start with a file

PDF Tables to Excel or CSV: Fix Columns and Check Numbers

By Tabulyn

Start with a digital PDF containing selectable text. Extract its tables, correct the preview, and export XLSX for typed spreadsheet values or CSV for plain-text data exchange. Always verify important figures against the source.

Check the PDF before uploading

Try selecting a sentence in your PDF reader. If the page is only a picture, the table extractor cannot rely on normal PDF text. Use the original digital export when available. OCR can recognize text, but it does not guarantee that a scanned table will become a usable grid.

The table upload flow accepts PDFs up to 10 MB and 30 pages. Remove a known password before extraction. For longer reports, extract the pages you need and keep enough context to identify the correct column headers and units.

Review the preview instead of trusting appearances

Check the first and last data row, headers, column alignment, negative amounts, decimal separators, and totals. A table can look rectangular while values have landed in the wrong column. Correct cells in the preview before exporting.

Repeated headers can help recognize a table continued across pages, but a changed layout may produce separate tables. Check the page boundary for missing or duplicated rows. Invoice conversion extracts table line items; do not assume it also extracts header fields such as invoice number, vendor address, or payment terms.

Choose XLSX or CSV for the next task

XLSX supports multiple worksheets and cell types. Tabulyn attempts to recognize numbers, currency, percentages, and ISO dates so spreadsheet operations can use real values. Ambiguous data still needs your review, especially identifiers with leading zeros or unfamiliar number formats.

CSV is a text format. Import settings in the receiving application determine delimiters, encoding, date interpretation, and whether identifiers remain text. For multiple tables, inspect each output rather than assuming one CSV represents an entire multi-table report.

Reconcile financial data with the source

For a bank statement, compare opening and closing balances and check a sample of credits and debits, including transactions at page boundaries. Extraction does not categorize transactions or certify their accuracy.

For an invoice, compare quantities, unit prices, discounts, tax, and the stated total. Do not overwrite the original document with the spreadsheet or use unverified extracted figures for an important decision. Practice with the fictional invoice sample before deciding whether to upload a real document.

Tools for this workflow