CSV⇄JSON
rows 0
keys 0
CSV
drop a .csv file here0 bytes
CSV
JSON
JSON
drop a .json file here0 bytes
What is a CSV to JSON converter?
CSV (comma-separated values) is the plain-text format behind spreadsheet exports from Excel and Google Sheets, database dumps, and countless data downloads. It's simple and widely supported, but it's flat — every row is just a line of text, with no real concept of nested data or data types beyond strings.
JSON is what most APIs, web apps, and modern programming languages expect instead: structured objects with real types (numbers, booleans, nested arrays). This converter turns each CSV row into a JSON object using the header row as keys, and does the reverse too — flattening a JSON array of objects back into rows and columns.
Frequently asked questions
Does it handle commas or line breaks inside a single field?
Yes — proper quoted-field parsing is supported, including escaped quotes inside a quoted value, so a field like
"Smith, John" is treated as one value rather than being split apart.Does it detect number and boolean types automatically?
Yes, when converting CSV to JSON — values that look like whole numbers, decimals, or the words
true/false become real JSON types instead of staying as quoted strings.What happens to nested objects or arrays when converting JSON to CSV?
Since CSV has no way to represent nested structure, any nested object or array inside a JSON field is converted to its JSON text representation inside that one cell, rather than being split across multiple columns.