PDF Tables to CSV, Excel & JSON Extractor

Finds tables in digital (text-based) PDFs and exports each one as a CSV file, an Excel workbook per PDF, and clean JSON rows keyed by column name. Handles both ruled tables (with lines) and borderless tables aligned by spacing, such as bank statements and price lists.

Features

• Bulk PDF URLs and page ranges like 1-3,7
• Two detection methods (ruled lines or text alignment) with automatic fallback
• First row as header (optional), JSON rows with column names
• CSV per table plus one XLSX workbook per PDF, saved with direct download links
• Filters out two-column prose that other tools mistake for tables

Use cases

Bank and credit card statements into spreadsheets, supplier price lists, financial and government reports, research data tables.

Limits

Works on digital PDFs. Scanned image-only PDFs have no text layer; run them through our PDF Text Extractor with OCR first. Max file size 50 MB.

Input example

{
  "pdfUrls": [
    "https://www.irs.gov/pub/irs-pdf/p15t.pdf"
  ],
  "pages": "10"
}

Output example

{
  "pdfUrl": "https://example.com/statement.pdf",
  "status": "ok",
  "page": 1,
  "table": 1,
  "rowCount": 3,
  "columns": [
    "SKU",
    "Item",
    "Qty",
    "Price"
  ],
  "rows": [
    {
      "SKU": "A-100",
      "Item": "Widget small",
      "Qty": "10",
      "Price": "$4.50"
    },
    {
      "SKU": "A-200",
      "Item": "Widget large",
      "Qty": "5",
      "Price": "$9.75"
    }
  ],
  "csvUrl": "https://api.apify.com/v2/key-value-stores/<storeId>/records/doc1-p1-t1.csv"
}

Pricing

Pay per event, so you pay only for results.

$0.002 per PDF page processed ($2 per 1,000 pages). A 50-page statement costs $0.10. Use the Pages field to process only the pages you need. PDFs that fail to download are not charged.

There is also Apify's standard run-start fee of $0.00005 per GB of run memory (a fraction of a cent per run). The exact prices are always shown on the Pricing tab. You can cap any run with the Maximum cost per run setting.

Use it from code or no-code tools

Every run can be started from the Apify API, the Apify Python/JS clients, or connected to n8n, Make, Zapier and Google Sheets through Apify integrations. Results download as JSON, CSV, Excel or XML.

from apify_client import ApifyClient
client = ApifyClient("<YOUR_APIFY_TOKEN>")
run = client.actor("tidyfold/pdf-tables-to-csv").call(run_input={'pdfUrls': ['https://www.irs.gov/pub/irs-pdf/p15t.pdf'], 'pages': '10'})
for item in client.dataset(run["defaultDatasetId"]).iterate_items():
    print(item)

Support

Found a bug or need a field added? Open an issue on the Issues tab. Tidyfold maintains these tools daily and usually replies within 1 business day.