PDF to Excel

NEW

Extract tables from PDF to spreadsheet

FreeNo sign-upPDF Tools →

PDF to Excel reads the text of a PDF and writes it out as a CSV file that opens in Excel, Google Sheets or Numbers. Every line of text becomes a row, and wherever a line has a tab or a gap of two or more spaces, the tool starts a new column.

That rule works well for simple tables with clear spacing, such as price lists and statements. Tables with merged cells, wrapped text or tight spacing will need tidying in the spreadsheet afterwards. A blank row separates each page. Scanned PDFs have no text to read, so run those through OCR first.

Advertisement

How to use PDF to Excel

1

Add a text-based PDF

Drop the file onto the upload area.

2

Export

The tool extracts the text and splits it into rows and columns.

3

Open the CSV

Open the downloaded file in your spreadsheet app and adjust any columns that did not line up.

Use Cases

  • Getting a price list out of a supplier's PDF catalogue
  • Moving figures from a PDF statement into a spreadsheet
  • Collecting tabular data from reports for analysis

Frequently Asked Questions