PDF to Excel

Drop in a text-based PDF and get its tables as a spreadsheet, one sheet per page. Worth knowing what is actually happening: a PDF contains no tables at all, only text fragments with coordinates — the table is something your eye assembles from the alignment. So this reconstructs it, grouping fragments that share a baseline into rows and clustering their left edges into columns. That works well on a clean report and less well on a page of prose, so each page is scored on how table-like it looks and flagged when it is not. If your PDF is a scan, there is no text to take positions from at all, and you will be told to run it through OCR first rather than handed an empty sheet. Two sliders let you tune the detection when a row or column is being split or merged.

When detection struggles

LayoutResult
Clean aligned columnsAccurate
Merged header cellsHeader may land in one column
Multi-line cellsEach line becomes its own row
Prose paragraphsFlagged as low confidence
Scanned image pagesDetected — OCR needed first

When to use it

  1. Get a bank or credit card statement into a spreadsheet.
  2. Pull a financial table out of an annual report.
  3. Extract a price list or product table for editing.
  4. Turn a printed data table back into something you can sort.
  5. Move tabular data out of a PDF without retyping it.

How to Use

  1. Drop in a text-based PDF.
  2. Check the detected tables, adjusting the sliders if columns look wrong.
  3. Download the workbook, or a single page as CSV.

Features

  1. Rows and columns detected from text positions
  2. One sheet per page in the workbook
  3. Per-page CSV export
  4. Adjustable row tolerance and column gap
  5. Confidence scoring flags pages that are not tables
  6. Scanned PDFs identified rather than silently failing

FAQs

Is my PDF uploaded?

No. Extraction happens in your browser. That matters here, since the PDFs people convert to spreadsheets are usually statements and financial reports.

Why does it not work on my scanned PDF?

Because a scan is a picture of a page, with no text in it. There are no coordinates to work from — there is nothing but an image. Run it through the PDF OCR tool first to produce real text, then bring the result back here.

Why are my columns wrong?

Detection works from where text starts, so an unusual layout can confuse it. If one column is being split in two, raise the column gap. If two are being merged, lower it. If a single row is coming out as two, raise the row tolerance. Drop the file in again after changing either.

What does low confidence mean?

That the page does not look much like a table — usually because there is only one column, or the column count changes from row to row, which is what prose produces. The data is still exported, but expect text split at arbitrary points rather than real columns.

Why one sheet per page?

Because a multi-page report usually has a different table on each page, often with different columns. Merging them into one sheet would misalign everything. Sheets keep them separate, and combining them afterwards is easy if they do match.

Are numbers kept as numbers?

They are written as the PDF stores them, which is text. Excel will usually recognise plain numbers on import; currency symbols and thousands separators often need a column format applied afterwards.

Technical Details

PDFs do not contain tables. They contain text fragments with coordinates, and the table you see is something your eye assembles from the alignment — so extraction means reconstructing that structure from positions. Rows come from grouping fragments that share a baseline, with a tolerance rather than exact equality, because a bold header sitting beside plain text is rarely on precisely the same y and exact matching splits every such row in two. Each fragment is compared against its row's first item rather than its last, which sounds like a detail and is not: comparing to the last lets a row drift downward a tolerance at a time and swallow the row beneath it. Columns come from clustering the left edges of every fragment across all rows — in a real table each column's cells start at the same x, so the starts pile into as many clusters as there are columns. Splitting each row on its own whitespace instead, which is the obvious approach, produces a different column count per row and aligns nothing. Each page is checked for how table-like the result is, from the column count and how consistent it is across rows, and a page that looks like prose is flagged rather than silently exported as nonsense. A PDF with no text at all is a scan — images of pages with nothing to take positions from — and is called out as needing OCR first rather than producing an empty spreadsheet. Everything runs in your browser.

From the Blog

  • PDF to Word Online — Free, Fast & Private
  • Word to PDF Converter — Free, Fast & Private

PDF Tools

PDF Tools

  • HTML to PDF
  • Word to PDF
  • Password Protect PDF
  • PDF Password Remover
  • PDF Page Organiser
  • Add Page Numbers to PDF
  • Sign PDF
  • Image to PDF