1. Home
  2. PDF
  3. PDF to Excel

PDF to Excel

Find tables in a PDF and export the ones you pick to Excel (XLSX) or CSV.

Runs in your browser · No upload
Tables are estimated from the position of the text. Tables without ruling, with merged cells, or with right-aligned number columns can be missed or misaligned, so always check the result by eye.

How to use

  1. Drop a PDF onto the box or choose one. If it’s password-protected, enter the password to open it.
  2. Choose all pages or a range such as 1-3, 5, 8-, then click Find tables. You can read up to 300 pages at a time.
  3. In the list, tick the tables you want and check each one with Preview.
  4. Set the options (header row, number cleanup, joining tables across pages) and how to export, then click Download.

How tables are found, and the limits

This tool works out tables from where the text sits, not from ruling lines. Three or more lines in a row that share the same column starting points (within 1.5% of the page width), with at least three columns, count as a table. A two-column “label … value” list or a ragged paragraph isn’t treated as a table.

  • Tables that rely on ruled lines but have irregular text positions, tables with merged cells, and cells whose text wraps onto several lines can be missed or come out misaligned.
  • Right-aligned number columns start at uneven positions, so those columns may not separate.
  • If no table is found, turn on Treat every line as a table row. It skips detection and splits each line wherever there are 2 or more spaces (or a wide gap), giving one table per page.
  • A scanned or photographed PDF has no text layer, so it can’t be read. You’ll see a notice. Run it through PDF OCR first to make a searchable PDF, then convert that.
  • If the author has restricted copying, you’ll see a warning and must confirm that you’re allowed to convert the document before it continues.

Options

Option What it does
First row is the header The first row becomes the column names. When off, Col 1, Col 2… are added
Clean numbers Removes commas, currency symbols and % from cells that read as numbers, so Excel stores them as numbers
Join tables that continue across pages A table on the next page with the same number of columns and the same column boundaries (within 1.5%) is merged into one
Remove the repeated header row on continued pages If the top row on the continued page matches the first row of the previous table, it’s dropped

Number cleanup examples: 1,000원 (Korean won) becomes 1000, (1,200) becomes -1200, -5% becomes -5 and 12.5% becomes 12.5. A phone number like 010-1234, a value with leading zeros like 00123, and 12 34 (digits split by a space) are left as they are. Removing % means you lose the fact that a value was a percentage. If you need that, turn the option off and format the column in Excel.

Export options

Option Result
One sheet per table (XLSX) Sheets are named p3 table1, or p3-4 table1 for a table that spans pages
All in one sheet (XLSX) Tables are stacked with one blank row between them. From the second table on, the header goes in as an ordinary row
CSV (one file per table) Saved as UTF-8 with a BOM so Excel doesn’t garble non-English text. Several tables are bundled into a ZIP

Open in workbench sends the XLSX to the Excel & CSV workbench, where you can keep sorting, searching or merging (it’s stored temporarily, in this browser only).

To move a whole document into Word, use PDF to Word. For plain text, use PDF to Text. For tables on web pages there’s HTML Table to CSV, and for tables in Korean HWP documents there’s HWP Tables to Excel. If a password stops the PDF from opening, use Unlock PDF first.

Your file is processed only in your browser and never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.