PDF to Excel, Markdown & Text: Extract Tables from PDFs in Bulk
Pricing
Pay per event
PDF to Excel, Markdown & Text: Extract Tables from PDFs in Bulk
Extract tables from PDFs to Excel/CSV and convert PDF to Markdown or text, in bulk. Ruled and borderless tables (bank statements, reports), multi-page tables joined, real numbers, OCR in 12 languages. $3 per 1,000 PDFs.
Pricing
Pay per event
Rating
0.0
(0)
Developer
Pandapi
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
a day ago
Last modified
Categories
Features
Share
Turn any number of PDFs into clean text, LLM-ready Markdown and real spreadsheets. Tables come out as Excel (.xlsx) or CSV, including borderless tables like bank statements and financial reports, with numbers you can sum and tables that run over several pages joined into one. Scanned pages are read with OCR. Works with PDF links, uploads or base64 through the API.
Price example: 500 bank statements to one Excel workbook costs $1.50. Failed PDFs are free and there is no start fee.
What you get
- Excel workbook per PDF (one sheet per table plus an index sheet), and
tables.xlsxwith every table from the run, so a batch of 200 statements lands in one file. - CSV per table if you prefer (UTF-8 with BOM, opens cleanly in Excel and Google Sheets).
- Markdown and plain text with headings, lists and tables kept, repeated headers, footers and page numbers removed.
- JSON with each table's page, title, header and rows, plus metadata, per-page text, links and RAG chunks.
Why this one
| This Actor | Online converters (Smallpdf, iLovePDF, Acrobat) | PDFTables / Azure / Textract | Other Apify PDF actors | |
|---|---|---|---|---|
| Price | $3 per 1,000 PDFs | Subscription, daily limits on free plans | ~$10-50 per 1,000 pages | ~$5 per 1,000 PDFs + start fees |
| Borderless tables (statements, reports) | ✅ | Often messy | ✅ | ❌ (text or Markdown only) |
Excel with real numbers ($1,250 → 1250, (300) → -300, 12.5% → 0.125) | ✅ | Varies | Varies | ❌ |
| Tables continuing over pages joined, repeated header removed | ✅ | ❌ | Varies | ❌ |
| Wrapped description lines kept in one row | ✅ | Varies | Varies | ❌ |
| Merged header cells kept in Excel, joined in CSV ("Percent Fuel Savings Improved Speed") | ✅ | Partial | Partial | ❌ |
| One workbook for a whole batch of PDFs | ✅ | ❌ | ❌ | ❌ |
| Bulk + API + schedules + integrations (Make, n8n, Zapier) | ✅ | ❌ | API only | ✅ |
| OCR for scanned pages, 12 languages | ✅ $5 per 1,000 pages | Paid plans | ✅ | Often $15 per 1,000 pages |
| Failed PDFs charged | Never | n/a | Yes | Varies |
Output example
{"fileName": "statement-2026-08.pdf","status": "ok","pageCount": 2,"tableCount": 1,"excelUrl": "https://api.apify.com/v2/key-value-stores/.../records/statement-2026-08.xlsx","tables": [{"index": 1, "page": 1, "pageEnd": 2, "method": "ruled", "title": null,"header": ["Date", "Description", "Debit", "Credit", "Balance"],"headerRows": 1, "rowCount": 47, "columnCount": 5,"rows": [["Date", "Description", "Debit", "Credit", "Balance"],["08/02/2026", "UTILITY ELECTRIC CO", "124.82", "", "4,085.73"]]}],"markdown": "...","text": "..."}
rows includes the header rows first (headerRows tells you how many); header is one flat header line. method is ruled (table drawn with lines) or aligned (borderless, found from aligned columns).
The run's Output tab links All tables (Excel). Every file is also in the run's key-value store (Storage tab).
PDFs that fail (404, not a PDF, wrong password, too large) come back with "status": "failed" and a clear error, and are not charged.
Pricing
- $3 per 1,000 PDFs extracted ($0.003 each), tables and spreadsheets included
- $5 per 1,000 OCR pages ($0.005 per scanned page), only for pages that need OCR
Set "Maximum cost per run" in Apify to cap spending.
Tips
- Bank statements and reports: keep "Ruled and borderless tables" on. Use All tables stacked on one sheet to get one long sheet for a whole batch.
- Only tables drawn with lines: switch to that mode if a document has lots of aligned numbers that are not tables (e.g. forms).
- Use Pages to process only the parts you need, e.g.
3-5or-2for the last two pages. - Scanned PDFs: their text is read with OCR; table detection works on PDFs with a text layer.
FAQ
How do I extract tables from many PDFs into one Excel file? Add all the PDF links (or upload them), keep the default table mode, and download tables.xlsx from the run's key-value store: every table from every PDF, one sheet each, plus an index sheet. Choose All tables stacked on one sheet for one long sheet.
Does it handle borderless tables like bank statements? Yes. Keep "Ruled and borderless tables" on. Rows that wrap onto two lines stay one row, and numbers like $1,250.00 or (300) become real numbers.
Can it convert PDF to Markdown for RAG or an LLM? Yes. Every PDF also comes back as Markdown (headings, lists and tables kept) and plain text, with optional RAG chunks.
What about scanned PDFs? Pages without a text layer are read with OCR in 12 languages and charged $0.005 per page. Pages that already have text are never charged for OCR.
How do I call it from Python or n8n? Use the Apify API or client with a list of PDF links in urls and read the dataset; the Excel files are in the run's key-value store. It also works in Make, n8n, Zapier and the Apify MCP server.
Responsible use
Only process documents you have the right to use. Files you send are processed in your own Apify run and stored in your own Apify storage.
More from Pandapi 🐼
Pandapi makes friendly, no-nonsense data tools: simple input, clean output, and fair pay-per-result prices. Found a bug or need a feature? Open an issue on the Issues tab and we answer fast.
- Web Page to Markdown: clean, chunked Markdown from any URL or sitemap, ready for AI and RAG
- Website Contact Details Scraper: business emails, phones and social links, one row per website
- Website Screenshot: full-page and mobile screenshots or PDFs of many URLs at once
- Broken Link Checker: every 404, dead link and redirect on a site, with the page it is on
- Public Tenders Feed: government tenders and contract awards from six official portals
- App Store Reviews Scraper: iOS reviews, ratings and app details from about 180 countries
- Google Play Reviews Scraper: Android reviews with developer replies, ratings and app data, many languages
- HTML to PDF: web pages, HTML or a template plus JSON rows (invoices, certificates) to PDF
- Hacker News Scraper: stories, comments, Show HN and job posts, filtered your way