PDF to Excel, Markdown & Text: Extract Tables from PDFs in Bulk avatar

PDF to Excel, Markdown & Text: Extract Tables from PDFs in Bulk

Pricing

Pay per event

Go to Apify Store
PDF to Excel, Markdown & Text: Extract Tables from PDFs in Bulk

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

Pandapi

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

a day ago

Last modified

Features

Limited permissions

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.xlsx with 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 ActorOnline converters (Smallpdf, iLovePDF, Acrobat)PDFTables / Azure / TextractOther Apify PDF actors
Price$3 per 1,000 PDFsSubscription, 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)✅VariesVaries❌
Tables continuing over pages joined, repeated header removed✅❌Varies❌
Wrapped description lines kept in one row✅VariesVaries❌
Merged header cells kept in Excel, joined in CSV ("Percent Fuel Savings Improved Speed")✅PartialPartial❌
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 pagesPaid plans✅Often $15 per 1,000 pages
Failed PDFs chargedNevern/aYesVaries

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-5 or -2 for 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.