Extract tables from any PDF to Excel or CSV
Rent rolls, inventory counts, price sheets, member rosters: if the document is a table, LedgerBox processes it row by row and returns a spreadsheet that matches the page.
- 1:1
- Rows on page, rows out
- 20
- Files in one drop
- 4
- Export formats
What comes back · sample
Schema v1
- Table title
- Q1 inventory count
- Pages
- 3
- Rows
- 128
- Columns
- 4
Confidence flags per row
Table CSV
Field names are the LedgerBox extraction schema for PDF tables, version 1. Sample values are illustrative.
How to extract a table from a PDF
-
Upload the PDF
Digital, scanned, or photographed. Tables that continue across pages read as one document, and a single drop takes up to 20 files.
-
We detect the table structure
The header row names the columns, and cells are kept positional, so pages that repeat the header and pages that do not line up in the same grid.
-
Download the table CSV
Columns named from the header row, rows in page order, ready for Excel or Google Sheets.
PDF table anatomy
A sample multi-page inventory table, and how LedgerBox processes each part during extraction.
Q1 inventory count
Page 1 of 3
Table continues on page 2 · 128 rows total
The header row names the columns
The first header line becomes the column names for the whole document, so a table that spans three pages exports as one sheet, not three fragments.
Cells stay positional
Each cell is mapped to its column by position, which keeps pages with and without repeated headers aligned, and keeps blank cells from shifting a row sideways.
No invented arithmetic
A general table has no totals to reconcile, so LedgerBox does not pretend to check them. Instead every row carries a confidence score, and anything uncertain comes back flagged for review.
When a table is really something else
If the table is actually a bank statement, an invoice, a receipt, or a pay stub, pick that type instead: the specialized readers add field extraction and arithmetic checks a general table cannot have.
PDF table extraction FAQ
How do I extract a table from a PDF to Excel?
Create a free LedgerBox account, upload the PDF, and download the table as a CSV that opens directly in Excel or Google Sheets. The free trial requires no credit card.
What kinds of documents does it handle?
Anything tabular: rent rolls, inventory counts, price lists, class rosters, packing slips. If it has rows and columns, it converts. Financial documents have their own dedicated types with extra checks.
Does it work with scanned tables?
Yes. OCR-backed extraction reads scans and photos the same way as digital PDFs, and any row it cannot read with confidence comes back flagged.
How are the columns named?
From the detected header row, applied across every page of the document, so a multi-page table exports as one consistent sheet.
Is my data secure?
Documents are encrypted in transit and at rest, processed in isolated storage, and never used to train models. You can delete uploaded documents at any time and they are permanently removed. Independently audited by a third party.
Ready to extract your table?
Upload a PDF and download clean rows and columns. No card required.
LedgerBox also reads
- Bank statements Bank and credit account statements with account-period summaries and transaction rows. 15 CSV · ledgerbox_transactions_xlsx · QuickBooks CSV · QBO · Send to QuickBooks
- Invoices Vendor invoices with due dates, totals, tax, counterparty details, and line items. 8 Line items CSV · Send to QuickBooks
- Receipts Point-of-sale and expense receipts with merchant, payment, total, and line item details. 8 Line items CSV · Send to QuickBooks
- Pay stubs Payroll pay stubs with employer, employee, pay period, earnings, and deduction lines. 9 Line items CSV
- Purchase orders Buyer-issued purchase orders with supplier, delivery, totals, and ordered line item details. 11 Line items CSV
- Brokerage statements Investment and brokerage account statements with holdings, account activity, and realized gain and loss rows. 8 Line items CSV · Realized gains CSV
- W-2 forms IRS Form W-2 wage and tax statements with employer, employee, and per-box wage and withholding amounts. 14 Summary CSV
- 1099 forms IRS Form 1099 information returns (NEC, MISC, INT, DIV, K, B) with payer, recipient, and reported box amounts. 9 Summary CSV · Line items CSV
- Checks Scanned or photographed checks with payee, numeric and written amounts, date, memo, and bank routing details. 9 Summary CSV
- Merchant statements A card processing statement from a payment processor (Square, Stripe, Clover, Toast, Fiserv) showing gross card volume, transaction counts, and an itemized list of processing fees for a billing period. Not a bank statement: the counterparty is a payment processor and the line items are fees charged, not account transactions. 13 Rows CSV · Summary CSV