Free · Fast · Privacy-first

Extract PDF Table to Excel

Tables in PDFs are common in published reports, scientific papers, government data releases, and corporate disclosures, but extracting them for further analysis has historically required either expensive desktop software or fragile copy-paste workflows that lose column alignment the moment a cell wraps to a second line.

⚡

Detects table regions automatically

🔒

Preserves column alignment

✨

Handles multi-page tables

⚡

No sign-up required

Cost: Free tier
Sign-up: Not required
Processing: Tool-specific
Privacy: Clearly disclosed

IframeResponsiveAttribution included

Add this PDF to Excel to your website

Drop the PDF to Excel into a blog post, product docs, intranet, or school portal with one iframe. Processing, privacy, and usage limits are the same as on the full tool page.

One copy-ready line of HTML
Responsive — adapts to any container width
No API credentials are placed in the snippet

Embed code

<iframe
  src="https://www.fixtools.io/pdf/pdf-to-excel?embed=1"
  width="100%"
  height="780"
  frameborder="0"
  style="border:0;border-radius:16px;max-width:900px;"
  title="PDF to Excel by FixTools"
  loading="lazy"
  allow="clipboard-write"
></iframe>

<iframe
  src="https://www.fixtools.io/pdf/pdf-to-excel?embed=1"
  width="100%"
  height="780"
  frameborder="0"
  style="border:0;border-radius:16px;max-width:900px;"
  title="PDF to Excel by FixTools"
  loading="lazy"
  allow="clipboard-write"
></iframe>

Attribution-friendly: a small "Powered by FixTools" link appears in the embed footer.

The technical challenge of table extraction from PDFs

Tables in PDFs are not stored as tables. They are stored as positioned text glyphs whose alignment happens to look like rows and columns when rendered on a page. There is no explicit row index or column index attached to any cell value in the PDF file format. Instead, the visual table emerges from consistent X-coordinate positioning of glyphs across rows and consistent Y-coordinate positioning across columns. Recovering the table structure from this purely visual layout is a non-trivial inference problem that good extraction tools solve by clustering glyphs into words, words into cells, and cells into rows based on alignment patterns and gap detection.

FixTools applies several heuristics in parallel to identify table structure. Vertical alignment patterns across multiple consecutive lines indicate column boundaries. Consistent gaps between groups of right-aligned numeric text strongly suggest a numeric column. Repeated header rows near the top of pages mark table headers. The tool combines these signals to produce a confidence-scored column layout, then presents it to you for verification on the preview before committing to the conversion. This human-in-the-loop step is important because automated detection cannot resolve all ambiguities, particularly in tables with merged cells, nested headers, or footnote references.

Tables that span multiple pages are reconstructed by detecting repeated header rows on each page and joining the body rows into a single continuous range in the output workbook. This is the convention used by most report-generation tools when a table needs to break across pages: the header repeats at the top of each new page, and the body continues from where it left off. The converter recognises this pattern and produces an output where the table appears once with all its body rows in sequence, exactly as you would want it for analysis. Tables that legitimately occupy multiple pages without repeated headers will still be joined but may benefit from a manual review of the page-break rows to confirm continuity.

For complex tables with merged cells or nested column headers, the conversion handles the most common patterns automatically but may require manual adjustment for unusual layouts. Merged header cells that span multiple columns are typically preserved as a single cell in the corresponding position in the output, with the cells below it remaining as separate columns. Tables with truly nested structures (a header row above sub-header rows above the actual columns) may need manual reorganisation in Excel after conversion. The converter prioritises producing clean column data for the body rows even at the cost of slightly simplifying complex header hierarchies.

Microsoft: Import from PDF with Power Query Tabula: open-source PDF table extraction research

How to use this tool

💡

Upload your PDF and the tool will identify table regions across all pages. Adjust column boundaries on the preview if needed, then convert to Excel.

How It Works

Step-by-step guide to extract pdf table to excel:

1
Upload the PDF with tables
Drag your PDF into the upload area. The tool scans all pages and identifies regions that look like tables based on glyph alignment patterns. A preview shows you which regions were detected and how the column boundaries are positioned across the table.
2
Review detected columns
Inspect the column boundary lines on the preview. They should align with the visible gaps between columns in the source table. If a boundary cuts through actual cell content or merges two columns into one, drag the line to its correct position. The preview updates immediately so you can see the effect of your adjustment.
3
Convert to Excel
Click Convert to Excel. The tool processes each detected table region, writes the rows and columns to a SheetJS workbook, and produces a downloadable XLSX file. Multi-page tables become single continuous ranges with duplicate header rows removed automatically.
4
Verify column alignment
Open the downloaded XLSX. Scroll to a row where you can clearly identify each cell value from the source PDF, and check that each value landed in the correct column. If any value is offset by one column, the table boundary needs adjustment and a re-conversion. Most well-structured tables convert correctly on first attempt.

Real-world examples

Common situations where this approach makes a real difference:

Researcher extracting data from published papers

A graduate student doing a literature review needs to extract results tables from twenty academic papers, each published as PDF. Manually retyping the numbers would take an entire week and introduce errors that could invalidate the meta-analysis. Converting each paper's tables to Excel preserves the original column structure so the data can be loaded into statistical software with confidence in its provenance.

