# How to check a spreadsheet against its source PDF (and catch AI copy mistakes)

> A table typed from a PDF, or produced by an AI assistant, can have one wrong figure that looks fine. How to check every number against the source PDF, and what an automatic check can and can't prove.

- Published: 2026-11-05 · 6 min read
- Tags: Excel, Verification, AI tables
- Canonical page: https://pdfhandle.com/blog/check-spreadsheet-against-pdf

Copying a table out of a PDF is one of the most common jobs in finance and real estate. Whether the table was retyped by hand, pasted from a converter or produced by an AI assistant, the result usually looks right. The trouble is the one figure that isn't: a transposed digit, a dropped line, a row that was never in the document.

Those mistakes are hard to spot because nothing about them looks wrong. The number is the right size, it sits in the right place, and the spreadsheet may even add up.

## Two different questions

- Does the spreadsheet add up? Every Total and Subtotal should equal the rows it adds. You only need the spreadsheet to answer this.
- Does the spreadsheet match the PDF? Every figure should be one the PDF actually prints. You need both files to answer this.

A sheet can pass the first test and still fail the second. If a figure was copied wrong and the total was then recalculated from it, the sheet adds up perfectly and is still wrong.

## Checking by hand

1. Start with the totals. If a total in the sheet differs from the PDF's, something under it is wrong.
2. Tick off every figure in the sheet against the PDF, line by line, rather than sampling a few.
3. Count the rows. A line the PDF has and the sheet lacks will not show up as a wrong number.
4. Check the columns. Two values swapped inside a row keep the row total the same but are still wrong.

It works, but it is slow, and it is easy to stop checking once the first few rows match.

## Checking automatically

PDFHandle's spreadsheet-vs-PDF check takes both files and does those steps for you:

*(Animation: a PDF and an AI-made spreadsheet side by side. Each spreadsheet row is matched to a PDF line by its figure even though the rows are reordered and renamed; a transposed figure (371,520 instead of 371,250) is flagged and the result is Mismatch.)*

1. We read the PDF with our own deterministic reader and check the PDF's own totals, so we know its figures were read correctly.
2. Every row of your spreadsheet is matched to a row in the PDF by its figures. Labels don't matter, so a sheet that reorders or renames rows still matches.
3. Anything that doesn't match is listed with the row, what your sheet says and what the PDF has. Rows in the PDF that are missing from your sheet are listed too.
4. Figures sitting in a different column than in the PDF, such as two values swapped inside a row, are caught as well.

> **Note:** A spreadsheet is only marked Verified against a PDF whose own totals tie. If the PDF itself can't be proven, the best possible result is Review, never Verified.

## What it can't tell you

- Labels. Rows are matched by their figures, so a label that was changed or mistyped is not detected.
- Scanned PDFs. The PDF needs a real text layer; a scan or a photo gives nothing reliable to compare against.
- Your own calculations. A figure you worked out yourself is not printed in the PDF, so it shows as not found. Keep calculations on a separate sheet: sheets that aren't a copy of the PDF's figures are listed and skipped.

## Only have the spreadsheet?

Without the source PDF you can still answer the first question. The free spreadsheet checker at pdfhandle.com/check-spreadsheet re-adds every Total and Subtotal row, and every Total column across months, quarters or years, and shows the exact cell of any total that doesn't add up.

## Privacy

Both files are processed in memory on our own server and are not stored. The check is plain matching and arithmetic: no third-party AI or cloud service sees your documents.

## Frequently asked questions

### Is it free?

Checking whether a spreadsheet's own totals add up is free with no sign-up. Checking a spreadsheet against a PDF counts as one conversion from your monthly free allowance, because the PDF has to be read.

### Does it work with tables from ChatGPT, Claude or other AI tools?

Yes. It doesn't matter where the spreadsheet came from: typed by hand, exported from another tool or produced by an AI assistant. Save it as .xlsx or .csv and upload it with the PDF it came from.

### What does Mismatch mean?

A figure in your spreadsheet is not in a PDF whose own totals were proven, or a figure sits in a different column than it does in the PDF. Each one is listed with what your sheet says and what the PDF has.

### What files can I use?

An Excel (.xlsx) or CSV spreadsheet, and a text-based PDF, each up to 50 MB.

---

[Check a spreadsheet against its PDF](https://pdfhandle.com/verify-excel-against-pdf)

Source: PDFHandle (https://pdfhandle.com)
