Excel & CSV Extractor — xlsx, xls, csv to JSON avatar

Excel & CSV Extractor — xlsx, xls, csv to JSON

Pricing

Pay per usage

Go to Apify Store
Excel & CSV Extractor — xlsx, xls, csv to JSON

Excel & CSV Extractor — xlsx, xls, csv to JSON

Extract data from Excel (.xlsx) and CSV files into structured JSON. Input: URL or base64. Output: sheet name, headers, rows. Batch multiple files. $0.01/file + $0.0001/row.

Pricing

Pay per usage

Rating

0.0

(0)

Developer

Hojun Lee

Hojun Lee

Maintained by Community

Actor stats

0

Bookmarked

3

Total users

2

Monthly active users

6 days ago

Last modified

Categories

Share

Extract structured data from Excel (.xlsx) and CSV files into clean JSON. Pass a URL or base64-encoded file — get back sheet names, column headers, and rows. Works with multi-sheet workbooks. Perfect for data pipelines, AI ingestion, and ETL workflows. $0.01/file + $0.0001/row.

Run in 30 seconds

Paste any Excel or CSV URL:

https://example.com/sales-report.xlsx
https://data.gov/dataset/prices.csv
https://github.com/user/repo/raw/main/data.xlsx

No API keys needed.


What you get

One output record per sheet:

{
"file_name": "sales-report.xlsx",
"sheet": "Q1 Sales",
"row_count": 842,
"columns": ["Date", "Product", "Region", "Revenue", "Units"],
"rows": [
{"Date": "2026-01-03", "Product": "Widget A", "Region": "US", "Revenue": "12400", "Units": "124"},
{"Date": "2026-01-04", "Product": "Widget B", "Region": "EU", "Revenue": "8900", "Units": "89"}
]
}

Enable flatMode: true to get one record per row instead.


Input options

FieldDefaultDescription
fileUrlDirect URL to .xlsx or .csv file
fileBase64Base64-encoded file (alternative)
fileNameautoFile name for format detection
includeHeaderstrueFirst row = column headers
sheetNames[] (all)Specific sheets to extract
maxRowsPerSheet10000Row cap per sheet (up to 500,000)
flatModefalseOne output record per row

Use cases

  1. AI data ingestion — Feed spreadsheet data into Claude, GPT, or RAG pipelines
  2. ETL pipelines — Transform Excel reports into structured database records
  3. Financial analysis — Extract P&L, balance sheet, or budget data for processing
  4. Survey/form data — Parse exported Google Sheets or SurveyMonkey exports
  5. Inventory systems — Import product catalogs from supplier Excel files
  6. Automation — Trigger on new file uploads, extract data, push to APIs
  7. Multi-sheet reports — Extract all tabs from complex workbooks in one run
  8. Data validation — Check column consistency, row counts, and value types

Pricing

EventPrice
Actor start$0.01
Per row extracted$0.0001
ExampleFileRowsCost
Small CSV (500 rows)1500$0.06
Sales report (5,000 rows)15,000$0.51
Large dataset (50,000 rows)150,000$5.01

Supported formats

FormatExtensionNotes
Excel (modern).xlsx, .xlsmMulti-sheet, formulas evaluated
CSV.csv, .tsvAuto-detects encoding (UTF-8, Latin-1)

Legacy .xls: Not supported. Open in Excel or LibreOffice and save as .xlsx.