Government data analyst building a comparison

A policy analyst downloads quarterly statistical bulletins published as PDFs by a national statistics agency. Each bulletin contains a dozen reference tables that the analyst needs to track over time. Converting each PDF table to Excel lets the analyst maintain a running tracker workbook where each quarter's data appends to the bottom of the corresponding sheet, enabling time-series analysis that the source PDFs make tedious.

Financial analyst pulling competitor data

A financial analyst studying competitors reads through ten annual reports, each published as a PDF with dozens of data tables. Extracting each table to Excel enables apples-to-apples comparison across companies on metrics like revenue per segment, capex by year, and headcount by geography. The conversion step makes the difference between hours of retyping and minutes of clean structured data ready for ratio analysis.

Journalist building a data story

A data journalist receives a leaked PDF containing tables of campaign donation records and needs to extract the data quickly under deadline. Converting the PDF to Excel produces a sortable, filterable file where the journalist can identify the largest donors, group by city, and spot patterns that would be invisible in the original PDF format. The story ships the same day rather than waiting on manual data entry.

Pro tips

Get better results with these expert suggestions:

Split table regions before converting if pages contain narrative

If your PDF contains tables mixed with paragraphs of explanatory text, use the FixTools PDF Splitter to extract only the pages with tables first, then convert. This produces cleaner output than trying to convert the full mixed document because the tool can focus its table detection on pages where tables are dominant. The split-then-convert workflow takes an extra minute but produces noticeably cleaner Excel output.

Check footnote markers in numeric cells

Many published tables include footnote references like (1) or asterisks attached to cell values. These markers can confuse numeric column extraction because they look like additional digits. After converting, search for parentheses and asterisks in numeric columns and clean them up to make the cells truly numeric for downstream calculations. Move the footnote references to a separate notes column if you need to preserve them.

Use Excel Power Query for repeated extractions

If you extract the same kind of table from the same source on a recurring basis (e.g., quarterly statistics bulletins), set up an Excel Power Query that reads the converted XLSX and applies your standard cleanup transformations like renaming columns, removing footnote text, and parsing numeric values. Subsequent extractions just replace the source file and refresh the query, which scales the workflow to dozens or hundreds of files.

Preserve original column headers as a notes row

Some PDFs use multi-line column headers that the converter flattens into a single header row. Keep a copy of the original header text as a comment cell or notes row in the workbook so you can refer back to the full multi-line context if a column meaning becomes unclear during analysis. This is especially helpful for technical or scientific tables where header brevity can obscure the precise meaning of a column.

FAQ

Frequently asked questions

The tool analyses the positioning of text glyphs on each page and looks for patterns that indicate tabular structure: consistent vertical alignment of text across multiple rows, consistent gaps between text groups, and repeated header rows at the top of pages. Combined, these signals identify table regions with high accuracy on well-structured PDFs. The detected regions are shown on a preview so you can verify before converting, and you can adjust column boundaries manually if the automatic detection needs correction.

Yes. Multi-page tables are reconstructed into single continuous ranges in the output workbook. The converter detects repeated header rows at the top of each page and uses them to confirm that the body rows on subsequent pages belong to the same table. Duplicate headers are removed from the output so the result is a clean single range rather than multiple repeated sections.

Merged header cells that span multiple columns are preserved as merged cells in the corresponding output position. Merged data cells in the body of a table are handled by placing the value in the leftmost cell of the merged range and leaving the other cells empty. If your downstream analysis needs the value repeated across the merged range, you can fill it in manually or with a formula after opening the Excel file. Complex nested header structures may need slight cleanup after conversion.

Yes. The first row of the detected table region is treated as a header row and carried through to the Excel output. If the table uses multi-line headers, they are flattened into a single header row. Where the source PDF uses styled header rows with bold text or background colour, the conversion preserves the text but does not always replicate the styling. You can always format the header row manually in Excel after conversion if styling matters for your final use.

Tables that contain only text and numeric cells convert with high accuracy. Tables that embed small images or icons within cells will lose those images, with only the surrounding text preserved. For tables interspersed with full charts or graphics, the converter focuses on the tabular regions and ignores the chart regions. Use a screenshot tool to preserve any chart imagery you need to keep alongside the extracted tabular data.

For digitally-generated PDFs from spreadsheets, word processors, or report-generation systems, table extraction is typically near-perfect when column boundaries are clearly defined by visible gaps. Tables with closely-spaced columns or borderline alignment may require manual boundary adjustment on the preview before converting. The verification step of comparing extracted totals to source totals catches the rare cases where a column boundary missed slightly, which you can correct with a quick re-conversion.

Yes. Use the FixTools PDF Splitter first to extract only the page or pages containing the table you want, then convert that smaller PDF to Excel. This focuses the extraction on the table you care about and avoids any complications from other tables on different pages of the source document. The two-step workflow takes a minute longer but produces clean targeted output without irrelevant content cluttering the workbook.

Yes. The entire process runs in your browser tab. Your PDF file is never transmitted to any server, and the extracted table data is generated locally on your device. This privacy posture is identical to all FixTools PDF processing and means you can convert sensitive published data, embargo-period research findings, or confidential business documents without exposure to any third party.