VSThiran

How to pull tables from a PDF into Excel

Quick answer

Upload your PDF to the PDF to Excel converter, check the preview of the extracted rows, then download as XLSX or CSV with each value in its own cell.

  1. 1Upload your PDF.
  2. 2Check the preview of extracted rows.
  3. 3Choose your options.
  4. 4Download XLSX or CSV.
Convert PDF to ExcelAll PDF tools

Free, no sign-up, and your file is read on your own device rather than uploaded.

PDF to Excel exists for one specific job: getting numbers that are currently locked in a PDF table - a bank statement, a price list, a sales report - into a spreadsheet where you can actually total, sort or chart them. It is not a general document converter; it is looking specifically for rows and columns.

It works by recognising table-like structure - aligned columns, consistent spacing - and reading each cell into the corresponding spreadsheet cell. The better structured the original table, the cleaner the result.

Step by step

  1. Choose your PDF

    The document is read locally, and you are told roughly how many table-like rows were found before you convert anything.

    PDF to Excel

  2. Check the preview

    The first rows of the first page are shown exactly as they will appear in the spreadsheet, so you can judge the result before committing to a download.

    PDF to Excel

  3. Set your options

    One worksheet per page, numbers stored as real numbers rather than text, and an option to drop anything that is not a table row.

    PDF to Excel

  4. Download XLSX or CSV

    XLSX for Excel, Google Sheets or Numbers; CSV if you would rather tidy it up in a plain text editor.

    PDF to Excel

Tips

  • A multi-page report converts with each page as its own worksheet by default, which keeps the structure of the original document recognisable.
  • Numbers stored "as numbers" means you can total a column immediately with a formula, rather than having to reformat text first.
  • If a page is mostly narrative text with one small table, try extracting just that page first - a cleaner input generally gives a cleaner table.

Common problems

The table came out with columns merged together.

This usually means the original PDF table has irregular spacing rather than true column alignment. Check the preview before downloading - if it looks wrong there, it will look wrong in the spreadsheet too.

It found no table rows at all.

Either the PDF is a scan (a picture, with no text to read at all - check with the PDF Inspector), or the document genuinely has no table-like structure for the tool to recognise.

You need the whole document, not just the tables.

PDF to Word is the better tool when you want the full narrative text and layout rather than table data specifically.

Frequently asked questions

Does PDF to Excel work on scanned PDFs?
Not directly - a scanned page is a picture rather than real text, so this converter has nothing to read. It works on PDFs with genuine, selectable text; for a scan, run the OCR workspace on it first.
What kinds of tables convert best?
Tables with clear headers and genuinely aligned columns - like a bank statement or a sales report - convert cleanly. Text that merely looks aligned by eye, without real column structure, converts less reliably.
Can I get a CSV instead of an Excel file?
Yes, both formats are offered from the same conversion. CSV suits anyone who wants to open the data in a plain text editor or import it into another system.
Does each page become its own worksheet?
By default, yes, for multi-page documents - which keeps a multi-page report's structure visible in the spreadsheet. This can be turned off if you would rather have one continuous sheet.
Is my file uploaded anywhere?
No. The conversion happens entirely on your device. Nothing is sent to a server and nothing is stored.

Related PDF tools

Related articles

Ready to do it?

Free, no sign-up, and nothing is uploaded to a server.

Convert PDF to ExcelAll articles