PDF to Excel: 6 Checks Before You Trust the Numbers

Getting a table out of a PDF and into Excel is easier than it used to be. In Excel for Microsoft 365 on Windows, Data → Get Data → From File → From PDF can pull tables straight in, and plenty of converters do the same. The hard part isn’t the conversion — it’s trusting the result. These six checks catch most problems before they reach your reports.

1. Are your numbers really numbers?

Converted values often arrive as text. The giveaway: they line up on the left, show a small green triangle, or SUM returns 0. Test a column with =ISNUMBER(C2). To fix it, select the column and use Data → Text to Columns → Finish, or use =VALUE(C2) in a helper column. Watch for currency symbols, thousands separators, and non-breaking spaces that block the conversion.

2. Do negative numbers survive?

Accounting PDFs show negatives as (1,250.00) or 1,250.00-. Some converters turn these into positive numbers or text. Filter the column for “(” and “-” and make sure each one became a true negative value. One flipped sign can throw off a whole month’s totals.

3. Do the dates mean what you think?

Is 03/04/2026 March 4 or April 3? If the PDF came from outside the U.S., day and month may be swapped, and Excel may silently convert some rows while leaving others as text. Check a few dates where the day is above 12 — those reveal the true format — then convert the whole column consistently.

4. Did headers and page breaks sneak into the data?

Multi-page PDFs repeat the header row and page footers (“Page 2 of 9”) on every page. After conversion they show up as rows in the middle of your data. Sort or filter each column and look for repeated header text, blank rows, and subtotal lines that should be removed or moved to their own column.

5. Do the totals reconcile?

This is the single most valuable check. If the PDF prints a total, compare it to =SUM() of your converted column. Do the same with row counts: if the report says 214 invoices, your sheet should have 214 rows. When totals match, you can be confident nothing was dropped or doubled.

6. Spot-check scanned pages by eye

Scans and photos go through OCR, which commonly confuses 0 and O, 1 and l, 5 and S, and 8 and B. Pick a handful of rows from every page, compare them to the original, and highlight anything you can’t read clearly rather than guessing. A flagged cell is a two-minute fix; a wrong invoice number found three months later is not.

Run these six checks every time and PDF conversion stops being a gamble. Typed digital PDFs usually pass quickly; faded scans and handwriting need more care — and sometimes a human doing careful data entry is still the most accurate option.