JSON <> CSV Converter
Pricing
from $30.00 / 1,000 conversion completeds
Go to Apify Store

JSON <> CSV Converter
Convert between JSON arrays and CSV in both directions. JSON objects are flattened (nested keys become dot-notation columns), CSV values get light type inference (numbers, booleans, nulls).
Pricing
from $30.00 / 1,000 conversion completeds
Rating
0.0
(0)
Developer
Luqin Wang
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
2 hours ago
Last modified
Categories
Share
JSON ↔ CSV Converter
Convert data between JSON and CSV in both directions, with sensible defaults:
- JSON → CSV: nested objects become dot-notation columns (e.g.
address.city), arrays become JSON strings in a single cell. Header row is the union of all keys. - CSV → JSON: light type inference — empty cells become
null,true/falsebecome booleans, numeric cells become numbers, everything else stays a string.
Input
| Field | Description |
|---|---|
| Direction | JSON -> CSV or CSV -> JSON |
| Input file URL | Public URL of a JSON or CSV file |
| Or: paste input text | Paste the JSON or CSV content directly |
| CSV delimiter | , ; tab or ` |
| Flatten nested JSON objects | On by default (JSON → CSV only) |
Output
- Dataset: one item per converted row/object
- Key-value store
OUTPUT.csv/OUTPUT.json: the converted file
Large converted files are stored as bounded parts. In that case the normal output key contains a small pointer to a manifest that identifies the parts in concatenation order.
Reliability and limits
- Input is admitted up to 8 MiB and URL responses are read in bounded chunks.
- Billing intent and an exact source snapshot are stored before each charge.
- A charge failure stops conversion; charged batches are checkpointed before a later batch is charged.
- Partial billing preserves every unpaid source item and publishes a separate preservation report.
- CSV parsing is strict: headers must be nonempty and unique, and every row must have the header's field count. CR, LF, CRLF, and mixed endings work.
Pricing (pay-per-event)
- $0.03 per conversion run
- $0.0001 per row/item converted
Run via API
curl -H "Authorization: Bearer $APIFY_TOKEN" \-H "Content-Type: application/json" \-d '{"direction": "jsonToCsv", "inputText": "[{\"a\": 1}, {\"a\": 2}]"}' \"https://api.apify.com/v2/acts/<username>~json-csv-converter/runs?waitForFinish=60"
Local development
mkdir -p storage/key_value_stores/default# put {"direction": "jsonToCsv", "inputText": "..."} in storage/key_value_stores/default/INPUT.jsonAPIFY_LOCAL_STORAGE_DIR=./storage python3 -m src.main