Convert PDF Tables to an Excel Workbook
or drop files here
Stop retyping figures from a PDF. Tables come out as rows and columns with amounts Excel can calculate on, and the whole conversion happens inside this browser tab.
From locked PDF to working spreadsheet.
Drop in the PDF
Any PDF with tables in it works: an exported report, a supplier price list, a scanned statement. An encrypted file asks for its password before anything is read.
Decide how the sheets look
Mirror the document page by page, or gather every table onto a single sheet. Limit the pages if only one section matters, and choose the OCR language for scans.
Check the preview, then save
The first rows of the first table appear right in the result card, so you can confirm the columns lined up before opening the .xlsx in Excel, Google Sheets or LibreOffice.
Numbers that were stuck in a PDF.
A PDF is built for reading and printing. The moment you want to total, sort or reuse its figures, you need them in cells.
Reconciling a bank statement
Banks hand out PDFs, accounting software wants rows. Pull the transaction table into a sheet and match it against your ledger with a lookup instead of by eye.
Analysing a published report
Annual reports and government statistics bury their numbers in borderless tables. Bring them across as real figures and chart them, or compare two years side by side.
Updating supplier price lists
Load a vendor catalogue into a sheet, add your margin in the next column and fill it down. Part numbers with leading zeros stay intact for your stock system.
Totalling invoices for tax time
Convert each invoice with all tables on one sheet, paste the line items together and sum the VAT or GST column without retyping a single amount.
Digitising an old paper ledger
A scanned register or stock count has no text inside it at all. OCR reads the page on your device first, then the table finder turns the recognised words into rows.
Grading and research data
Mark sheets exported as PDF, timetables, lab results tables in a paper: get them into rows and columns so you can sort, filter and calculate averages in seconds.
How a table is found, and what to double-check.
A PDF does not actually contain tables. It contains pieces of text placed at coordinates, plus lines drawn on the page. The converter rebuilds the grid from those two clues. Where border lines meet in a grid, that is a ruled table: the lines give the exact rows and columns, so a description that wraps onto three lines inside one cell stays in that one cell.
Without lines, it looks for a borderless table: a run of rows that each break into separate chunks of text, with columns taken from the vertical strips of empty space that no row crosses. A short line tucked tight under a row, with its first column empty, is read as wrapped text and merged back up into that row.
Pages that were turned in a viewer are read in the direction their text was written, so a sideways landscape table still comes out with rows as rows. Text that is itself set at an angle, such as a rotated column heading, is skipped.
Before you rely on the workbook, check three things: that a heading spanning two columns landed where you expect, that a table split across pages was joined correctly, and, for scans, that the column totals match the printed ones.
What lands in the cell
| In the PDF | Stored as | Shown as |
|---|---|---|
| 1,234.50 | Number 1234.5 | 1,234.50 |
| (2,400) | Number -2400 | -2,400 |
| 12.75% | Number 0.1275 | 12.75% |
| $980 | Number 980 | 980 |
| 00742 | Text | 00742 |
| INV-2291 | Text | INV-2291 |
Currency signs are recognised but not displayed, so add a currency format to the column if you need one. Decimal values show two places while the cell keeps the full precision. Header rows, such as a row of years, stay as text so they never end up inside a total.
Questions answered.
Will the numbers add up in Excel, or are they stored as text?
Why did an account number keep its leading zeros?
My PDF table has no border lines. Can it still be found?
Can it convert a scanned PDF to Excel?
Should I pick one sheet per page or all tables on one sheet?
A table runs across two pages. What happens?
Does it keep merged cells, colours and fonts?
Is a confidential statement safe to convert here?
More tools you might need.
Related Guides & Tutorials
How to Repair and Recover Corrupted PDF Files That Won't Open (Recovery Guide)
Why PDFs get damaged, how to tell whether a broken file can be saved, and how to rebuild a missing cross-reference table or end marker to get the pages back.
How to Convert CMYK PDF to sRGB for Web and Social Media Sharing (True Color Guide)
Why a print-ready CMYK PDF looks off on screens and social media, and how to convert it to sRGB in InDesign, Illustrator, Acrobat Pro or Ghostscript, or export the pages as images.
Why Is My Printer Printing PDF Pages in Landscape Instead of Portrait? (Orientation Fix)
Why portrait PDF pages print sideways: automatic orientation, a landscape driver default, two pages per sheet, or a rotated page in the file. Fixes for Acrobat, Chrome, Preview and Windows.