Excel to JSON: XLSX, CSV & TSV files from URLs avatar

Excel to JSON: XLSX, CSV & TSV files from URLs

Pricing

$10.00 / 1,000 file converteds

Go to Apify Store
Excel to JSON: XLSX, CSV & TSV files from URLs

Excel to JSON: XLSX, CSV & TSV files from URLs

Convert XLSX, CSV and TSV files from URLs into clean JSON — one dataset item per spreadsheet row — with all sheets included and types preserved. $0.01 per successfully converted file, no start fee. Failed, unsupported or corrupt files are reported but never charged.

Pricing

$10.00 / 1,000 file converteds

Rating

0.0

(0)

Developer

Yodesla

Yodesla

Maintained by Community

Actor stats

0

Bookmarked

1

Total users

1

Monthly active users

a day ago

Last modified

Categories

Share

Excel to JSON: XLSX, CSV & TSV from URLs, pay per converted file

Turn .xlsx, .csv and .tsv files from URLs into clean JSON — every spreadsheet row becomes one dataset item, so you can download the result as JSON, CSV, Excel or JSONL, or feed it straight into your automation (Make, Zapier, n8n, your own code). $0.01 per successfully converted file, no start fee.

Use cases

  • Feeding spreadsheet data into Make, Zapier, n8n or your own code
  • Normalizing a batch of customer/vendor XLSX and CSV exports to one JSON schema
  • Turning shared spreadsheets (public URLs) into API-ready rows
  • Prepping tabular data for AI/RAG pipelines

Features

  • All sheets of a workbook, or only the ones you name.
  • Header detection: the first non-empty row becomes the field names. Duplicate headers get _2, _3; blank headers become column_N. You can turn this off.
  • Types preserved: numbers stay numbers, true/false stay booleans, dates become ISO 8601 strings, and formulas return their saved (cached) value.
  • CSV auto-detection: comma, semicolon, tab or pipe delimiters; UTF-8 (with or without BOM) or Windows-1252 text.
  • Every row carries _file, _sheet and _row so you can trace it back.
  • A per-file report (key-value store record REPORT) lists status, sheets, row counts, columns and truncation for every URL.

Pricing: pay only for files that converted

One event per successfully converted file ($0.01), however many sheets or rows it has (up to your limits). Failed downloads, unsupported formats (e.g. legacy .xls), password-protected or corrupt files, empty files and limit hits are reported but never charged. There is no start fee. The run checks your spending limit before each file.

Limits

  • Up to 50 URLs per run; files up to 50 MB (default 20); up to 200,000 rows per sheet (default 50,000).
  • 2,000,000 cells per file; 60 seconds of processing per file.
  • Public http(s) links only; local and private-network addresses are refused.
  • Not supported: legacy .xls (save as .xlsx), password-protected workbooks, .ods.
  • Formulas: the value saved in the file is returned. Files written by tools that don't save computed values return empty values for formula cells.

FAQ

Does it support legacy .xls or .ods files? No — .xlsx, .csv and .tsv only. Save legacy .xls as .xlsx first.

Does it read every sheet in a workbook? Yes, all sheets by default, or only the ones you name.

How are formulas handled? The cached value saved in the file is returned. Files written by tools that don't save computed values return empty values for formula cells.

Do I pay per row or per file? Per file: $0.01 per successfully converted file, no start fee, however many sheets or rows it has (up to your limits).

What happens with a file that fails? It is reported in the per-file report with its status and never charged.

Can I get the output in other formats? Yes — download the dataset as JSON, CSV, Excel or JSONL.

Input example

{
"fileUrls": ["https://example.com/report.xlsx", "https://example.com/data.csv"],
"firstRowIsHeader": true,
"sheetNames": [],
"maxRowsPerSheet": 50000
}

Output example (one dataset item)

{"_file": "https://example.com/report.xlsx", "_sheet": "Orders", "_row": 1,
"id": 1, "amount": 19.99, "date": "2026-09-01T00:00:00", "paid": true}