How to Extract Tables From PDF to Excel and CSV
There are five common ways to get a table out of a PDF and into a spreadsheet, and they are not equal. This guide walks through each one, from a one-click online converter to Excel's own Power Query and the Python libraries developers reach for, so you can pick the method that keeps your rows and columns intact instead of dumping the table into a single column. Drop a file on the right to extract your first table free.
Works in any browser on Windows, Mac, and phones. First extraction is free, nothing to install, files deleted after processing.
Drop your PDF here or click to browse
PDF files up to 50MB
Real rows and columns in Excel, not pasted text. First file free.
The short answer: the fastest way to extract a table from a PDF into Excel is to upload the file to an online converter that detects the table grid and rebuilds it cell by cell, then download it as XLSX or CSV. Excel's built-in Get Data, From PDF (Power Query) works for clean, single-page tables on newer Windows Excel but struggles with multi-page and complex layouts and cannot read scans. Copy and paste almost always collapses the table into one column. For scanned or photographed tables you need OCR first.
Last updated June 2026.
5
Methods compared
Grids
Real rows and columns
OCR
Reads scanned tables
Multi-page
One table across pages
Why a PDF table won't just drop into Excel
A PDF only looks like it has a table. Under the hood it stores each character at a fixed spot on the page, with no rows, no columns, and no record of which numbers belong together. The grid you see is drawn lines and careful spacing, not structure. That is why selecting a table, copying it, and pasting into Excel so often dumps everything into one column: there was never a real table for Excel to read.
Every method below is really a different way of solving the same problem, working out where the columns are from the data itself and rebuilding the grid. They differ in how well they handle the hard cases (multi-page tables, merged headers, wrapped descriptions, and scans) and in how much setup they ask of you. The right pick depends on how many files you have, whether they are scanned, and whether you would rather click a button or write a script.
If you just want the cleanest result with the least work, the PDF table extractor at the top of this page rebuilds the grid for you and shows it before you download. If you need the whole document, not just its tables, use the PDF to Excel converter.
Date Description Qty Amount 03/05 Deposit ACH 2210 1 5210.00 03/09 Vendor payment 3 -318.74 03/14 Service fee 1 -18.00 03/22 Invoice 4471 2 2640.25
Each column is its own field in the Excel file, and the amounts are real numbers, so you can sum the Amount column and foot the total instead of retyping it.
Five ways to extract tables from a PDF
Each method, what it is good at, and where it falls down, so you can match the right one to your file.
Online converter (best for most people)
Upload the PDF to a browser tool that detects the table, rebuilds the grid, runs OCR on scans, and lets you check the result before you download as Excel or CSV. No install, no formulas, and it handles the messy layouts the other methods choke on. This is the method the converter at the top of this page uses, and it is the one to reach for when you want a clean result fast or have more than a couple of files. Best for accountants, bookkeepers, and anyone who needs the numbers to total correctly.
Excel Get Data, From PDF (Power Query)
Newer Windows versions of Excel can pull tables straight from a PDF. Go to the Data tab, choose Get Data, From File, From PDF, pick the file, and the Navigator pane lists the tables and pages it found. Select a table and click Load, or Transform Data to clean it up in Power Query first. It works well on clean, single-page tables, but it often splits multi-page tables, mangles merged cells, and it cannot read a scanned PDF at all. It is also Windows-only and absent from Excel for Mac. See importing a PDF into Excel and the Windows workflow for the full walkthrough.
Copy and paste, then Text to Columns
Open the PDF, select the table, copy it, and paste into Excel. Most of the time the whole table lands in one column because the PDF has no column data to paste. You can sometimes recover a simple table with Data, Text to Columns, splitting on spaces or a delimiter, but it breaks the moment a row wraps onto two lines or a cell is merged. Fine for one tiny clean table, painful and error-prone for anything real. See copying a table from a PDF to Excel for the manual fixes.
Adobe Acrobat Pro Export
Acrobat Pro has an Export PDF feature that sends a document to an Excel workbook, and it does a reasonable job on well-structured files. The catch is the price: the export tools are not in the free Acrobat Reader, so you need a paid Acrobat Pro or Export PDF subscription. OCR for scanned files is in the paid product too. If you already pay for Acrobat it is a fair option for occasional files; if you do not, a focused converter does the same job without the subscription. See the Adobe Acrobat alternative for a side-by-side.
Open-source libraries (for developers)
If you write code and have hundreds of files in the same layout, Python libraries like Camelot, Tabula, and pdfplumber extract tables programmatically and let you script the whole pipeline. They are powerful and repeatable, but they take setup, tuning per layout, and a separate OCR step for scans, so they are overkill for a handful of documents. The desktop app Tabula wraps the same idea in a point-and-draw interface for non-coders. Reach for these when extraction has to run automatically as part of a larger system.
PDF table extraction methods, compared
An honest look at which methods rebuild the grid, read scans, and what each one costs you.
| Method | Keeps columns? | Reads scans? | Cost | Best for |
|---|---|---|---|---|
| Online converter | Yes | Yes | First file free | Most people, scans, multi-page, batches |
| Excel Get Data, From PDF | Sometimes | No | Included in Excel | Clean single-page tables, Windows only |
| Copy and paste | No | No | Free | One tiny, simple table |
| Adobe Acrobat Pro | Usually | Paid OCR | Subscription | People who already pay for Acrobat |
| Open-source scripts | Usually | With OCR setup | Free, your time | Developers automating many files |
No method reads every layout perfectly, which is why a preview matters: you confirm the columns before you trust the data. For figures that must total correctly afterward, see the accurate PDF to Excel converter.
How to extract a table from a PDF to Excel
The recommended path, in three steps, with a chance to check the grid before you use it.
Upload the PDF
Drag the file into the box at the top of the page or pick it from your device. Digital and scanned PDFs both work, and you can send several at once.
It detects the tables
The converter locates each table, runs OCR where a page is a scan, rejoins anything that runs across pages, and rebuilds the grid cell by cell.
Check, then download
Review the rebuilt table, confirm the columns line up, then download it as Excel or CSV with the rows and columns intact. Your file is deleted right after.
The tables that trip every method up
Clean, single-page tables come out fine almost everywhere. The cleanup work comes from the real-world layouts: a transaction table that runs across six pages with the header repeated on each, a balance sheet where one label spans three merged rows, an invoice where a description wraps onto a second line inside the same row. Built-in tools and copy-paste break exactly here, splitting one table into several or stacking everything into a single column.
A grid-aware converter is built for these. It stitches a table that continues across pages back into one sheet, keeps a merged cell tied to the rows it covers, holds a two-line entry together as a single row, and pulls every table on a page when there is more than one. When a page is a scan, it reads the text with OCR first, then rebuilds the grid from that.
Whatever method you use, check the output before you rely on it, especially on scans where OCR can misread a smudged digit. Verify a total foots against the source. For a scanned or photographed table, start with OCR PDF to Excel; to turn a scan into something fully editable, see converting a PDF to an editable Excel file.
What a grid-aware tool handles
- Multi-page A single table that spills across many pages is rejoined into one continuous sheet, with the repeated header kept only once.
- Merged cells A label or header that spans several rows or columns stays attached to the cells it covers instead of shifting the grid.
- Multi-line rows A description that wraps to a second line is held as one row, so the amount next to it does not drift onto a blank line.
- Several tables Every grid on the page is pulled, not just the first, which matters on summary pages with two or three tables.
Many files at once? Use the batch converter to pull tables from a whole stack in one go.
Tables people pull out of PDFs
Most table extraction exists to get financial data out of a report and into a sheet that can total it.
Bank statement tables
Pull the transaction grid, often running across pages, into one clean sheet.
Invoice line items
Extract the line-item table, including descriptions that wrap to a second line.
General ledger
Rebuild a long GL grid into rows you can filter, group, and foot.
Financial reports
Get the tables out of a multi-table report for modeling or spreading.
Large reports
Pull a single table that spans dozens of pages without it splitting apart.
Data for import
Export the grid as CSV to load into a database, BI tool, or accounting system.
Working tables into accounting and finance systems? See the workflows for accountants, bookkeepers, and finance teams.
How to extract tables from PDF: common questions
The simplest way is to upload the PDF to an online converter that detects the table grid and rebuilds it, then download the result as Excel or CSV. Alternatives are Excel's Get Data, From PDF on Windows, copy and paste with Text to Columns, Adobe Acrobat Pro's Export, or Python libraries for developers. Pick by how many files you have and whether they are scanned. Drop a file into the tool at the top of this page to see your table rebuilt in a few seconds.
Yes, on newer Windows versions of Excel. Open the Data tab, choose Get Data, From File, From PDF, select your file, then pick the tables from the Navigator pane and load them. It works on clean, single-page tables but often splits multi-page tables, struggles with merged cells, and cannot read a scanned PDF because there is no text to import. It is also missing from Excel for Mac. For scans or complex layouts, use a converter with OCR instead.
Upload the PDF, let the converter pull every table it finds, then keep the one you need and delete the rest in Excel. Tools that show each detected table separately, like Excel's Navigator pane or Tabula's selection box, let you choose a single table before you export. If a page holds two or three tables, a grid-aware converter pulls them all so you are not stuck retyping the one the tool missed. Check the preview to confirm you have the right grid.
A scanned PDF is an image, so the text has to be read with OCR before any table can come out of it. A converter with built-in OCR runs it automatically when it detects a scan, turning the picture into real characters and then rebuilding the grid. Excel's Get Data and plain copy-paste cannot do this. Check the preview closely on scans, since OCR can misread a smudged digit, and verify the totals foot before you rely on them. See OCR PDF to Excel for the detail.
For most people the best way is an online converter that rebuilds the real grid, reads scans, and shows the result before you trust it, because it handles the hard cases with no setup. Excel's Get Data is fine for clean single-page tables on Windows. Developers automating hundreds of identical files are better served by Python libraries. Match the method to your situation: file count, whether it is scanned, and whether you would rather click or script.
Use a converter that pulls every table on every page in a single pass, rather than one that grabs only the first. Upload the whole PDF and it returns each table laid out in the sheet, including ones on summary pages that hold two or three grids. To do this across many PDFs at the same time, the batch converter processes a whole folder in one go, which is the usual need for a year of statements rather than a single report.
More PDF to Excel guides
Convert PDF to Excel Without Losing Formatting: Keep Columns, Numbers, and Merged Cells
Convert PDF to Excel without losing formatting. Keep columns aligned, numbers numeric, and merged headers intact with a table-aware converter. First file free.
How toHow to Convert PDF to Excel: Export a PDF to XLSX, XLS, or CSV
How to convert PDF to Excel step by step. Compare five methods: online converter, Excel Get Data From PDF, Adobe Acrobat, OCR for scans, and copy and paste.
How toHow to Convert Scanned PDF to Excel With OCR
Convert a scanned PDF to Excel with OCR. Compare five methods, follow the 3-step guide, and turn receipts, invoices, and statements into editable cells.
How toHow to Convert Multiple PDFs to Excel in Bulk
Batch convert multiple PDF files to Excel spreadsheets simultaneously. Process entire folders of documents in minutes instead of hours.
Extract a table from your PDF now
Drop a PDF at the top of the page, check the rebuilt grid, and download it as Excel or CSV with the rows and columns intact. Your first extraction is free. Need the whole file converted instead of just its tables? Use the PDF to Excel converter, or keep figures numeric with the accurate converter.