CSV to JSON
Convert CSV data to JSON. Free, no signup, runs in your browser.
How It Works
Paste CSV data with headers in the first row. Click Convert and each row becomes a JSON object with the headers as keys. The output is a formatted JSON array.
What Is CSV to JSON Conversion?
CSV (Comma-Separated Values) is a simple tabular format used by spreadsheets and databases. JSON (JavaScript Object Notation) is the standard format for APIs and web applications. Converting between them is a common task when moving data between systems.
Example Conversion
The header row supplies the keys and each data row becomes one object in the output array. Given this CSV:
| name | age | |
|---|---|---|
| Alice | [email protected] | 30 |
| Bob | [email protected] | 25 |
You get a JSON array of two objects with the keys name, email, and age. All values are strings, and any surrounding spaces are trimmed.
Common Uses
Turn a spreadsheet export into JSON for an API request, seed a database or a test fixture from tabular data, or reshape a CSV report so a JavaScript app can read it. Because the conversion happens locally, it is safe to use with data you would not want to paste into an online service.
Frequently Asked Questions
How do I convert CSV to JSON?
Paste your CSV data into the input box with column names in the first row, then click Convert. Each following row becomes a JSON object using the header names as keys, and the tool outputs a formatted JSON array you can copy.
Does the first row have to be the header?
Yes. The tool treats the first line as the header row and uses those values as the keys for every JSON object. You need at least a header row plus one data row for the conversion to run.
Does it handle commas and quotes inside CSV fields?
Yes. Fields wrapped in double quotes can contain commas, and a doubled double-quote inside a quoted field is read as a literal quote character. This follows the common CSV quoting convention so values are not split incorrectly.
Are number and boolean values converted to real JSON types?
No. Every value is kept as a JSON string, and leading and trailing spaces are trimmed. If you need typed numbers or booleans, cast them after conversion in your own code.
Is my CSV data uploaded to a server?
No. The entire conversion runs in your browser using JavaScript. Your CSV never leaves your device and nothing is sent to or stored on a server.