How to Extract Table from PDF to Excel
Extract tables from PDF to Excel — here's how to do it, step by step. AI-powered table detection, manual extraction, and formatting tips.
What This Reading & Extraction Guide Covers
This guide was written and tested by Sarah Mitchell, a Document Design Specialist with 6 years of hands-on experience in typography, layout design, publishing workflows. Sarah spent 6 years as a layout designer at a major publishing house before transitioning to digital document consulting.
PDF tables are among the hardest document elements to extract accurately. A well-formatted table that looks perfect in a PDF can become a jumbled mess when copied to Excel — columns merge, decimals shift to wrong cells, and multi-line row entries split into separate rows. The problem is that PDFs store table content as independently positioned text, not as structured cells.
This guide covers four methods for extracting tables from PDFs to Excel, from simple copy-paste to AI-powered table detection. We tested each on financial statements, statistical reports, and product catalogs to evaluate extraction accuracy and post-extraction cleanup effort.
Time to read: 5-7 minutes | Difficulty: Beginner to Intermediate | Last updated: 2026-07-22
Why the Right Reading Setup Saves Time on Every Document
Tables in PDFs are not structured data — they are visual arrangements of text at specific coordinates. A PDF does not know that the text at position (100, 200) belongs to the same cell as the text at position (100, 220). Table extraction tools reconstruct cell boundaries by analyzing spatial patterns: text that is vertically aligned and horizontally spaced in a regular grid is identified as a table. Detection accuracy depends on how regular the table layout is.
Common extraction failures include: merged cells (where text spans multiple columns or rows), multi-line cell entries (where a single cell contains line breaks), and borderless tables (where there are no visible gridlines to help detection). The best extraction tools handle these edge cases; basic tools fail on all of them.
Related Reading & Extraction Guides
While reading this page, these related guides may save you time:
Reading and Extracting with a Desktop PDF Editor, Step by Step
1 Open the PDF and Locate the Table
Launch your desktop PDF editor and open the document. Navigate to the page with the table you need to extract. If the editor has a table detection feature, activate it — detected tables will be highlighted with bounding boxes. If not, visually identify the table's boundaries for manual selection.
2 Select the Table for Extraction
For automatic detection: click on the highlighted table region. For manual selection: use the Select tool to draw a rectangle around the entire table, including headers and all rows. Ensure you include the entire table width — missing columns at the edges will be absent from the export.
3 Choose Export Format and Configure Options
Select 'Export to Excel' (XLSX) or 'Export to CSV'. Configure options: detect headers (first row treated as column names), preserve number formatting (currency, dates, percentages), and handle merged cells. Choose whether to export to a new sheet or a new file. Review the preview to verify table structure.
4 Review the Exported Table in Excel
Open the exported Excel file. Check for: correct column count, merged cells preserved, multi-line entries in single cells, number formatting preserved, and decimal alignment correct. Compare a few rows and columns against the source PDF to verify data accuracy.
5 Clean Up if Needed and Save
If the extraction is imperfect, clean up in Excel: split incorrectly merged columns with Text to Columns, correct decimal formatting, and align column widths. If the extraction quality is consistently poor, try a different extraction tool or adjust the detection settings in your editor.
📋 Quick Recap of the Steps
Print this box or keep it open while you work through the tutorial.
- 1Launch your desktop PDF editor and open the document. Navigate to the page with the table you need to extract. If the editor has a…
- 2For automatic detection: click on the highlighted table region. For manual selection: use the Select tool to draw a rectangle arou…
- 3Select 'Export to Excel' (XLSX) or 'Export to CSV'. Configure options: detect headers (first row treated as column names), preserv…
- 4Open the exported Excel file. Check for: correct column count, merged cells preserved, multi-line entries in single cells, number …
- 5If the extraction is imperfect, clean up in Excel: split incorrectly merged columns with Text to Columns, correct decimal formatti…
Free Reading and Extraction Methods
No desktop editor installed? Here are free alternatives — we list their limitations honestly.
Method 1: Copy-Paste to Excel (Free, Basic)
Select the table text in the PDF (Ctrl+A within the table area), copy (Ctrl+C), paste into Excel (Ctrl+V). Excel's Paste Options → Use Text Import Wizard for semi-structured data. Limitation: works only for simple grid tables with single-line cells; multi-line cells break into separate rows.
Method 2: LibreOffice Calc (Free)
Open the PDF in LibreOffice Draw, select the table, copy, paste into Calc. Calc handles multi-line cells better than Excel. Limitation: no automatic table detection; manual selection required; complex tables may paste incorrectly.
Method 3: Tabula (Free, Open Source)
Upload PDF, draw selection boxes around tables, export as CSV or Excel. Limitation: browser-based (requires upload); manual table area selection; no merged cell handling.
Free vs. Desktop Editor for Reading and Extracting
We tested each method on real documents to give you an honest comparison.
| Method | Read | Extract | Offline | Free |
|---|---|---|---|---|
| Microsoft Edge | ★★★★ | ★ | ✔ | ✔ |
| macOS Preview | ★★★ | ★ | ✔ | ✔ |
| Adobe Acrobat Reader | ★★★★ | ★★ | ✔ | ✔ |
| Calibre | ★★★ | ★★★ | ✔ | ✔ |
| Desktop Editor | ★★★★★ | ★★★★★ | ✔ | Trial |
Verdict: Edge and Acrobat Reader cover everyday reading. For table extraction and batch comparison, a desktop editor adds significant power.
Why Desktop Editors Extract Tables More Accurately
Desktop PDF editors with AI-powered table detection analyze both spatial layout and text content to identify table structure. They detect column boundaries by finding vertical alignments of text, recognize merged cells by analyzing text spans, and preserve multi-line cell entries by grouping spatially adjacent text. The extraction preview shows what will be exported, so you can verify accuracy before exporting.
Online extraction tools typically use simpler algorithms that fail on complex tables — they work for simple grid tables but produce unusable output for anything with merged cells or multi-line entries. They also require uploading potentially sensitive financial or business data to external servers. See the full comparison →
Reading and Extracting from PDFs: Common Questions
Why does my copied table paste into Excel as one long column?
The PDF's text does not have column separators — Excel does not know where column breaks are. Use Excel's Text to Columns feature (Data → Text to Columns) to split the text based on a delimiter (tab, comma, or fixed width). Alternatively, use a dedicated table extraction tool that detects column boundaries automatically rather than relying on copy-paste.
Can I extract a table that has merged cells?
Desktop editors with AI table detection recognize merged cells by analyzing text that spans multiple column widths. The merged cell is exported as a single cell spanning the appropriate columns in Excel. Basic extraction tools treat merged cells as separate cells, splitting the text across columns. Verify merged cell detection in the preview before exporting.
How do I extract multiple tables from the same PDF?
Desktop editors can detect all tables on a page simultaneously and let you choose which ones to export. Each detected table is highlighted with a numbered label. Select the tables you want, then export them individually or as a batch. Some tools also support extracting tables from all pages at once, creating a single Excel file with each table on a separate sheet.
Are there any limitations to this method?
Every method has trade-offs. Free built-in tools (Edge, Preview) cannot edit existing PDF text — they only add annotations or new text boxes. LibreOffice may shift complex layouts (tables, columns, images) when importing PDFs. Online tools introduce privacy risks by processing files on external servers. Desktop editors offer the most complete feature set but require a one-time purchase. For each specific task above, we have noted the most significant limitation — choose the method whose limitations you can accept for your document type. Tested on: Windows 11 24H2, macOS 15 Sequoia, PDF Agile v4.x, LibreOffice 24.x.