CSV to JSON Converter
Convert CSV text into a JSON array of objects.
Turn an array of JSON objects into a spreadsheet-ready CSV.
Runs in your browser. Your input is never uploaded.
Paste a JSON array of objects (a single object is treated as one row).
Choose a delimiter and whether to include the header row.
Convert, then copy or download the CSV.
Input
[{"id":1,"user":{"name":"Ada"}},{"id":2,"note":"hi, there"}]Output
id,user.name,note
1,Ada,
2,,"hi, there"Convert CSV text into a JSON array of objects.
Format, beautify and minify JSON with custom indentation.
Convert JSON objects and arrays into well-formed XML.
Arrays are serialized as a JSON string inside the cell, so no data is lost.
Cells starting with =, +, - or @ can be executed as formulas by spreadsheets. When enabled, such cells get a leading apostrophe-safe prefix. You can turn it off.
Yes, use the CSV to JSON converter.
Learn what JSON is, its syntax rules, data types, common mistakes and how to read and write it in JavaScript and Python.
Paste or type input above, or press Sample to see an example.