Free online PDF to Excel converter that finds the tables in a PDF and rebuilds their rows and columns as editable XLSX or CSV cells. Where the PDF has selectable text the tables convert straight away. Where it is a scan, OCR recognizes the table first.
Document format work by OnlinePCApps since 2013
A table locked in a PDF cannot be sorted or summed. This converter turns it back into cells that a spreadsheet can work with.
A bank statement or a ledger arrives as a PDF and the figures need totalling or reconciling. Converting the table to Excel lays out the date, description and amount in cells, where a formula can add and filter them.
An invoice or a price list holds a table worth pulling into a working sheet. A spreadsheet copy brings the rows and columns across, ready to reorder or feed into a report.
Copying a table cell by cell is slow and invites mistakes. Converting the entire table at once brings every value across in place, so nothing has to be keyed in again by hand.
Drag a statement, invoice or price list onto the panel, or click it and browse to the PDF. Once loaded, the file card lists the name and size and offers Change File to swap in another one.
Select XLSX for a multi-sheet workbook or CSV for one plain-text sheet. Under Page Range leave the box blank for the entire PDF, type the pages that carry the table, 1, 3-5 for instance, or use the All pages, First page and First 3 presets. Leave Enable OCR for Scanned Pages ticked, with an OCR Language and a 120 to 360 DPI resolution, so a scanned table is recognized too.
Click Convert to XLSX or Convert to CSV. When the conversion completes, Download XLSX saves a file named after the PDF that opens in Excel, Google Sheets or LibreOffice Calc. The original PDF stays untouched.
To convert PDF to Excel is to lift the tables off a fixed page into working cells, not to photograph them. Here that means XLSX or CSV, a page range and OCR.
A PDF holds no real table, only text placed at fixed spots. The converter uses the spacing and rules to detect every table and rebuild its grid, so rows and columns land in the cells they belong in.
A figure lands as a number a spreadsheet can add, not as loose text. Totals, sorting, filtering and a pivot work straight away, which is the point of moving a table into Excel rather than a document.
When the PDF carries selectable text, its values move straight into cells. When it is a scanned statement the table is only an image, so Enable OCR for Scanned Pages, ticked by default, recognizes the digits and labels first, with an OCR Language and a 120 to 360 DPI setting.
XLSX writes a standard workbook that opens in Microsoft Excel, Google Sheets, LibreOffice Calc or any spreadsheet. CSV writes one plain-text sheet for a system that imports raw rows, and a Page Range limits either to the pages that hold the table.
Convert PDF to Excel, extract tables to XLSX, pull spreadsheet data out of a PDF: three phrases for one job. The workbook comes out as a fresh file and the source PDF stays exactly as it was.
A table detector infers rows and columns from a fixed page before any cell exists. The cases below show how close the sheet lands.
| The case | Result | What happens and why |
|---|---|---|
| Text-based PDF | clean | Every value in a selectable text layer lands in a cell as it was printed. |
| Scanned PDF | OCR on by default | A scan shows the table as an image, so Enable OCR for Scanned Pages recognizes the digits and labels first, in the OCR Language set and at 120 to 360 DPI. |
| No real table | reconstruction | A PDF stores placed text, not a grid, so the table is detected from spacing and rules. How a PDF stores text explains why. |
| Simple bordered table | near exact | Clear rows, columns and lines rebuild into cells that match the original closely. |
| Merged or borderless | light cleanup | Merged cells, a borderless table or an odd layout may need a small tidy in the sheet. |
| Numbers | stay numeric | A figure lands as a number ready for formulas, not as text a sum would ignore. |
| Many tables | XLSX holds sheets | XLSX is the multi-sheet format, so a report with several tables belongs there. CSV holds one sheet, so a multi-table PDF comes back flattened in that format. |
| Output format | XLSX or CSV | The file is an Office Open XML workbook, or a plain CSV for a raw row import, which why CSV files break is worth a look before. |
| Page range | all or a list | Only the pages that hold the table need converting, so Page Range offers All pages, First page, First 3 or a typed list, 1, 3-5 for instance. |
The Table Rebuilt Into Cells, Not a Picture of It
A PDF has no idea of a table. It places text and lines at fixed spots on a page, and a reader sees a grid only because the spacing suggests one. Converting to Excel means detecting where those tables sit and rebuilding every row and column as real spreadsheet cells, with the figures kept numeric so a formula can use them. Selectable text rebuilds cleanly, while a scan is a picture of a table and needs OCR, on by default here, before any number can be recognized. A bordered table with clear lines lands near exact, while merged cells, a borderless layout or crowded spacing may need a light tidy, since the grid has to be inferred rather than copied. Both formats rest on the standards below.
Both get a PDF table into a spreadsheet. Price, scanned-page handling and files per run are where this converter and a hosted suite part ways.
| Point of comparison | This tool This PDF to Excel converter On the device | Hosted suites Converters bundled with an editor and a plan |
|---|---|---|
| Where the document goes | Never leaves the device | Uploaded to a server |
| Price | Free with no cap | Often one file a day free |
| OCR for scanned PDFs | Ticked by default, free | Often behind a Pro plan |
| A merged or complex table | Clear tables, then tidy | Heavier engine holds more |
| Many files at once | One PDF per run | Batch on their hardware |
The hosted suites win the last two rows: a heavier engine for a stubborn merged table and a queue for many files. This converter wins on price and OCR, free with no daily cap and a scanned table recognized without a Pro plan. The trade is weighed further in Browser-based file tools.
Detecting the tables and assembling the workbook are both done inside the browser, which leaves the document and its figures on the machine they came from. No part of the file is passed out for processing.
A table being pulled into Excel is often a bank statement, an invoice, a receipt or a payroll run, the kind of financial numbers that should stay off a stranger's server. A hosted converter uploads the file to read it, which is more exposure than the task needs.
Four other routes from a PDF table to a sheet, separated by accuracy, by cost and by what a scanned page gets.
A licence or an install stands in front of Excel, Acrobat and Calc, and Acrobat alone handles a scan. The online PDF to Excel converter above asks for neither and recognizes a scanned table by default.
What to expect from the workbook, in three short notes.
Selectable numbers mean a text-based PDF and a clean conversion. Numbers that refuse to select mean a scan, a table that is only a picture, so Enable OCR for Scanned Pages stays ticked and the DPI goes up for faint print.
A bordered table with clear rules lands near exact. Borderless layouts, merged cells or crowded spacing rebuild close but may need small fixes, because the grid is inferred from the layout rather than stored.
Editable cells with numbers a formula can use come back, not an image of the table. That is the difference from a screenshot and the reason to convert rather than copy by eye.
One document per run is the ceiling of the online PDF to Excel converter. A year of statements, or a shelf of reports full of merged tables, belongs to the desktop edition, which works from disk, converts every file in one pass and holds the harder tables together.
Point it at a folder and a workbook appears beside every PDF in a single run.
A statement that arrived as a scan is recognized during the convert, so a table that was only an image ends up as editable figures.
A heavier engine holds a merged or borderless table together better, keeping the rows and columns closer to the original page.
No sign-up, no watermark, no fee. A PDF table comes back as editable XLSX or CSV cells, with OCR included for a scan.