Skip to content
Toolify

How to Convert a PDF to an Excel Spreadsheet

September 23, 20265 min readWhy PDFs don't actually contain tables, how position-based row/column reconstruction works, and how to check the result.

A PDF full of numbers — an invoice, a financial statement, a data export someone printed to PDF — is frustrating to work with. You can’t sum a column or sort a table until the data is in a real spreadsheet. Converting PDF data to Excel is possible, but it’s worth knowing exactly how it works so you can trust (and double-check) the result.

There’s no such thing as a “table” in a PDF

This is the single most important thing to understand: PDFs don’t contain tables, rows, or columns as data structures. They contain individual pieces of text, each positioned at an exact (x, y) coordinate on the page. Anything that looks like a table is really just text that happens to line up visually — the grid lines you see, if there are any, are separate drawn shapes with no connection to the text at all.

Toolify’s PDF to Excel tool reconstructs rows and columns from that positioning: text at roughly the same vertical position becomes one row, and gaps between text on that row wide enough to suggest a new column become a column break. It’s a genuinely useful best-effort reconstruction — not real table detection — and it works best on simple, evenly-spaced tables.

How to convert a PDF to Excel

  1. Open PDF to Excel and select your PDF.
  2. The tool analyzes text positions on every page directly in your browser.
  3. Download the .xlsx file and open it in Excel, Google Sheets, or Numbers.

What to expect, and how to clean it up

  • Simple tables convert well. Clean, evenly-spaced tables with clear gaps between columns come across accurately most of the time.
  • Merged cells and nested tables are the hardest case. A cell that spans multiple columns, or a table within a table, confuses any position-based approach — expect to manually fix these after conversion.
  • Check for split or merged columns. Because column breaks are detected from spacing, a slightly unusual layout can cause two real columns to merge into one, or one column to split into two. A quick scan of the first few rows catches this fast.
  • Scanned PDFs need OCR first. If your PDF is an image with no real text layer, run OCR PDF first, then convert the result.

A practical workflow

Convert, then spot-check the row and column count against the original before trusting any formulas or totals. For anything with financial or compliance stakes, treat the output as a fast starting point for data entry, not a final source of truth. Because the extraction runs entirely in your browser, you can do this with sensitive spreadsheets without uploading them anywhere.

Tools mentioned in this guide