How to use JSON to CSV Converter
- Paste a JSON object or an array of objects. Try the example to see the expected shape.
- Keep spreadsheet formula protection on for data you may open in a spreadsheet, then select Convert.
- Review the CSV, copy it, or download the .csv file. Editing the input hides the old result until you convert again.
A closer look
JSON records name their fields; CSV arranges values into rows and columns. This tool collects field names across every record, so a field appearing only in a later object still receives a column. Commas, quotes, and line breaks inside a value are escaped using CSV quoting rules. For example, a note saying Hello, world stays in one cell. Nested objects and arrays become JSON text inside a cell rather than being silently flattened. Null and missing fields become empty cells; a CSV file cannot retain all JSON type information.
A practical example
Convert [{"name":"Sam","score":8}] into a header row name,score and one data row. CSV cells are text, so the round trip does not preserve every JSON type.
A useful tip
Spreadsheet programs may interpret a cell beginning with =, +, -, or @ as a formula. The default protection prefixes risky cells with an apostrophe. Disable it only when preserving original cell text is intentional and you trust the data.
Good questions. Simple answers.
Why is an apostrophe added to some cells?
Formula protection helps keep spreadsheet applications from interpreting cell text as a command. It changes the exported text intentionally and is enabled by default.
Will converting back recover the original JSON exactly?
Not always. CSV lacks JSON types and nesting. Empty and null values can become indistinguishable, and nested values are exported as text. Keep the original JSON when those distinctions matter.
Explore all developer tools for related tasks and category-specific guidance, or read how Toolzafi handles your data.