How to Convert PDF to Excel & Extract Tables Free

2026-06-26

You finally got the quarterly report as a PDF, but the numbers you actually need are trapped in a table you can’t touch. Retyping forty rows of figures into Excel by hand is slow, and one mistyped digit can throw off every formula that follows. Converting the PDF straight to a spreadsheet skips all of that and drops your data into real, editable cells.

Why convert PDF to Excel?

PDFs are built to be read, not crunched. The numbers in a PDF table look like a spreadsheet, but they’re locked into a fixed page layout — you can’t sort them, filter them, or wrap a =SUM() around a column. Copy-pasting rarely helps either: the values often land jumbled into one cell, or get split in ways that scramble your columns.

A proper PDF to Excel conversion is different. It detects the rows and columns in your table and places each value in its own cell, so the structure you see on the page becomes a working .xlsx spreadsheet. Once it’s in Excel, Google Sheets, LibreOffice Calc, or Numbers, you can sort by date, filter by category, add formulas, and build charts — all on data that, minutes earlier, was just ink on a page.

This is genuinely useful for financial statements, bank exports, invoices, price lists, scientific results, and any report where the tables matter more than the prose.

How to convert a PDF to Excel

Here’s the full process using our PDF to Excel tool. From upload to download, it usually takes well under a minute.

1. Open the tool. Go to the PDF to Excel page on PDF168 — no account or installation needed.
2. Add your PDF. Drag and drop the file onto the page, or click to browse and pick it from your computer.
3. Choose which pages to convert. In the Pages box you can type all to process the whole document, or narrow it down to the pages with the tables you want — for example 1-3 for a range, or 5 for a single page. Limiting the pages keeps the output tidy when only part of the document is tabular.
4. Start the conversion. Press Convert. Your file is uploaded over an encrypted connection to our secure server, which scans each page, detects the table grid, and rebuilds it as a spreadsheet.
5. Wait a moment. Most documents finish in a few seconds. Large files with many pages or dense tables take a little longer.
6. Download your spreadsheet. Save the .xlsx file and open it in Excel, Google Sheets, LibreOffice Calc, or Numbers. Your rows and columns are ready to sort, filter, and calculate.

That’s the whole flow — no email, no watermark, and no limit on how many files you convert.

Getting the cleanest extraction

How well a table converts depends a lot on the PDF itself. A few habits make a real difference:

• Use digital, text-based PDFs when you can. If the PDF was exported from Excel, a database, or accounting software, the numbers are “real” text and convert with high fidelity. Files like these give you the cleanest cells.
• Scanned PDFs need OCR first. A scan is just a picture of a table, so there’s no underlying text to read and you’ll get blank or garbled cells. Run the file through an OCR tool to recognize the text, then convert the result.
• Watch out for merged and stacked cells. Tables with cells that span multiple columns, multi-line entries, or no visible borders are the hardest to detect perfectly. Expect to nudge a few values after converting — far quicker than retyping the lot.
• Convert only the pages you need. If your report is mostly narrative with a couple of data tables, set the Pages field to just those pages. You’ll get a focused spreadsheet instead of one cluttered with stray text fragments.
• Just need raw rows for another program? If you’re importing into a database, an analytics tool, or a script, a plain CSV is often easier to work with than a styled workbook. Our PDF to CSV tool pulls the same tabular data into a lightweight comma-separated file.

After converting, give the spreadsheet a quick once-over: check that column headers landed in the right place, confirm a couple of totals against the original, and re-format any cells (dates, currency, percentages) that came across as plain text.

A note on privacy

Tables often hold sensitive numbers — salaries, account balances, patient data, pricing — so it’s fair to ask where your file goes. Extracting tables accurately needs real processing power, so this conversion runs on our secure server rather than in your browser. Your PDF is sent over an encrypted (HTTPS) connection, converted, and the result is returned to you. The file isn’t stored afterward, shared with anyone, or used for ads or training, and you never have to create an account.

Wrapping up

Pulling tables out of a PDF used to mean squinting at the screen and retyping numbers one row at a time. With the PDF to Excel tool you drop in a file, pick your pages, click Convert, and download a clean .xlsx where every figure sits in its own cell — free, secure, and ready for formulas. If you’d rather have a stripped-down data file for importing elsewhere, PDF to CSV does the same extraction in a lighter format. Either way, bookmark it for the next report that lands as a locked-up PDF.

Open PDF to Excel →

FAQ