A field guide to getting PDF reports into Excel intact

Convert PDF to Excel Tools exists for one narrow, deeply annoying job: taking a report that only exists as a PDF and ending up with a workbook whose numbers add up. Everything here is organised around the places that job breaks.

What we cover

The site is built as a field board — the parts of a conversion that go wrong, grouped the way they actually fail. Structure first: merged cells, headers and footers that repeat on every page, rows that wrap across two lines, columns that arrive fused together. Then the values: numbers stored as text, negatives written in parentheses, currency symbols and thousands separators that stop a column from summing, dates parsed into the wrong century. Then the rebuild: putting subtotals back as live formulas, reshaping an export into something you can pivot, and checking the converted totals against the source before anyone relies on them.

The last group is the tool decision itself — desktop applications against browser converters, when OCR is unavoidable because the PDF is really a scan, how well each tool detects table boundaries, what batch conversion is worth, and what happens to a confidential document once it has been uploaded to a web service.

How the guides are written

Every comparison starts from the same set of awkward source documents rather than from a marketing page: a multi-page statement with repeating column headers, a scan that needs OCR, and a report with merged header cells and footnote markers sitting inside the data. Running the same files through each tool is the only way the differences we describe are differences in the tool.

We describe outcomes in words, not in invented numbers. There are no scores on this site, no star ratings, no leaderboards and no percentage accuracy claims — those numbers are almost always unverifiable, and they hide the thing you actually need to know, which is which document types a given converter handles badly. Where a problem has a fix inside Excel, we write the steps out; a workaround that takes ninety seconds is better advice than a purchase.

Tools change. Pages get revisited when a converter meaningfully changes its output, its pricing model, or its handling of scanned files, and anything we can no longer stand behind gets rewritten or removed rather than quietly left up.

Affiliate disclosure

Some of the outbound links on this site are affiliate links. If you follow one and buy a subscription or licence, we may earn a commission at no additional cost to you. That commission is what pays for the time spent testing conversions and writing the guides.

It does not buy anything else. Affiliate relationships do not determine which tools we cover, the order they appear in, the wording of a recommendation, or whether we point out that a tool is a poor fit for your documents. Products with no affiliate programme at all are covered on exactly the same terms, and where a free or built-in Excel feature does the job, we say so instead of routing you to a paid product. We are not affiliated with, endorsed by, or sponsored by Microsoft, Adobe, or any of the vendors discussed here.

Corrections and contact

If a walkthrough no longer matches what a tool does, if a step is wrong, or if you have found a conversion problem the board does not cover, tell us — corrections from people doing this work every day are the fastest way this site improves. Write to [email protected].

You can also read our privacy policy and terms of use, or head back to the field board.