Extract Tables from PDFs
into Google Sheets
Upload a PDF, preview the extracted tables, and download as CSV or Excel — instantly, for free, with no account needed. Works with invoices, reports, bank statements, and more.
How to Extract PDF Tables into Google Sheets
How PDF Table Extraction Works
Extracting tables from PDFs is one of the most requested — and most challenging — data conversion tasks. The fundamental difficulty is that PDF files don't actually contain "tables." Unlike HTML or Excel, where table structure is explicitly defined with rows and columns, a PDF is essentially a set of drawing instructions: put this text at position (x, y), draw a line from here to there, place this image at these coordinates.
What looks like a table to your eyes is really just text items positioned at specific pixel coordinates on the page. To extract a table, the software has to reverse-engineer the structure by analyzing where text items cluster vertically (rows) and horizontally (columns), then reconstruct the grid.
How This Tool Reconstructs Tables
This tool uses PDF.js, Mozilla's open-source PDF rendering engine, to extract every text item from each page along with its exact (x, y) coordinates. It then uses a clustering algorithm to group nearby X positions into columns and groups items by their Y position into rows. The result is a reconstructed grid that represents the table as you see it on the page.
When multiple tables exist on a single page, the tool detects gaps in the data — areas where rows have significantly fewer filled cells — and splits them into separate tables. You can switch between detected tables using the table selector tabs.
Text-Based vs. Scanned PDFs
There are two fundamentally different types of PDFs, and understanding the difference is crucial for table extraction. Text-based PDFs are generated digitally — they were created by software (like Excel, Word, a billing system, or a web browser's "Print to PDF" function). These contain actual text data that can be selected, copied, and extracted. This tool works with text-based PDFs.
Scanned PDFs are images of paper documents. When you scan a document on a flatbed scanner or take a photo of a page, the resulting PDF contains a picture of text, not actual text characters. No amount of coordinate analysis can extract text from an image — you need OCR (optical character recognition) for that. A quick test: try selecting text in your PDF viewer. If you can highlight individual words, it's text-based. If the entire page selects as one block, it's scanned.
Best Types of PDFs for This Tool
Bank and financial statements: These are almost always text-based and have clean, consistent table structures. Transaction tables, account summaries, and balance sheets extract reliably.
Invoices and purchase orders: Line items, quantities, prices, and totals are typically arranged in well-structured tables that extract cleanly.
Government and regulatory reports: Published data tables from agencies, census data, and statistical reports are usually digitally generated with consistent formatting.
System-generated reports: Any PDF exported from software (ERP systems, CRM tools, analytics platforms) contains text-based data that extracts well.