How to extract data from a PDF into Excel
A PDF looks like a table but isn't one. Here are the four realistic options for getting delivery dockets and supplier price lists into a spreadsheet, and where each one falls down.
Try it on your own PDFEncrypted files
Protected in transit and at rest
Private to your account
Never used to train AI models
Payments by Stripe
We never store your card number
Test before you buy
Check accuracy on your own docket
1. Copy and paste
Free and instant, and it works for a five-row table you only need once. Beyond that, a PDF stores positioned text rather than rows and columns, so everything lands in a single column and wrapped descriptions push prices onto the wrong line.
- Best for: tiny, one-off tables
- Fails on: anything multi-column, multi-page or scanned
2. Excel's built-in PDF import
Data → Get Data → From File → From PDF uses Power Query to detect tables. On a clean, digitally generated PDF with ruled lines it does a decent job, and the query can be refreshed when the file is replaced.
- Best for: consistent, digital, well-ruled tables
- Fails on: scans and photos, repeated page headers, layouts that change between suppliers
3. Template-based extraction tools
You draw boxes over a sample document to say where each field lives, and the tool applies that map to future files. Accurate while nothing changes — but every new supplier needs a new template, and a supplier redesigning their docket silently breaks the old one.
- Best for: high volume from a small, stable set of suppliers
- Fails on: variety, and quietly, which is worse
4. AI document extraction
Instead of matching coordinates, the document is read for meaning: this block is the line-item table, this column is a product code, this row is a total and should be skipped. Because nothing is anchored to a position, a layout it's never seen before works first time, and scans are handled like any other page.
- Best for: mixed suppliers, scanned and photographed documents, ongoing volume
- Trade-off: a per-document cost rather than a one-off setup
Which should you use?
If you convert a handful of clean PDFs a year, Excel's own import is enough. If delivery dockets and supplier price lists land weekly from a dozen suppliers in every format from crisp PDF to a photo taken in a van, the setup cost of templates never pays back — that's the case DocketFlow is built for.
Frequently asked questions
- Why does copy-paste from a PDF break in Excel?
- A PDF stores positioned text, not a table. Copying gives you a stream of characters, so Excel drops everything into one column and merged or wrapped cells scramble row order.
- Does Excel's own 'Get Data from PDF' work?
- It can, on clean digital PDFs with simple ruled tables. It fails on scans, on multi-page tables with repeated headers, and whenever the layout varies between suppliers.
- What about scanned or photographed documents?
- Those have no text layer, so copy-paste and Power Query find nothing at all. You need a tool that reads the image itself.
- How accurate is AI extraction?
- On readable trade paperwork it handles the vast majority of rows correctly. Anything it can't read confidently is flagged as failed rather than silently guessed at.
- Do I need a different setup for each document layout?
- Not with DocketFlow. Template-based tools need configuring per supplier; reading the document semantically means a new layout works the first time.
Stop re-typing paperwork
Check accuracy on your own test document free within 7 days. No card needed, no automatic charge.
Get started