JSON <> CSV Converter avatar

JSON <> CSV Converter

Pricing

from $30.00 / 1,000 conversion completeds

Go to Apify Store
JSON <> CSV Converter

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

Luqin Wang

Maintained by Community

Actor 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/false become booleans, numeric cells become numbers, everything else stays a string.

Input

FieldDescription
DirectionJSON -> CSV or CSV -> JSON
Input file URLPublic URL of a JSON or CSV file
Or: paste input textPaste the JSON or CSV content directly
CSV delimiter, ; tab or `
Flatten nested JSON objectsOn 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.json
APIFY_LOCAL_STORAGE_DIR=./storage python3 -m src.main