JSON to CSV
json_to_csvConvert JSON to CSV with one row per object, flatten nested fields to dotted columns, and guard against spreadsheet formulas.
Instructions
Convert JSON to CSV. An array of objects becomes one row per object with nested objects/arrays flattened to dotted columns (address.city, tags.0); an array of arrays is written as-is. Fields are quoted only when needed (delimiter, quotes, line breaks, leading/trailing spaces); CRLF line ends. A formula guard (on by default) prefixes cells starting with = + - @ so spreadsheets don't run them. Give "text" or a file "path". Web version: https://s3eidat.github.io/csv-json/
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| bom | No | Start with a UTF-8 BOM so Excel reads non-English text correctly. | |
| path | No | Or: a path to a JSON file (UTF-8; use this for big inputs). | |
| safe | No | Formula guard: prefix cells like =SUM(A1) with ' (default true). | |
| text | No | The JSON (array or object) as inline text. | |
| header | No | Include a header row (default true). | |
| output | No | Optional: also write the result to this file path (or folder ending in "/"). The result text is then left out of the reply. Results over 1,000,000 characters are always written to a file. | |
| delimiter | No | Delimiter: "auto" (comma), ",", ";", "tab" or "|". | auto |