PDF to Excel Converter

What does "PDF to Excel" actually mean? 📊

Here's the honest truth: PDFs don't have tables. They have text painted at coordinates. There are no rows, no columns, no cells — just letters and numbers floating at x/y positions on a page. When you look at a PDF that appears to have a table, you're seeing the visual illusion created by those positions.

So "PDF to Excel" isn't a simple format conversion. It's a reconstruction problem. The tool has to read every piece of text, figure out which text belongs on the same row based on its y-position, then figure out which text belongs in the same column based on its x-position. Only then can it rebuild something that looks like a table.

That's what this tool does. It reads the PDF with PDF.js, extracts every text fragment along with its coordinates, groups fragments into rows and columns using position math, and then writes the result as a real Excel file with SheetJS.

How the column detection works 🔬

The algorithm has three steps. Here's what happens when you click convert:

Step 1 — Extract text with coordinates

PDF.js returns every text fragment with a transform matrix. The key values are:

• transform[4] — the x-position (distance from the left edge, in PDF points)
• transform[5] — the y-position (distance from the bottom edge, in PDF points)
• str — the actual text content of the fragment
• width — how wide the fragment is
• transform[3] — the font size (used for tolerance scaling)

Step 2 — Group text into rows

Fragments are sorted by y-position (descending, since PDF y-axis points up). Then they're walked in order, and a new row starts whenever the y-position jumps by more than a tolerance. That tolerance scales with font size — the tool uses Math.max(2.5, fontSize × 0.32). A fixed tolerance breaks on large headings; a pure relative one breaks on tiny footnotes. The max() of the two handles both.

Step 3 — Detect columns from x-positions

Within each row, fragments are merged into cells. Fragments that are close together (within a small gap) become one cell. Then the tool collects the x-positions of every cell start across all rows and clusters them. Positions where many cells agree become column boundaries.

This is the part that benefits from tuning. The "Sensitivity" slider in the sidebar controls the clustering tolerance. Lower values produce more columns (good for tightly packed tables); higher values produce fewer, wider columns (good for tables with wide gaps).

How to convert PDF to Excel — step by step 📋

1. Upload your PDF. Drop it onto the upload box or click to browse. The file stays on your device.
2. Wait for extraction. The tool reads every page and previews the detected table below.
3. Review the preview. Check that rows and columns look right. Scroll to see more.
4. Adjust if needed. If columns merged or split incorrectly, move the Sensitivity slider and click "Re-detect Columns."
5. Pick your options. Sheet name, page range, one sheet per page, skip empty rows.
6. Download. Click "Download Excel (.xlsx)" for a real Excel file, or "Download CSV" for plain comma-separated data.

What works well (and what doesn't) ⚠️

✅ Best results with

• Bank statements — transaction tables with dates, descriptions, amounts, and balances
• Invoices — line-item tables with quantities, prices, and totals
• Financial reports — quarterly results, revenue breakdowns, P&L tables
• Data exports — PDF reports generated from databases or CRMs
• Research tables — comparison tables, statistical results
• Inventory lists — product codes, descriptions, quantities

❌ Struggles with

• Scanned PDFs — if the PDF is an image, there's no text to extract. The tool will warn you.
• Borderless tables — tables without visible grid lines can be ambiguous; the column detector does its best but may need sensitivity tuning.
• Merged cells — a cell spanning two columns is treated as one value in one column.
• Multi-line cells — a cell with text on multiple lines may split into separate rows.
• Rotated text — sideways or angled text doesn't fit the coordinate heuristic.
• Complex layouts — multi-column magazine layouts, sidebars, and floating text boxes confuse row grouping.

Why use a browser-based converter? 🔒

Most online PDF to Excel tools ask you to upload your file to their server. Bank statements, invoices, financial reports — these are some of the most sensitive documents people handle. Handing them to a stranger's computer is a serious privacy risk.

This tool works differently. Everything runs inside your browser. The PDF is opened directly from your device's storage, text is extracted in memory, and the Excel file is generated locally. No upload, no server, nothing to leak.

• No server uploads — your PDF never leaves your device.
• No sign-up — no email, no account, no waiting.
• No page limits — the only constraint is your browser's memory.
• Works offline — after the page loads, turn off Wi-Fi and it still converts.
• No watermarks on output — the Excel file is clean.
• Free forever — no ads inside the tool, no per-file fee.

Who uses a PDF to Excel converter? 👥

• Accountants — pull transaction data from bank statement PDFs into Excel for reconciliation.
• Financial analysts — extract quarterly results from PDF reports for further analysis.
• Small business owners — convert invoice line items into spreadsheets for bookkeeping.
• Data analysts — capture tables from PDF reports for merging with other datasets.
• Researchers — extract statistical tables from academic papers.
• Anyone who has a PDF table and needs the data in a spreadsheet — fast.

Common problems and how to fix them 🛠️

"The tool says no readable text found"

Your PDF is probably a scanned image. There's no embedded text to extract. Use an OCR tool to add a text layer first, then come back. Alternatively, if the PDF came from a scanner, look for a "text" or "searchable" option in your scanner software.

"Columns are merging into one"

Move the Sensitivity slider to a lower value (try 8 or 10) and click "Re-detect Columns." Lower sensitivity produces more columns. If that doesn't help, the PDF may not have enough horizontal spacing between columns for the algorithm to detect them.

"Columns are splitting into too many pieces"

Move the Sensitivity slider to a higher value (try 25 or 30) and click "Re-detect Columns." Higher sensitivity merges nearby columns into one. If the table has very tightly packed data, this is the fix.

"Rows are misaligned"

Multi-line cells are the usual culprit. A cell that wraps to two lines in the PDF becomes two rows in the output. There's no automatic fix — the tool can't distinguish "two lines in one cell" from "two separate rows." You'll need to merge them manually in Excel afterward.

"The output has a huge number of tiny rows"

Each text fragment is being treated as its own row. This usually happens when a PDF has a lot of small text items with slightly different y-positions. Try increasing the "Skip empty rows" behaviour, or check whether the PDF is very old or produced by an unusual tool.

"The Excel file is empty"

If the preview shows nothing, the PDF has no extractable text. See the "no readable text" answer above.

PDF to Excel vs PDF to CSV vs PDF to Text — which do I need? 🤔

Tips for the best results 💡

• Use text-based PDFs. If you can select text in the PDF, this tool can extract it. If you can't, it's a scan.
• Adjust the sensitivity first. 80% of column-detection problems are fixed by moving the slider 5 points in one direction or the other.
• Preview before you download. The preview shows exactly what goes into the Excel file. Check it first.
• Use one sheet per page for multi-page PDFs. Some PDFs have different column layouts on different pages. Separate sheets keep each page's data clean.
• Download CSV if you're importing elsewhere. CSV is lighter and imports into almost any tool. XLSX is better for direct Excel use.
• Numbers come out as text. This is deliberate — auto-detecting number formats can silently corrupt data like ZIP codes and phone numbers. In Excel, use the "Convert to Number" option or a formula if needed.
• Mobile users: conversion works on phones but is slower for large files. Desktop is recommended for PDFs over 50 pages.

Is it safe to convert PDFs here? 🔐

Yes. Here's exactly what happens when you use this tool:

1. You pick a PDF from your computer.
2. Your browser reads it into memory locally.
3. Text extraction and table reconstruction happen in the browser tab.
4. The Excel file is generated in memory.
5. You download the .xlsx file back to your computer.

At no point does the file leave your device. No data is sent to SkillsInsider's servers. No tracking cookies watch your conversion. You can prove it yourself: turn off Wi-Fi after the page loads, then convert a PDF. It still works perfectly.