CSV to JSON Converter
Paste CSV or a JSON array of objects, pick a direction and delimiter, and see the converted result immediately — useful for turning a spreadsheet export into an API payload, or a JSON response into a CSV someone can open in a spreadsheet.
Overview
CSV to JSON: the first row is treated as the header row, and each following row becomes one JSON object keyed by those headers. Quoted fields (needed when a value itself contains the delimiter, a quote, or a newline) are parsed correctly, including doubled `""` as an escaped quote inside a quoted field. Every value stays a string — the tool never guesses that `"007"` should become the number `7`, since that guess is often wrong for real-world data like ZIP codes or IDs.
JSON to CSV: the input must be a JSON array of flat objects (no nested objects or arrays as values). The header row is the union of every object's keys, in the order they're first seen, so rows with missing keys just get an empty cell rather than causing an error.
Examples
CSV to JSON
name,age Alice,30 Bob,25
[
{
"name": "Alice",
"age": "30"
},
{
"name": "Bob",
"age": "25"
}
]
JSON to CSV
[{"name": "Alice", "age": "30"}, {"name": "Bob", "age": "25"}]
name,age Alice,30 Bob,25
How It Works
- Paste your CSV or JSON into the input box.
- Choose the direction: CSV to JSON, or JSON to CSV.
- Choose a delimiter — comma, semicolon, or tab — matching your data.
- Click Convert to see the result.
Use Cases
Turning a spreadsheet export into API test data
Export a sheet as CSV, convert it to JSON, and paste it directly into an API request body or test fixture.
Sharing a JSON API response as a spreadsheet
Convert a flat JSON array response to CSV so a non-technical teammate can open it in Excel or Google Sheets.
Tips
- All CSV values convert to JSON strings, never numbers or booleans — convert `"30"` to a number yourself afterward if your use case needs it.
- A data row with a different number of fields than the header row is reported as an error rather than silently padded or truncated, so a malformed CSV doesn't produce silently-wrong JSON.
FAQ
No. Conversion happens entirely in your browser — nothing you paste ever leaves your device.
Yes. A field wrapped in double quotes can contain the delimiter or a line break, and a literal double quote inside a quoted field is written as two double quotes ("") per the standard CSV convention.
The tool reports exactly which row has a mismatched field count instead of guessing how to pad or trim it.
No — CSV only supports flat, tabular data. The tool reports an error naming the field that contains a nested value instead of silently flattening or dropping it.