Extract Data from PDF to Excel or Any Spreadsheet
Pull the numbers out of a PDF and into a spreadsheet you can actually work with. PDFXLSX reads tables, line items, and form fields and lays them out as real columns and rows in Excel, CSV, or Google Sheets, with the figures kept as numbers you can total. Drop a PDF on the right and see the data come out.
Works in any browser. Your first extraction is free and files are deleted after processing.
Drop your PDF here or click to browse
PDF files up to 50MB
Tables, line items, and form fields into clean columns. First file free.
The short answer
Last updated July 2026To extract data from a PDF into a spreadsheet, use a tool that reads the tables, line items, and form fields and lays them out as real columns and rows. PDFXLSX writes the values into Excel, CSV, or Google Sheets with figures kept as numbers you can total, instead of flat text in one cell. Scanned pages are read with OCR first. It runs in the browser with nothing to install, and your first file is free.
Tables
Rows and columns kept
Fields
Form and label data
Numeric
Numbers you can total
OCR
Reads scanned files
Why pulling data out of a PDF is harder than it should be
A PDF is built to look the same on every screen, not to hand its data back. Under the hood it stores each character at a fixed coordinate, with no idea which letters form a column, a label, or a total. So when you select a block and paste it into Excel, the page layout you could read with your eyes collapses into one column of text, and the numbers arrive as strings Excel will not add.
That is fine for one short table you can retype. It falls apart on the documents people actually need: a 40 page statement, an invoice with line items wrapping across two rows, a form where the values you want sit next to their labels, or a scanned report that is really just an image. Re-keying those by hand is slow and a single transposed digit can throw off a reconciliation.
PDFXLSX extracts the data instead of copying the text. It finds the table structure, reads form fields and labelled values, keeps amounts numeric and dates as dates, and runs OCR on scans so even a photographed page comes out as rows. You see the result before you download, then export to Excel, CSV, or Google Sheets.
| Date | Item | Qty | Amount |
|---|---|---|---|
| 03/02 | Widget A | 12 | 4,250.00 |
| 03/07 | Credit memo | 1 | -180.25 |
| 03/14 | Freight | 1 | 29.99 |
| 03/21 | Widget B | 8 | 1,910.40 |
Line items keep their columns and the Amount column is true numbers, so a SUM works the moment the file opens, with no Text to Columns step.
Ways to extract data from a PDF, compared
An honest look at what each method handles and where it leaves you cleaning up.
| Method | Keeps columns? | Numbers usable? | Notes |
|---|---|---|---|
| Copy and paste | Rarely | No | Everything lands in one column as text. Fine for a line or two, painful for a real document. |
| Open in Word, then paste | Sometimes | Sometimes | Word can rebuild a simple table, but multi page and complex layouts still break, and scans do not convert. |
| Excel From PDF (Power Query) | Sometimes | Sometimes | Good on clean tables, but needs Microsoft 365, has no OCR, and splits complex pages into the wrong columns. |
| Re-key by hand | Yes | Yes | Accurate if you are careful, but slow on long files and one transposed digit can break a reconciliation. |
| PDFXLSX in your browser | Yes | Yes | Reads tables, line items, and fields, keeps numbers numeric, OCR on scans, and shows the result first. |
No method is perfect on every layout, which is why the preview matters: you confirm the data before you rely on it. To pull only clean grid tables, the PDF table extractor is the focused tool; for everyday whole-document conversion use the PDF to Excel converter.
What you can pull into a spreadsheet
More than a single neat table. The data buried in real business documents.
Tables and line items
Rows and columns map to where they belong, including invoice line items that wrap across two lines and totals at the bottom. The shape of the data you uploaded is the shape you get back.
Form fields and labelled values
When the data you want sits next to a label rather than in a grid, you can pull those values too. Handy for PDF forms and statements where each figure has a caption.
Numbers stay numeric
Amounts with commas, currency symbols, or negatives in parentheses come through as real numbers, not text. You can SUM, sort, and build formulas right away, with no Convert to Number warning to clear.
OCR for scanned PDFs
A scan is an image, so there is no text to copy at all. Built-in OCR turns scanned PDFs into editable rows, so a photographed statement extracts as cleanly as a digital file.
Several PDFs at once
Upload a batch and extract them together instead of one at a time. See how to convert multiple PDFs to Excel when you have a folder of statements to get through.
Private and secure
The documents you most need to extract are usually the most sensitive. Uploads are encrypted in transit and at rest, processed in isolation, and deleted automatically once your spreadsheet is ready. Nothing is kept or reused.
How to extract data from a PDF to a spreadsheet
Three steps, and a chance to check the result before it counts.
Upload the PDF
Drag the file into the box at the top or pick it from your computer. Digital and scanned PDFs both work, and you can send several at once.
It reads the data
The tool finds the tables, line items, and field values, applies OCR where a page is a scan, and keeps numbers numeric and dates as dates instead of dumping plain text.
Check, then export
Review the extracted rows, then download as XLSX or CSV, or send it to Google Sheets. Your file is deleted right after.
Who pulls data out of PDFs every week
If your source data arrives as a PDF but your work happens in a spreadsheet, this is the step that eats the most time. These are the people it saves.
-
Accountants and bookkeepers moving statements, invoices, and reports into the books. See the workflows for accountants and bookkeepers.
-
Analysts and operations teams rebuilding a vendor or supplier report as a working spreadsheet so they can filter, pivot, and compare the figures.
-
Procurement and AP staff capturing line items from invoices and purchase orders into a sheet for tracking and ERP import.
-
Anyone facing a stack of PDFs who needs the data in a spreadsheet today and does not want to spend the afternoon retyping it column by column.
Need only the tables?
If your PDF is mostly clean grids and you just want those pulled out, the focused PDF table extractor targets the tables directly. This page is the broader option for documents where the data you need is mixed in with text, labels, and line items.
For accuracy on figures that must tie out to the cent, see the accurate PDF to Excel converter.
Extract data from PDF: common questions
Upload the PDF into the tool at the top of this page or the PDF to spreadsheet converter, let it read the tables, line items, and fields, then check the preview and download a spreadsheet. It maps the data to real columns and rows and keeps numbers numeric, so you get a working XLSX, CSV, or Google Sheet rather than a single column of pasted text.
Yes. You can extract data from a PDF into Excel with this tool, with Excel's own From PDF feature in Microsoft 365, or by copy and paste for a tiny table. The tool here handles the cases the others struggle with: multi page files, scans that need OCR, and amounts that otherwise arrive as text instead of numbers you can total.
Convert the whole document into a clean spreadsheet first, then keep the columns or rows you need and delete the rest. Because each value lands in its own cell, filtering down to the specific dates, accounts, or line items you want is a quick sort or filter rather than a hunt through a wall of pasted text.
Upload the form and the tool reads the filled-in values along with their labels, so a field like Invoice Total becomes a labelled value in your sheet rather than loose text. For repeated forms with the same layout, this turns a stack of documents into rows you can stack and analyze. The convert PDF form to Excel page covers this in more detail.
The best way depends on the document. For one short table, copy and paste is fastest. For a real business file, especially multi page, scanned, or numbers-heavy, a structure-aware extractor that keeps columns and number types intact saves the most time and avoids re-keying errors. Whatever you use, check the output against the source before you rely on it.
Yes. Upload several PDFs together and extract them in one pass instead of repeating the steps for each file. It is the practical way to handle a month of statements or a folder of invoices. The batch PDF to Excel converter is built for exactly that high-volume case.
To extract a PDF into Excel, upload it to the tool at the top of this page and download the XLSX. The extractor reads the document structure, so each field lands in its own cell and amounts arrive as numbers you can total. Scanned files run through OCR first. If you would rather stay inside Excel, Get Data from PDF does the same job for clean, digital tables on Windows, and the guide to converting a PDF to Excel compares every method.
Upload the PDF to the tool at the top of this page and download an Excel file. The extractor reads tables and labelled fields, so each value lands in its own cell and figures come through as real numbers you can sum. It handles multi page files and runs scanned pages through OCR first. To extract data from a PDF to Excel across a whole folder at once, use the batch PDF to Excel converter.
More PDF to Excel options
Convert Bank Statement PDF to Excel in Seconds
Convert bank statement PDFs to Excel for fast reconciliation and bookkeeping. Preserves transaction dates, amounts, and descriptions.
Use casesConvert Invoice PDF to Excel for Faster Accounts Payable
Extract invoice data from PDF into Excel spreadsheets. Line items, totals, tax amounts, and vendor details parsed automatically.
Use casesConvert Financial Report PDF to Excel and Financial Statements
Convert financial report and statement PDFs to Excel with the structure intact and figures kept numeric. Balance sheets, income statements, and cash flow.
Use casesPDF Purchase Order to Excel: Convert Purchase Orders and Extract Line Items
Convert purchase order PDFs to Excel with every line item intact: SKU, quantity, unit price, and line total kept numeric. OCR for scans, batch for many POs.
Extract data from your PDF now
Drop a PDF at the top of the page, check the extracted rows, and download clean XLSX or CSV with the columns lined up and the numbers ready to total. Your first extraction is free. For everyday whole-document jobs use the PDF to Excel converter, or pull just the grids with the PDF table extractor.