How to Extract Data from a PDF to Excel - Without Breaking Your Tables

You have a PDF full of tables — a bank statement, an invoice batch, a supplier price list — and you need that data in Excel so you can sort, filter, and calculate. The obvious move is to select the table, copy it, and paste it into a spreadsheet. Then the columns collapse into one, the numbers turn into text, and the totals stop adding up.

That happens because PDFs were built to display documents, not to store data. A table in a PDF is a picture of a table: text positioned on a page, not a structured grid of cells. So extracting it is less like copy-paste and more like reverse-engineering the layout back into a spreadsheet. This guide walks through the methods that actually work, the cleanup nobody warns you about, and the checks that separate a usable spreadsheet from a confident-looking disaster.

Why Extracting Data from a PDF to Excel Isn't Copy-Paste

A PDF stores text as positioned fragments — "this word goes at x=120, y=340" — not as rows and columns. When you copy a table out of a PDF, you're grabbing those fragments in reading order, and Excel has to guess where the column boundaries were. Sometimes it guesses right. Often it doesn't, especially with merged cells, multi-page tables, or documents that mix text and tables.

The second trap is scanned PDFs. If the document is a photo of a printed page, there is no text to copy at all. The file contains pixels, not characters, so any tool has to read the image first (that's OCR — optical character recognition) before it can produce editable cells.

None of this means extraction is hard. It means the right method depends entirely on what kind of PDF you're holding. Get that right, and the rest is straightforward.

First, Identify Your PDF Type

Before choosing a tool, run a 10-second test: open the PDF and try to select the text in a table.

• If you can highlight individual numbers cleanly, you have a native (digital) PDF. It was created from a real document — Excel, a reporting tool, a database export — and the text layer already exists. These convert the best.
• If nothing selects, or the whole page selects as one block, you have a scanned PDF. It's an image. You'll need OCR, and accuracy depends on scan quality.
• If some text selects but a table is clearly a picture, you have a mixed PDF. Handle the selectable parts directly and run OCR only on the image parts.

This one check decides which method below will actually work. A native PDF and a scanned PDF need completely different tools, and using the wrong one is the most common reason people end up retyping everything by hand.

How to Extract Data from a PDF to Excel

Pick the path that matches your file. Each works best in a specific situation — there isn't one tool that wins for everything.

Copy and paste for a small, simple table

If your table is a single page, under a few dozen rows, and has clean columns, the fastest route is often no tool at all.

Open the PDF and select the table text

Copy it (Ctrl+C)

In Excel, use Paste Special > Text, or paste normally then run Data > Text to Columns to split it on tabs or spaces

This works because simple, evenly spaced tables paste with their structure mostly intact. It breaks down fast on anything larger: merged cells scatter, one row can split across columns, and numbers paste as text. If your table has more than about 10 rows and 5 columns, or any merged cells, use a converter instead — the cleanup time will exceed the few seconds you saved.

Use Excel's built-in PDF import for native PDFs

If you already have Microsoft Excel (2016 or later), you own a free, local PDF importer. It reads native PDFs, detects the tables inside, and lets you load them without uploading anything to the internet.

Open a blank Excel workbook

Go to Data > Get Data > From File > From PDF

Select your PDF — Excel shows a preview of every table it found

Pick the table you want and click Load

The advantage over copy-paste is that Excel parses the structure instead of guessing from reading order, so columns stay aligned far more often. It also creates a refreshable connection: if you get an updated PDF in the same format, refreshing re-imports the new data without redoing the work. The limitation is the same as every native-PDF method — it does nothing for scanned files, because there's no text layer to read.

Use an Online Converter or iBoomto for Quick and Complex PDFs

For a quick, one-off conversion when Excel isn't handy, browser-based converters like Smallpdf and iLovePDF do the job in a few clicks:

Open a converter (Smallpdf or iLovePDF both offer PDF to Excel)

Upload your PDF

Download the resulting spreadsheet

They're the lowest-friction option for occasional use, but your file travels to a third-party server — so for bank statements, tax documents, contracts, or anything sensitive, skip them. Free tiers also cap file size and daily uses, and complex layouts may need a paid plan for clean output.

If you'd rather use a purpose-built tool than a general converter, iBoomto's Table Extractor pulls tables out of a PDF online with the same three-step simplicity, and it keeps your workflow in one place. For the harder cases — tables that span multiple pages, merged cells, or scanned PDFs with no text layer to read — the iBoomto AI desktop client is the better fit. It runs AI-powered extraction locally on your machine, so scanned pages are read with built-in OCR and messy layouts are reconstructed into clean columns without your files ever leaving your computer. We built it for exactly the situations where rule-based converters and free tools break down: borderless tables, merged headers, and cross-page breaks, the moments when getting the numbers right matters most.

Automate recurring PDFs with Power Query

If the same report lands in your inbox every week — a bank statement, a sales export, a supplier feed — converting it by hand each time is wasted effort. Power Query (the same engine behind Excel's PDF import) lets you build a saved pipeline.

Import the PDF with Data > Get Data > From PDF

Instead of Load, click Transform Data to open the Power Query Editor

Apply your cleanup steps once: remove header rows, rename columns, set data types, filter junk rows

Save the query

Next time the new PDF arrives, point the query at it and refresh. Every cleaning step re-applies automatically. This is the method that turns a 20-minute monthly chore into a 20-second refresh — but it's worth setting up only if the format stays consistent month to month.

The Cleanup Nobody Warns You About

Whatever tool you use, plan on spending a few minutes fixing the output. These are the issues you'll almost certainly hit:

• Numbers stored as text. The single most common problem. Excel shows a small green triangle in the corner of cells holding numbers that are actually text, and formulas like SUM return zero. Fix it by selecting the column, clicking the warning icon, and choosing Convert to Number — or use Text to Columns to force the conversion.
• Merged cells lost. When the converter misses a merged header, the content may land in one cell while neighbors stay empty, or a long header splits across cells. Check the spots where the original had spanning headers and re-merge or rejoin them.
• One row becomes two. If a cell's text wraps to multiple lines in the PDF, a basic extractor may treat each visual line as a separate row, pushing every following row down by one. Catch it by checking that your row count matches the source, then manually recombine the split rows.
• Columns misaligned. Data in the wrong column usually means the tool misjudged a column boundary — common when column widths vary or some cells run long. Compare the first few rows against the PDF, find the offset, and move the misplaced block back.
• Missing decimals and lost negatives. A subtotal reading 124875 instead of 1,248.75, or a credit showing as positive instead of (412.80), are silent errors that corrupt every downstream calculation. Use Conditional Formatting to flag unusually large numbers and filter for credit keywords to confirm signs survived.
• Repeated page headers as data. Secondary page titles like "Accounts Payable Register (continued)" can land inside your table as real rows. Filter the key column, uncheck the legitimate entries, and delete the header rows in one pass.
• OCR character mix-ups. Scanned files introduce character-level risk: "0" read as "O", "1" as "l", a dropped decimal point, or a comma mistaken for a period. Scan ID columns, amounts, and dates for values that look one character off, and verify them against the source.

Verify Before You Trust: A PDF to Excel Accuracy Checklist

A converted spreadsheet can look perfect and still be wrong. Run this check before the data feeds any report, reconciliation, or analysis:

1. Confirm scope. Right PDF? Right pages? A missing appendix page silently breaks multi-page totals.
2. Check row counts. Count expected rows from the source and compare. Watch for wrapped text (one row → two) and repeated page headers counted as data.
3. Inspect headers and columns. Look for blank column names, duplicate headers, and page titles buried inside the data.
4. Test numeric formats. Find columns stored as text, inconsistent dates, missing negative signs, and leading zeros that should stay text (like account numbers).
5. Reconcile control totals. Add up the line items and compare to the total printed in the PDF. For a bank statement, confirm opening balance plus activity equals closing balance. Any mismatch means something didn't come through.
6. Hunt OCR errors. Focus on IDs, amounts, and dates. Flag cells that look one character off and verify them in the source.

Treat the converted file as unreviewed data until these pass. The few minutes of checking cost far less than a report built on a number that was never there.

FAQs About Extract Data from PDF

Can I extract data from a PDF to Excel for free?

Yes. If you have Microsoft Excel, the built-in Get Data > From PDF importer is free and runs locally. For occasional non-sensitive files, Smallpdf and iLovePDF offer free tiers. Tabula is a free, open-source option for tables in digital (non-scanned) PDFs. Scanned PDFs need OCR first; the iBoomto AI desktop client reads scanned pages locally with built-in OCR, and free OCR alternatives include Google Drive's conversion and OneNote's Copy Text from Picture.

Will formulas be preserved when I convert a PDF to Excel?

No. A PDF stores only the final calculated values, never the underlying formulas. After conversion you'll have the numbers, but you'll need to recreate any SUM, VLOOKUP, or other formulas yourself.

Can a multi-page PDF be extracted into one Excel sheet?

Yes. Most converters extract all pages into a single workbook, placing each detected table in order. Very long or complex documents may split tables across sheets — check the output and consolidate if needed.

What if my PDF is scanned and won't select text?

It needs OCR first. Run optical character recognition to create a text layer, then convert. The iBoomto AI desktop client does this locally with built-in OCR; free routes include Google Drive (open the PDF with Google Docs) and OneNote (copy the image, right-click, Copy Text from Picture). Scan quality matters — aim for 300 DPI or higher, good contrast, and straight pages.

Is it safe to upload PDFs to online converters?

For non-sensitive files, yes. For anything with personal, financial, legal, or commercial data — bank statements, tax returns, contracts, client lists — use a local tool instead. Uploaded files leave your computer and pass through servers you don't control, which can violate privacy rules like GDPR or HIPAA and exposes you to breaches. Desktop software like the iBoomto AI desktop client or PDF24 processes files on your own machine.

Conclusion: Get the Data Out, Then Make Sure It's Right

Extracting data from a PDF to Excel comes down to three moves. First, identify your PDF — native or scanned decides the tool. Second, pick the method that fits: copy-paste for tiny tables, Excel's free importer for native PDFs, an online converter for quick non-sensitive jobs, iBoomto for complex or scanned files, and Power Query when the same report repeats. Third, and most often skipped, clean up and verify the output before you trust it.

The hidden cost of PDF to Excel isn't the conversion — it's the cleanup and the checking. Converters keep getting better at detecting table structure, and AI-assisted tools are closing the gap on merged cells and borderless layouts. We're also expanding to include AI-powered document processing at iBoomto, with the goal of making document workflows like this simpler and more accessible — but regardless of the tool, the rule stays the same: a spreadsheet that looks right isn't right until the totals reconcile.