Skip to main content

PDF to Excel, field by field

Drop the messy parts of your report onto the board and get a workbook that calculates.

Most PDF conversions technically succeed and practically fail: the numbers land as text, the header repeats on every page, the merged cells become blanks, and the totals stop adding up. We work through those failures one field at a time — with the Excel fix, and an honest read on which converters get it right the first time.

Rows what each line of the report is
Line itemsMerged cellsRepeating headersWrapped rowsFootnote lines
Columns how the report is split across the page
Period columnsStacked headingsSplit columnsUnits & currencyPage breaks
Values the parts Excel has to be able to calculate
Numbers stored as textNegatives in bracketsThousand separatorsRebuilt formulas

The field board

Pick the field that broke your sheet

Coverage is grouped the way a conversion actually fails — structure first, then the values, then rebuilding the workbook, then the tool decision. Guides and comparisons attach to these groups as they are published.

Group 01

Formatting & structure

The layout problems that survive the export: merged cells, header rows that repeat on every page, and text that wraps into rows of its own.

Merged cellsRepeating headers & footersWrapped header textMulti-line rowsSplitting one column into twoPage-break artefactsIndented row hierarchies
Group 02

Recovering the numbers

Everything that lands in Excel looking right but refuses to add up, and the fastest way to coerce each one back into a real value.

Numbers stored as textNegatives in parenthesesCurrency & unit symbolsThousands separatorsDates parsed wrongFootnote markers in cellsTrailing spaces
Group 03

Rebuilding the workbook

Converting is only half the job. This group covers putting the sheet back into a shape you can calculate on, pivot, and hand to someone else.

Rebuilding SUM & subtotalsPercentage columnsPivot-ready layoutsNamed rangesSplitting reports into sheetsData validationChecking totals against the PDF
Group 04

Choosing a converter

Head-to-head comparisons and buying advice: what desktop tools do that browser tools cannot, where OCR is unavoidable, and what happens to your file once it is uploaded.

Desktop vs browser toolsBatch conversionOCR for scanned reportsTable detection qualityUpload limits & privacyPricing modelsFree tool trade-offs

How we judge

What our recommendations rest on

No scores, no leaderboards, no invented percentages. Just the same documents run through every tool, and a plain description of what came back.

Same file, every tool

We convert the same documents

Every converter we write about gets the same awkward source files — a multi-page financial statement, a scanned invoice, a report with merged header cells — so the differences we describe are differences in the tool, not in the test.

Named limits

We say where a tool falls apart

A converter that nails clean digital tables and mangles scanned ones is useful information, not a failure to report. We name the document types each tool handles badly instead of rounding everything up to "great".

Disclosure

Affiliate links never set the order

Some outbound links earn us a commission. They do not buy placement, wording, or a recommendation — and any page carrying them says so. Tools with no affiliate programme are covered on exactly the same terms.

Fixes, not verdicts

We show the repair, not just the flaw

Where a conversion problem has a workaround inside Excel — Text to Columns, Power Query, a find-and-replace, a paste-special multiply — we write the steps out rather than telling you to buy something.

Using the board

Three moves, start to finished sheet

Step 01

Find the field that broke

Scan the board for the thing that actually went wrong in your conversion — a merged header, a column of numbers Excel treats as text, a total that no longer recalculates.

Step 02

Read the fix

Each group leads to walkthroughs written against real report layouts, with the Excel steps spelled out and a note on when the cleanup is faster than re-converting.

Step 03

Compare tools on that job

Once you know which part of the job is hard for your documents, the comparisons tell you which converters handle that part well — and which ones you can skip.

Start with the broken field

Get the report out of the PDF and into a real workbook

Work through the board group by group, fix the fields that matter for your documents, and use the comparisons only once you know which part of the job is the hard part.

Open the field board How this site is edited