pdfpix

Convert PDF to Excel

A PDF table is words at coordinates, so converting it to Excel means inferring rows and columns from alignment and proving the workbook holds what the page showed. PDF to Excel does that in this browser tab: it groups aligned native text, writes one worksheet per table with every value as text, and reopens the workbook to compare sheets, rows and cells before download. Excel's importer and the checks follow.

PDF to Excel

How to convert a PDF to Excel in your browser

  1. Choose the PDF

    Open the PDF to Excel tool, press Choose a PDF or drop the file on the page. It stays in this browser tab; nothing is uploaded.

  2. Pick the detected tables

    The tool lists every table it found by grouping aligned selectable text. All are selected by default. Untick the ones you do not want.

  3. Build the workbook

    Each selected table becomes its own visible worksheet. Every cell is written as text, never as a formula, so nothing in the PDF can run when the file opens.

  4. Check and download

    The tool reopens the workbook and compares worksheet names, row counts and every cell string with what it detected. Compare the source sample with the sheet preview, then download.

What a PDF table is, and why converters disagree

Excel stores cells. A PDF stores nothing of the kind: each word has a position on the page, and the grid lines, if any, are drawn separately. Every converter therefore infers the table by looking for text that repeats the same column positions down the page. Clean, ruled tables with one value per cell infer well. Merged headings, wrapped cell text and a wide gap inside one column are where converters break a table in the wrong place, and where two converters give two answers.

A scanned table has no text to align at all. Select-all in the PDF reader tells you which kind you have: words highlight individually in a native-text PDF and as one block in a scan. A scan needs OCR before any of this applies, and the tool refuses it rather than making an empty workbook.

How to turn a PDF into Excel with the browser tool

PDF to Excel reads the text layer in this tab, groups aligned words into rows and columns, and shows each detected table with a preview of the source page beside it. Each table you keep becomes a separate worksheet, so two unrelated tables on one page are never stacked into one range. Every value is written as a text cell.

Before the download appears, the tool reopens the XLSX it just wrote and checks that the worksheet names, dimensions and cell strings match the detected matrices, and that the file contains no macros, formulas, external links or hidden sheets. The check proves the workbook holds the detected table; it cannot prove that a visually merged heading was one column rather than two, which is why the source preview is shown next to it. The tool is free to use, needs no account, and the PDF is never uploaded.

Excel’s own importer

Excel for Windows in Microsoft 365 has Data, Get Data, From File, From PDF. It opens a Navigator listing each table and each page it found, shows a preview, and loads the choice through Power Query, where columns can be typed and rows filtered before the data lands on a sheet. It is a strong route on Windows and it refreshes when the PDF changes. It runs on your machine.

Excel for Mac does not have the From PDF connector, and older Excel versions have no PDF import at all. For those, the routes are the browser tool, a paste with Text to Columns, or Word. The paste and Word routes are compared in Copy a table from PDF to Excel.

How to export a PDF to Excel and keep the numbers usable

Values arrive as text in the browser tool by design, and often as text from other routes when a currency sign or a thousands separator is present. Excel shows text numbers left-aligned and refuses to sum them. Select the column and use Data, Text to Columns, Finish, which re-reads each cell; or put =VALUE(A2) in a helper column; or paste a 1 somewhere, copy it, select the column and Paste Special, Multiply. Dates convert the same way once the format is consistent.

Negative amounts shown in brackets, or with CR and DR suffixes, need a formula that reads the marker before the column can be summed. Check the total against the PDF's own printed total before trusting anything downstream.

XLS, XLSX and CSV

The browser tool writes XLSX, the format every Excel since 2007 opens. To convert a PDF to XLS for a system that still needs the 1997 to 2003 format, open the XLSX in Excel and Save As, Excel 97-2003 Workbook; it holds at most 65,536 rows and 256 columns, which a long statement can exceed.

When one table needs to go into a database or a script rather than a spreadsheet, PDF to CSV uses the same detector and writes a CSV that is parsed again and compared cell by cell before download, with a spreadsheet-safe mode that neutralises cells that begin with a formula character.

Statements, reports and what to check

The most common table people convert is a bank or card statement, where the stakes are the account number and every transaction on it. Convert a bank statement PDF to Excel covers keeping it in the browser and reconciling the total.

For any table: count the rows against the PDF, sum the column that has a printed total and match it, and look at the first and last rows for a header or footer line that the detector took as data. Those three checks take a minute and catch most detection errors. The other spreadsheet guides are under PDF, Word and Excel help.

Questions people ask

Does PDF to Excel work without uploading the file?
Yes. The tool reads the PDF, detects tables, writes the workbook and checks it in this browser tab. Nothing is sent anywhere.
Why are the numbers text in the converted workbook?
The tool writes every cell as text so nothing from the PDF can run as a formula. Select the column and use Text to Columns, or VALUE, to turn them back into numbers.
Can I convert a scanned PDF table to Excel?
Not with this tool. A scan has no text to align, so it refuses rather than producing an empty sheet. OCR the scan first.
Does Excel itself import PDF tables?
Excel for Windows in Microsoft 365 does, from Data, Get Data, From File, From PDF. Excel for Mac and older versions do not.
What does the workbook check prove?
That the XLSX reopens with the expected worksheet names, row counts and cell strings, and holds no macros, formulas, external links or hidden sheets. It does not prove the column boundaries were inferred correctly, so compare the preview.
Why did my PDF produce several worksheets?
Each detected table becomes its own sheet so unrelated tables are never combined. A table that continues over pages arrives as one sheet per page; copy the rows together in Excel.

Do it now

The tool runs in this browser. Your file never leaves the machine, and the result is checked before you download it.

PDF to Excel

Where to go next