CSV ↔ JSON Converter
Convert CSV data to JSON or a JSON array to CSV, with format checks.
● Processed locally in your browser unless the page says otherwise.
When to convert CSV and JSON
This CSV and JSON converter turns table data into a JSON array or converts a JSON array back to CSV. It is useful for spreadsheets, API testing, imports, data cleaning, frontend work, and admin data preparation.
CSV represents rows and columns, while JSON represents objects and nested structures. When converting, check headers, commas, line breaks, quotes, and data types.
Formula or logic
- The first CSV row is often used as field names
- Each CSV row can become one JSON object
- A JSON array can be converted back to CSV rows
- Fields containing commas or line breaks must be quoted correctly
Example
A CSV with name,email,age columns can become a JSON array where each row is one object, which is useful for API testing or frontend mock data.
Common questions
Can CSV represent nested JSON?
CSV is a flat table format, so nested data usually needs to be flattened or handled separately.
Will numbers become strings?
It depends on the conversion rule. Some tools keep values as strings, while others detect numbers and booleans.
What if a field contains a comma?
Valid CSV wraps that field in quotes so the comma is not treated as a separator.