How to convert a csv file to json for api import
- Step 1Drop the CSV onto the converter — Drag the CSV file into the dropzone. The first row is treated as the JSON keys for every record.
- Step 2Pick the JSON output mode — Use 'array of objects' for most APIs, 'NDJSON' for streaming or batch ingestion endpoints.
- Step 3Toggle type inference — Leave inference on so prices, IDs, and quantities arrive as numbers — turn it off if your API requires every value as a string.
- Step 4Download or copy the JSON — Download the .json file, or paste the output directly into your API client's request body field.
Frequently asked questions
Will the API reject quoted numbers from a CSV?+
Often, yes. CSV exports from spreadsheets quote everything as a string. With type inference on, this tool emits 42 instead of "42" so the API parses the field correctly.
Is the CSV uploaded to a server?+
No. Conversion runs entirely in your browser. The file is never sent to JAD Apps and is never sent to your API until you fire the request yourself.
Can I produce one JSON object per line for streaming uploads?+
Yes — pick the NDJSON output mode. Each CSV row becomes a single-line JSON object, which is the format Snowflake, BigQuery, and many ingest pipelines expect.
Privacy first
Conversion runs locally in your browser. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.