Skip to content
TryDocsy

PDF to Excel

Extract tables and data from PDF into Excel spreadsheets

Loading PDF to Excel Converter...

100% Private: All processing happens in your browser. Your files never leave your device.

This tool extracts tabular data from a text-based PDF (up to 100 MB) into a real Excel workbook, in your browser. Rather than splitting each row into columns based on that row alone, it clusters cell start positions across the whole page first, so a column consistently means the same field on every row — a blank cell stays blank instead of shifting the values to its right into the wrong column, which is the usual way naive PDF-table extraction goes wrong on real-world documents. Rotated pages are handled correctly too, and every PDF page becomes its own worksheet in the output, rather than one long sheet with page-break marker rows mixed into the data.

Numbers get special treatment: with “Write numbers as numbers” checked (on by default), amounts like $1,204.55 are written as genuine Excel numeric cells, so SUM, AVERAGE, sorting and pivot tables all work on them directly — while long digit strings such as order IDs or account numbers are always kept as text so Excel never silently rounds or reformats them. What this tool can't do is understand a table the way a person can: complex merged cells, multi-row headers and unusual layouts may not come out perfectly aligned, and it needs an actual text layer to work with — a scanned statement or receipt has to go through the OCR tool first.

How it works

  1. 1. Drop your PDF

    Upload one text-based PDF, up to 100 MB.

  2. 2. Leave numbers typed, or turn it off

    “Write numbers as numbers” is checked by default so amounts become real Excel numbers for SUM, sorting and pivot tables; long digit strings like order IDs stay text regardless. Uncheck it if you want every cell kept exactly as printed.

  3. 3. Press Convert to Excel

    It works through Loading PDF…, Parsing document…, and Reading page N of M…, then Building workbook… — extracting a grid per page and assembling the workbook, all in your browser tab.

  4. 4. Check the preview, then download

    A preview table shows the first rows of the first sheet with its column and row counts; right-aligned cells are the ones stored as real numbers. Press Download Excel (.xlsx) once it looks right.

When you'd use it

  • Pulling transactions out of a bank statement

    Bank and card statements are usually the cleanest kind of PDF table to extract — consistent columns for date, description and amount, row after row — which is exactly the layout this tool's whole-page column clustering is built to handle well.

  • Checking totals after converting a PDF invoice or bill

    Once numeric amounts are written as real Excel numbers rather than text, you can add a SUM formula under an extracted amount column and compare it against the total printed on the original PDF, as a quick sanity check that nothing was misread.

  • Getting a fee or marksheet table into a spreadsheet

    Exam fee structures, marksheets and result tables published as PDF convert into a workbook you can sort, filter or reuse in a spreadsheet, instead of retyping the numbers by hand.

  • Reusing a supplier price list published as PDF

    A vendor's PDF price list or rate card becomes an editable spreadsheet you can filter, compare against other suppliers, or paste into your own costing sheet.

Which tables extract cleanly

Tables extract most cleanly when columns are consistently spaced across the whole page — bank statements, invoices, simple price lists and fee tables all fit this pattern well, because the tool clusters column start positions across every row on the page rather than guessing column boundaries row by row. A blank cell in one row doesn't drag the following values one column to the left, which is the most common way this kind of extraction normally breaks.

Tables extract less predictably when a layout uses merged cells, multi-row or multi-line headers, or cells that wrap onto several lines — the tool flags this honestly rather than pretending it worked: “Complex merged cells may not be preserved” is shown up front as a known limitation, not discovered only after you've downloaded the file.

Bank statements and merged cells

A typical bank or credit card statement — date, narration, debit, credit, balance columns repeated down the page — is close to the ideal case for this extractor, since every row shares the same column structure. Where statements sometimes trip up extraction is a merged summary row (a subtotal spanning several columns) or a header that itself spans two rows; check those specific rows in the preview or the downloaded sheet, since a merged cell may land in only one of the columns it visually spans rather than being split evenly.

Checking totals after conversion

Because amounts are written as real numbers (not text) by default, the fastest check after downloading is to add a SUM formula beneath an extracted amount column and compare it to the total printed in the PDF. If they don't match, look for a row that got misread — usually a merged cell, a stray footnote, or a currency symbol formatted unusually in the source — rather than assuming the whole sheet is wrong; a single bad row is the far more common failure than a systematically broken column.

Frequently asked questions

Which kinds of PDF tables extract most reliably?

Tables with consistent column spacing down the whole page — bank statements, invoices, price lists, fee tables — extract most reliably, because column positions are clustered across the entire page rather than guessed row by row. Merged cells and multi-row headers are the main source of misalignment.

Will my numbers work with SUM and sorting?

Yes, with “Write numbers as numbers” checked (the default): amounts like currency and thousands-separated figures become real Excel numbers, so SUM, AVERAGE, sorting and pivot tables all work. Long digit strings such as order or account numbers are always kept as text so they're never rounded.

Can I extract a bank statement's transactions?

Yes — statement layouts with repeating date/description/amount columns are close to the best-case layout for this tool, since it clusters column positions across the whole page rather than per row.

What happens to merged cells?

Complex merged cells may not be preserved exactly; this is shown as a known limitation in the tool itself rather than discovered after downloading. Check merged summary rows or spanning headers in the preview or the downloaded sheet.

How do I check the conversion is accurate?

Add a SUM formula beneath an extracted amount column in the downloaded workbook and compare it to the total printed on the source PDF. A mismatch usually points to one misread row, not a systematic error across the whole sheet.

Does this work on scanned statements or receipts?

No — only text-based PDFs are supported. A scanned or photographed document has no text layer to extract; run the OCR tool on it first, then convert the result here.