Excel & CSV Extractor — xlsx, xls, csv to JSON
Pricing
Pay per usage
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
Maintained by CommunityActor 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.xlsxhttps://data.gov/dataset/prices.csvhttps://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
| Field | Default | Description |
|---|---|---|
fileUrl | — | Direct URL to .xlsx or .csv file |
fileBase64 | — | Base64-encoded file (alternative) |
fileName | auto | File name for format detection |
includeHeaders | true | First row = column headers |
sheetNames | [] (all) | Specific sheets to extract |
maxRowsPerSheet | 10000 | Row cap per sheet (up to 500,000) |
flatMode | false | One output record per row |
Use cases
- AI data ingestion — Feed spreadsheet data into Claude, GPT, or RAG pipelines
- ETL pipelines — Transform Excel reports into structured database records
- Financial analysis — Extract P&L, balance sheet, or budget data for processing
- Survey/form data — Parse exported Google Sheets or SurveyMonkey exports
- Inventory systems — Import product catalogs from supplier Excel files
- Automation — Trigger on new file uploads, extract data, push to APIs
- Multi-sheet reports — Extract all tabs from complex workbooks in one run
- Data validation — Check column consistency, row counts, and value types
Pricing
| Event | Price |
|---|---|
| Actor start | $0.01 |
| Per row extracted | $0.0001 |
| Example | File | Rows | Cost |
|---|---|---|---|
| Small CSV (500 rows) | 1 | 500 | $0.06 |
| Sales report (5,000 rows) | 1 | 5,000 | $0.51 |
| Large dataset (50,000 rows) | 1 | 50,000 | $5.01 |
Supported formats
| Format | Extension | Notes |
|---|---|---|
| Excel (modern) | .xlsx, .xlsm | Multi-sheet, formulas evaluated |
| CSV | .csv, .tsv | Auto-detects encoding (UTF-8, Latin-1) |
Legacy
.xls: Not supported. Open in Excel or LibreOffice and save as.xlsx.
Related actors
- PDF Text Extractor — Extract text from PDF files
- DOCX Text Extractor — Extract text from Word documents
- RSS Feed Parser — Parse RSS/Atom feeds into JSON
- Web to Markdown — Convert web pages to clean text