PDF to Excel converter

Turn the tables in a PDF into an Excel spreadsheet: columns are found from the layout, wrapped cell text is put back into one cell, and numbers like 1,234.56, (12.00) or 17.3% become real numbers you can sum. The PDF is read in your browser, so bank statements and invoices never leave your device.

No PDF yet. You can also drop a file on this box.

How the tables are found

A PDF has no tables, only pieces of text drawn at x/y positions (the grid lines are separate drawings). This page reads the text with pdf.js (Firefox's PDF engine) and rebuilds the grid:

StepHow
RowsText at the same height is one line. A big vertical gap starts a new table, so two tables on one page get their own columns.
ColumnsWhere almost no line has text, there is a column gap.
A header like "Week Ago" that spans two number columns doesn't merge them.
Wrapped cellsA line with text in one column only, right next to a full row, is joined to that row's cell (option).
Numbers1,234.56 or 1.234,56 (detected per file), $ € £, (12.00) and 12.00- as negatives, 17.3% as 0.173 shown as a percent. Codes with a leading zero, like 00123, stay text.
Page headersA header row that repeats on each page is kept once (option). Dot leaders (Crude Oil .......) are removed.
Other textTitles and notes come out as one-cell rows. Set Other text to Drop to keep only rows with two or more cells.

We tested it on real files: the U.S. EIA weekly petroleum balance sheet (every value of the stocks table in its own cell and typed as a number), the Census Bureau's new residential construction report (13 columns, separate even where two numbers sit close together), a Wikipedia table printed to a 28-page PDF, and a 2-page bank statement with wrapped descriptions (61 of 61 rows exactly right, header kept once).

What it can't do

ContentResult
Headers on two or three linesOne spreadsheet row per line ("% of" above "world")
Merge them by hand, or delete the extra rows.
Merged cellsThe text goes in the first column it covers
Scanned PDFsNo text: the pages are pictures
Run OCR PDF first, then convert its output here.
Tables with no gaps between columnsColumns that touch can't be told apart
Fonts, colors, bordersNot copied: you get the values

Check totals after converting, as with any PDF table extraction. For text documents (contracts, reports) use PDF to Word or PDF to text instead.

Making the PDF in the first place?

If you generate reports, invoices or statements as PDFs, the Shotmint API renders HTML to PDF in real Chromium, with tables, page numbers and headers. Send the table as HTML and get the PDF back:

curl -X POST "https://shotmint.creasework.com/v1/pdf" -H "X-API-Key: YOUR_KEY" -H "Content-Type: application/json" \
  -d '{"html":"<table><tr><td>Total</td><td>1,234.56</td></tr></table>","format":"A4"}' -o report.pdf

Each render is 1 credit. €5 buys 2,000 with no subscription, and credits never expire. See the guides for invoices and reports from Python, Node, PHP and more, or turn a spreadsheet into a PDF with Excel to PDF.

Get 25 free renders a month API docs

FAQ

Is my PDF uploaded? No. The conversion runs in JavaScript on this page, so the file stays on your device. That matters for bank statements and payslips.

Why are some numbers still text? Values with letters or units next to them (12 kg, 5 pcs) and codes with a leading zero stay text on purpose. Set Numbers to "Keep as text" to get every cell exactly as printed.

The columns are wrong. What can I try? Set "Wrapped lines" to "Own rows" if separate rows were joined, and use a page range to convert one table at a time. Tables drawn as images can't be read.

Does it work with password-protected PDFs? Yes, if you know the password. The page asks for it, and the password stays in your browser too.

Is there a size limit? No limit and no signup. Very large PDFs depend on your device's memory, so use a page range if your browser struggles.

Related: PDF to CSV, PDF to Word, PDF to text, Excel to CSV, CSV to Excel, Excel to PDF, OCR PDF

Related tools

Excel to PDF · Excel to CSV · CSV to Excel · Excel to JSON Converter · Excel to Markdown Table · JSON to Excel Converter · PDF to HTML · Compare PDFs (text diff) · PDF to Word · Extract images from PDF · PDF to Markdown · PDF to text · OCR PDF · Unlock PDF · Protect PDF · Flatten PDF · Fill PDF form · Sign PDF · BMP to PDF · CSV to PDF Converter · DOCX to PDF Converter · Extract Pages from PDF · GIF to PDF · HEIC to PDF · PDF Metadata Editor · PDF Metadata Viewer · PDF to CSV Converter · PDF to DOCX · PDF to TIFF · TIFF to PDF · WebP to PDF · Webpage to PDF · XLSX to PDF Converter · all free tools