Excel to JSON
excel_to_jsonConvert Excel .xlsx files from a public URL into JSON rows, or turn JSON/NDJSON files into Excel sheets.
Instructions
Returns one JSON item per spreadsheet row (numbers and dates kept). For a JSON/NDJSON file it returns one item with a download link to the new .xlsx file. Reads an Excel .xlsx file from a public URL (one sheet or all sheets, any header row) and turns its rows into JSON. A JSON or NDJSON file goes the other way, into an Excel sheet. Give at least one of: fileUrl. Runs the Apify Actor ucchiii/excel-to-json on YOUR Apify account (APIFY_TOKEN); you pay that Actor's pay-per-event price, see https://apify.com/ucchiii/excel-to-json.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "excel_to_json"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | No | Excel to JSON: sheet name (case does not matter). Empty = the first sheet; * = all sheets (each row gets a _sheet field and the .json file is an object keyed by sheet name). JSON to Excel: name of the new sheet (default Data). | |
| fileUrl | No | Public http(s) link to the file, up to 100 MB. An Excel file (.xlsx) becomes JSON; a JSON or NDJSON file becomes Excel. | |
| fileName | No | Start of the output file name, for example 'prices' gives prices.json or prices.xlsx. Empty = taken from the source file name. | |
| headerRow | No | Excel to JSON: the row that holds the column names (default 1). Rows above it are skipped. 0 = no header row (columns are named column_1, column_2, ...). |