CSV Output
When to Convert JSON to CSV
Also searched as: json to csv converter online free | convert json to csv | json to spreadsheet converter | json array to csv
JSON (JavaScript Object Notation) is the standard for web APIs and application data interchange. CSV (Comma-Separated Values) is the standard for spreadsheet applications (Excel, Google Sheets) and many data analysis tools (pandas, R, Tableau). Converting between the two is one of the most common data engineering tasks. This tool handles the most complex scenarios: nested objects are flattened using dot notation (address.city), arrays are serialised to strings, and values containing commas or quotes are properly escaped per RFC 4180.
Use the JSON to CSV Converter above — enter your values and get instant results. This free online tool calculates how to convert json to csv without any download or signup required. Results update in real time as you type.
Use the JSON to CSV Converter above — enter your values and get instant results. This free online tool calculates json to csv online free without any download or signup required. Results update in real time as you type.
CSV conversion works best with a JSON array of flat objects (array of records with consistent keys). Arrays of arrays (matrix format) also convert cleanly. Deeply nested structures or highly irregular schemas are harder — this tool flattens nested objects using dot notation (user.address.city becomes a column named "user.address.city"). JSON arrays embedded as values are serialised to a string representation. A single JSON object (not an array) is converted as a single-row CSV.
RFC 4180 defines the CSV standard: fields containing commas, double quotes, or newlines must be enclosed in double quotes. Double quote characters within quoted fields must be escaped by doubling them ("" represents a single "). This tool follows RFC 4180 automatically — any field containing special characters is automatically quoted. The 'Quote all fields' option wraps every field in quotes for maximum compatibility with strict CSV parsers.
CSV (Comma-Separated Values) uses commas as field separators. TSV (Tab-Separated Values) uses tab characters. TSV is useful when data frequently contains commas (like addresses, descriptions) because tab characters are rare in text data — avoiding the need for quoting. This tool supports both formats via the delimiter selector. Some European countries use semicolons as CSV delimiters because commas are used as decimal separators in those locales (1.234,56 instead of 1,234.56).
Excel has UTF-8 encoding issues when double-clicking CSV files. Two solutions: 1) Rename file to .txt, open Excel, use Data → From Text/CSV → specify UTF-8 encoding and comma delimiter. 2) Add a BOM (Byte Order Mark) at the start of the file — Excel interprets this as UTF-8. In Python: open(file, 'w', encoding='utf-8-sig'). In the downloaded file from this tool, UTF-8 is used. For data with emojis or non-Latin characters, always specify encoding explicitly when opening in Excel.
Arrays embedded as values in JSON objects are converted to JSON string representation in the CSV cell (e.g., ["tag1","tag2"] becomes the string '["tag1","tag2"]'). This preserves the data without losing information. If you need each array element as a separate row (denormalisation), you would need to preprocess the JSON first — split each record with an embedded array into multiple records, one per array element. This is a data modelling transformation beyond simple format conversion.