CSV to Excel & JSON to CSV Converter API
Pricing
$3.00 / 1,000 file converteds
CSV to Excel & JSON to CSV Converter API
CSV to Excel, JSON to CSV and XLSX converter: convert between CSV, TSV, JSON, NDJSON and Excel XLSX from URLs, base64 or inline JSON. Delimiter and encoding detection, nested JSON flattening, typed cells. For n8n, Make and AI agents. $0.003 per file.
Pricing
$3.00 / 1,000 file converteds
Rating
0.0
(0)
Developer
Ferrolark
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
4 days ago
Last modified
Categories
Features
Share
CSV to Excel, JSON to CSV and XLSX Converter API (Data Convert)
Convert tabular data between CSV, TSV, JSON, NDJSON (JSON Lines) and Excel XLSX with one API call.
- Reads anything messy: delimiter detection (comma, semicolon, tab, pipe), UTF-8 or Windows-1252 encoding, files without a header row.
- Typed cells: numbers and booleans become real numbers in Excel, while zip codes and IDs with leading zeros stay text.
- Nested JSON flattening:
{"user": {"name": ...}}becomes auser.namecolumn; arrays stay JSON or spread into columns. - Excel you can use: bold header, frozen first row, auto-filter and sensible column widths. Formulas in data are stored as text, never executed.
- Inline rows from a previous n8n node, plus URLs and base64 files.
Real example
A CSV with spaces after commas, plus two nested JSON rows sent inline, both to Excel:
{"fileUrls": ["https://people.sc.fsu.edu/~jburkardt/data/csv/biostats.csv"],"data": [{"sku": "A-1","qty": 3,"meta": {"color": "red","tags": ["x","y"]}},{"sku": "B-2","qty": 1,"meta": {"color": "blue"}}],"dataFileName": "inventory","outputFormat": "xlsx"}
- Run time: 3.8 s on Apify at 1,024 MB.
- Platform usage: $0.0006.
- Your cost: 2 files × $0.003 = $0.006.
| Output | From | Rows | Columns | Bytes |
|---|---|---|---|---|
biostats.xlsx | CSV | 18 | 5 | 5,615 |
inventory.xlsx | JSON | 2 | 4 | 5,090 |
The JSON rows became the columns sku, qty, meta.color and meta.tags.
Price and limits
- $0.003 per file converted (the inline data counts as one file). The ZIP is free.
- Invalid files are listed in
OUTPUT.errorsand not charged. - Limits: 20 files and 50 MB per run, 500,000 rows per file, 2,000 columns.
Input
| Field | Default | What it does |
|---|---|---|
fileUrls | none | CSV, TSV, JSON, NDJSON or XLSX URLs. |
files | none | Base64 files. |
data | none | Inline rows as JSON. |
outputFormat | xlsx | xlsx, csv, tsv, json, ndjson. |
inputFormat | auto | Force the input format. |
inputDelimiter, hasHeader | auto, true | CSV reading. |
sheet | first | XLSX sheet to read. |
jsonPath | auto | Path to the rows, for example data.items. |
inferTypes | true | Numbers and booleans from CSV. |
flatten, arrays | true, json | Nested JSON handling. |
columns | none | Column order. |
outputDelimiter | , | Use ; for European Excel. |
prettyJson | false | Indented JSON. |
createShareableUrl | false | Also return signed links that work without an Apify token. |
Call it from code, n8n or an AI agent
API (synchronous):
curl -X POST "https://api.apify.com/v2/acts/ferrolark~data-convert/run-sync-get-dataset-items?maxTotalChargeUsd=0.1" \-H "Authorization: Bearer $APIFY_TOKEN" -H "Content-Type: application/json" \-d '{"fileUrls": ["https://example.com/orders.csv"], "outputFormat": "json"}'
n8n: paste this workflow on the canvas (Ctrl+V). Add a Header Auth credential with the name Authorization and the value Bearer <your Apify token>, and use it in both HTTP nodes. The second node downloads the file as an n8n binary, ready for Gmail, Drive or Slack.
{"name": "Ferrolark data-convert","nodes": [{"parameters": {},"name": "When clicking Test workflow","type": "n8n-nodes-base.manualTrigger","typeVersion": 1,"position": [0,0]},{"parameters": {"method": "POST","url": "https://api.apify.com/v2/acts/ferrolark~data-convert/run-sync-get-dataset-items?maxTotalChargeUsd=0.05","authentication": "genericCredentialType","genericAuthType": "httpHeaderAuth","sendBody": true,"specifyBody": "json","jsonBody": "{\"data\": [{\"sku\": \"A-1\", \"qty\": 3}, {\"sku\": \"B-2\", \"qty\": 1}], \"outputFormat\": \"xlsx\"}","options": {"timeout": 300000}},"name": "Run Actor","type": "n8n-nodes-base.httpRequest","typeVersion": 4.2,"position": [220,0]},{"parameters": {"url": "={{ $json.downloadUrl }}","authentication": "genericCredentialType","genericAuthType": "httpHeaderAuth","options": {"response": {"response": {"responseFormat": "file"}}}},"name": "Download file","type": "n8n-nodes-base.httpRequest","typeVersion": 4.2,"position": [440,0]}],"connections": {"When clicking Test workflow": {"main": [[{"node": "Run Actor","type": "main","index": 0}]]},"Run Actor": {"main": [[{"node": "Download file","type": "main","index": 0}]]}}}
AI agents (MCP): add the Apify MCP server (https://mcp.apify.com) to Claude, Cursor or any MCP client and allow ferrolark/data-convert. The agent gets a typed tool with the input above.
FAQ
Does it keep leading zeros?
Yes. 02134 stays text; 2134 becomes a number. Turn inferTypes off to keep everything as text.
Is it safe to open the Excel files?
Yes. Values starting with = are stored as text cells, so no formula from the data runs.
More Ferrolark tools
- Brand Name Availability Checker: domains, GitHub, npm, PyPI and more in one report.
- Domain Intelligence Report: WHOIS, DNS, email security, SSL and hosting for any domain.
- Launch Asset Pack: favicons, PWA icons, OG image and head tags from one logo.
- Live Deploy QA: meta tags, canonical, robots, OG image and favicon of your deployed routes, with diffs between deploys.
- Sitemap Delta: new, removed and broken URLs in any sitemap since the last run.
- RSS Delta: only new RSS, Atom and JSON Feed items, de-duplicated.
- PDF Merge API: merge PDFs from URLs or base64 with page ranges and a SHA-256 manifest.
- PDF Split API: split a PDF by page ranges or every N pages, or extract pages, with a ZIP and manifest.
- Image Convert: PNG, JPG, WebP, AVIF and HEIC conversion (SVG input too) from URLs or base64.
- Image Compress & Resize: resize images and compress them to a target size in KB, WebP or AVIF.
- PDF to Image: PDF pages to PNG, JPG or WebP at the DPI you choose.
- Image to PDF: JPG, PNG, HEIC and WebP images to one PDF, JPEGs embedded without recompression.
- PDF Compress: smaller PDFs, lossless or with image downsampling; charged only when smaller.
- HTML to PDF & URL to PDF: web pages or raw HTML to PDF with headless Chrome.
- Markdown to PDF: Markdown with tables, code and footnotes to a clean PDF.
- DOCX to PDF: Word, Excel, PowerPoint and ODT to PDF with LibreOffice.
Built by Ferrolark.