Extract text and tabular data from a PDF into an XLSX spreadsheet, with automatic table detection and formatting for genuinely tabular pages.
How It Works
How PDF to Excel Works
The PDF is parsed server-side with smalot/pdfparser, which reads each page's embedded text along with the horizontal gaps between text blocks — pdfparser inserts tab characters where it detects large gaps, which is a strong signal of column boundaries in a table.
Each page becomes its own sheet in the output workbook. The tool splits each line on those tab characters to reconstruct rows and columns; if a page has at least two columns of data, it is treated as tabular and gets a styled header row (bold white text on a dark blue background) with alternating row shading and a frozen header for readability.
Pages that come back as a single column of text (no clear tabular structure) are still written to their own sheet as plain rows, so you still get every page's content even if it wasn't originally a table.
Worked Example
See It In Action
A 4-page PDF where page 2 contains a pricing table with 5 columns gets its own sheet named "Page 2" with a dark-blue bold header row, alternating row colors, and auto-sized columns, while a plain-text page like the cover sheet is written as simple unformatted rows on its own sheet.
FAQ
Frequently Asked Questions
Does this work on scanned PDFs?
No — like PDF to Word, this extracts existing embedded text; it doesn't perform OCR. Scanned or image-based PDFs need the OCR PDF tool first.
How does the tool know what's a table versus regular text?
It relies on tab characters that the PDF parser inserts wherever it detects a large horizontal gap between text blocks — pages with at least two detected columns get table-style formatting (header row, shading); pages without that pattern are written as plain text rows.
Will each PDF page become its own sheet?
Yes — every page in the source PDF is written to its own named sheet ("Page 1", "Page 2", etc.) inside the resulting XLSX workbook.