Drop it anywhere
pdfhook

PDF to Excel

Extracts text and splits it into columns, ideal for simple tables.

  • No upload — runs on your device
  • Free, no sign-up
  • No watermark

What PDF to Excel does

Extracts text and splits it into columns, ideal for simple tables. Pulling a table out of a PDF and into an editable spreadsheet normally means retyping the data by hand. This tool detects columns based on spacing gaps and splits the extracted text accordingly, working best on simple, well-aligned tables — formulas, merged cells, and complex formatting from the original table are not preserved, only the visible text values.

Works well with: Excel to PDF · PDF to Word · PDF to Text

Runs 100% in your browser

PDFHook processes this file using JavaScript on your own device. It's never uploaded, stored, or seen by anyone else — and it works even if your connection drops mid-way.

HOW TO USE IT

PDF to Excel in 3 steps

1

Upload your PDF

Works best with simple, well-aligned tables.

2

Conversion runs automatically

Text is split into columns based on spacing.

3

Download the Excel file

Open it in Excel, Google Sheets, or similar.

Key features

  • Detects columns from spacing
  • Editable .xlsx output
  • Best for simple, well-aligned tables
  • Column detection based on spacing gaps of two or more spaces
  • Produces a standard, fully editable .xlsx file

Practical use cases

  • A financial report's table data needs to be pulled into a spreadsheet for further analysis.
  • Someone received a data table as a PDF and needs it in an editable, sortable format.
  • A user wants to combine a PDF table with other spreadsheet data.

Related terminology

Column detection
Identifying separate table columns in extracted text based on the spacing pattern between values, since a PDF doesn't store an explicit table structure like a spreadsheet does.

The complete guide to PDF to Excel

Quick answer

To convert a PDF table to Excel, add the PDF to PDFHook's PDF to Excel tool. It extracts the text and splits it into columns based on spacing, producing an editable .xlsx file. It works best for simple, well-aligned tables; scanned PDFs need OCR first, and merged cells and formulas are not recreated.

What PDF to Excel does

Tables locked inside PDFs are frustrating. You can see the numbers, but you cannot sort, filter, sum or chart them. Retyping is slow and error-prone. Converting to a spreadsheet gets the data into a form you can work with.

PDFHook reads the text from each page and uses spacing between words to work out where columns begin and end. It then writes rows and columns into an Excel file. Because it works from the arrangement of text on the page, it performs best on clean, regular tables.

Good candidates for conversion

  • Bank or card statements exported from systems as PDFs
  • Price lists, product catalogues and inventory sheets
  • Timetables, schedules and attendance lists
  • Simple financial summaries and reports
  • Data tables in reports where columns are clearly spaced

What makes a PDF convert well

  1. Digital, not scanned. The PDF should contain real text. If you can select individual words in your viewer, it is a good sign.
  2. Clear spacing between columns. Gaps are how the tool detects boundaries.
  3. One value per cell. Cells that wrap onto several lines or contain mixed content are harder to split.
  4. Consistent row layout. Regular rows convert better than free-form layouts.
  5. No heavy decoration. Plain tables beat tables with overlapping graphics.

What may not convert well

  • Merged cells and multi-level headers. Spreadsheet structure like merged cells is not recreated.
  • Formulas. A PDF contains the displayed values, not the formulas that produced them.
  • Tables without clear column gaps. If columns are tightly packed, values may merge into one cell.
  • Scanned tables. There is no text to read until you run OCR PDF, and recognition errors are possible in numbers.
  • Complex page designs. Layouts with multiple tables, charts and text on one page may extract in a confusing order.

After conversion: a short clean-up routine

Even a good conversion benefits from a quick review:

  • Check that column counts are consistent across rows
  • Spot-check totals against the PDF to be sure no numbers were misread or shifted
  • Fix any numbers stored as text so formulas work
  • Remove header and footer lines repeated on each page
  • Format dates and currencies as needed

Always compare a few key values with the original, especially if the data feeds into financial decisions.

Tips for better results

  • Extract just the table pages using Split PDF if the PDF has lots of narrative.
  • Rotate landscape tables the right way up with Rotate PDF first.
  • Crop out headers and footers with Crop PDF so they do not appear in the data.
  • Try PDF to Text if you want to inspect what the tool reads before converting.

Common mistakes

  • Trusting numbers without checking. Always verify totals.
  • Converting a scan directly. It will find no text.
  • Expecting formulas. The result is values only.
  • Not unlocking protected files. Use Unlock PDF if you know the password.

PDF to Excel vs copy and paste

Pasting a table from a viewer often puts everything in one column or loses alignment. A conversion tool that detects columns saves time on multi-page tables. For very small tables, copy-paste can still be quickest.

Privacy

Spreadsheets often contain sensitive information such as financial records and customer lists. The conversion in PDFHook runs in your browser, so the PDF and the Excel file are not uploaded. See how this differs from upload-based tools.

A worked example

A supplier sends a three-page PDF price list with columns for code, description, unit and price. Convert it, open the .xlsx and check that each row has the same number of columns. Delete repeated header rows from pages two and three, convert price cells from text to numbers, and spot-check ten prices against the PDF. Once clean, you can sort by price, filter by category or build a pivot table. For very long lists, extract only the table pages first.

Troubleshooting

If descriptions are split across several columns, merge them in Excel. If numbers are left-aligned, they are stored as text; convert them. If everything lands in one column, the PDF has too little spacing for detection, and a cleaner source file will do better.

Frequently asked questions

What makes a PDF convert well here?

Tables with clear spacing between columns work best — the tool detects columns from gaps of two or more spaces.

Will merged cells or formulas carry over?

No — only the visible text is extracted; formatting, formulas and merged cells are not preserved.

What if my PDF table doesn't have clear spacing between columns?

Tightly-packed or inconsistently-spaced tables may not split into columns accurately — clear, consistent spacing between column values gives the most reliable results.

Can I convert multiple tables from one PDF at once?

Yes — all detected table content across the PDF is extracted into the spreadsheet output.

Can I export a PDF table directly to XLSX?

Yes — detected table data is extracted straight into a standard .xlsx spreadsheet file, ready to open in Excel or Google Sheets.

Is there a free PDF to XLSX converter for tables?

Yes — this pdf to excel free tool works to export PDF to XLSX, extract PDF table to Excel, and convert PDF table to spreadsheet format with no cost.

Is PDF to Excel free?

Yes, and there is no sign-up, watermark or daily limit — everything runs in your browser rather than on a metered server.

How do I convert a PDF table to Excel for free?

Add the PDF to PDF to Excel and download the .xlsx. It is free, needs no account and does not upload your file.

What makes a PDF convert well to Excel?

Digital PDFs with clear spacing between columns and consistent rows. Scans and tightly packed tables convert poorly.

Can I convert a scanned PDF to Excel?

Run OCR PDF first to add a text layer, then convert, and verify the numbers carefully.

What if my table has no clear spacing between columns?

Values may end up in the same cell. Clean up in Excel using Text to Columns or try a PDF with clearer spacing.

Can I convert multiple tables at once?

The tool processes the text of the document and arranges it in rows and columns. Review the sheet to separate multiple tables.