How to get a table out of a PDF and into Excel

5 min readpdfmaro

A bank statement, an invoice, a price list, a report full of figures — the data you need is right there in the PDF, but you need it in Excel so you can sort, total or chart it. Retyping it by hand is slow and error-prone, and a plain copy-paste usually dumps everything into one messy column. Here's why that happens, and how to get a clean spreadsheet instead.

Why tables are the hardest thing to copy out of a PDF

A PDF doesn't store a table as a table. What looks like neat rows and columns is really just text placed at precise positions on the page — the gridlines and alignment are visual, not structural. There are no “cells” underneath. So when you copy, the reader has no idea where one column ends and the next begins; it just hands you a run of text and leaves you to sort out the grid by hand.

How to turn a PDF table into a spreadsheet

Our PDF to Excel tool reads the text out of your PDF and rebuilds it into an .xlsx workbook you can open in Excel, Google Sheets or Numbers. Each page of the PDF becomes its own sheet, so a multi-page report stays organised. To reconstruct the columns, it uses a simple, reliable rule: wherever there's a clear gap between values on a line, it splits that line into separate cells. For the many documents where columns are separated by spacing — statements, exports, tabular reports — that puts your numbers into tidy, sortable columns.

How to get the cleanest result

  • Use a text-based PDF. If you can highlight the numbers in the PDF with your cursor, extraction will work. If you can't, the file is a scan (see the limits below).
  • Well-spaced tables convert best. Columns separated by clear gaps split cleanly; columns jammed tightly together are harder to tell apart.
  • Expect to tidy up once in your spreadsheet. A little column nudging after import is normal and far faster than retyping everything.

The honest limits

No automatic PDF-to-Excel conversion is magic, and it's fairer to tell you where the edges are than to pretend otherwise:

  • It can't read scans. If the PDF is an image with no real text, there are no characters to extract — you'd need to run it through OCR first to recover the text.
  • Very complex tables may need adjusting. Merged cells, nested headers or columns with no clear gap between them can land slightly off and want a quick manual fix.
  • It extracts data, not styling. You get the values in cells, not the colours, borders and fonts from the original — which is usually exactly what you want for working with the numbers.

A note on privacy

Statements and financial reports are sensitive by nature. PDF to Excel reads and converts your file entirely in the browser — it's never uploaded to a server. The extraction happens on your own device and the spreadsheet is built there too.

The short version

  • PDFs store positioned text, not real tables — that's why copy-paste clumps together.
  • The tool extracts the text and splits columns on the gaps, one sheet per page.
  • Works best on text-based PDFs with clearly spaced columns.
  • Scans need OCR first, and very complex tables may need a quick tidy-up.

Need those numbers in a spreadsheet? Open PDF to Excel — convert your PDF to an editable .xlsx for free, with nothing uploaded.