Free JSON to CSV Converter

Turn a JSON array of objects into a spreadsheet-ready CSV in seconds. This free converter builds the header row from all keys, quotes fields correctly (commas, quotes, and line breaks inside values are handled), and lets you pick the delimiter — ready to open in Excel or Google Sheets.

CSV output


    

    

  



  
Private by design. This tool runs 100% in your browser — your code is never uploaded to any server.

  

    
How to Use the JSON to CSV

    
    
      
  1. Paste a JSON array of objects (e.g. [{"name":"Ada"}]).
    2. 
      
  2. Choose your delimiter and whether to include a header row.
    3. 
      
  3. Click Convert to CSV to generate the spreadsheet data.
    4. 
      
  4. Copy it or download the .csv file and open it in Excel.
    5. 
    

  

  

    
Features

    
The converter collects the union of all keys across objects so ragged data still aligns into correct columns, with missing values left empty. Fields containing delimiters, quotes, or newlines are wrapped in quotes per RFC 4180 and internal quotes are doubled — so Excel and Sheets parse the file exactly. Nested objects are serialized as compact JSON strings rather than dropped.

    
Benefits & Use Cases

    
Developers hand API data to non-technical colleagues as spreadsheets; analysts reshape JSON exports for pivot tables; support teams convert ticket dumps for reporting. Proper quoting means the CSV actually opens correctly instead of exploding into misaligned columns.

    
Tips

    
If Excel mangles accented characters, it is an encoding issue on import — use Data → From Text/CSV and choose UTF-8. For European locales, pick the semicolon delimiter to match local Excel defaults.

  

  

    
Frequently Asked Questions

    
What JSON structure converts best to CSV?
An array of flat objects with consistent keys, like [{"name":"Ada","age":36}]. Each object becomes a row; each key becomes a column. Nested objects are stringified into their cells.

    
How are commas inside values handled?
Per CSV rules, any field containing the delimiter, a quote, or a line break is wrapped in double quotes, and embedded quotes are doubled. Spreadsheet apps then parse it back into a single cell.

    
Can I convert CSV back to JSON?
Yes — the companion CSV to JSON tool on this site performs the reverse conversion with the same quoting rules.

    
Which delimiter should I choose?
Comma is the universal default. Use semicolon if your audience uses European Excel, where the comma is the decimal separator and semicolon is the list separator.

    
Is my JSON uploaded anywhere?
No. Conversion runs entirely in your browser — your data never leaves your device.

  

  

    
Related Tools

    

      
CSV to JSON
Convert CSV to JSON instantly with NToolHub’s free converter. Handles quoted fields, custom delimiters, header detection — 100% private.
Open tool →
      
JSON Formatter
Format and beautify JSON instantly with NToolHub’s free formatter. Syntax validation, error location, stats — private in-browser tool.
Open tool →
      
YAML to JSON
Convert YAML to JSON instantly with NToolHub’s free tool. Handles mappings, sequences, nested structures — private in-browser.
Open tool →
      
XML to JSON
Convert XML to JSON instantly with NToolHub’s free tool. Attributes, repeated elements, CDATA handled — private in-browser conversion.
Open tool →
      
JSON Validator
Validate JSON syntax instantly with NToolHub’s free validator. Clear verdicts, exact error positions, structure stats — 100% private.
Open tool →