JSON to CSV converter

    Turn a JSON array into a CSV table for Excel or Sheets.

    Your text stays on this device

    About the JSON to CSV tool

    This JSON to CSV converter turns a JSON array into a CSV table that opens in Excel, Google Sheets or LibreOffice. Each object becomes a row, every key found in any object becomes a column, and nested objects are flattened into dot columns such as user.name or tags.0. Choose a comma, semicolon, tab or pipe delimiter and download data.csv; the Excel-friendly option adds a UTF-8 marker so Hindi names and the ₹ sign display correctly.

    At a glance

    Input
    JSON array, or an object holding one array; .json files up to 20 MB
    Output
    data.csv (data.tsv with tabs), optional UTF-8 marker for Excel
    Delimiters
    Comma, semicolon, tab or pipe
    Nested data
    Flattened to dot columns such as user.name and tags.0
    Price
    Free, no sign-up
    Works in
    Your browser, on phone or computer. Works offline after the first visit.
    Privacy
    What you type never leaves your device.

    How to convert JSON to CSV

    1. Paste your JSON array, or press "Open file" to load a .json file.
    2. Pick the delimiter and whether to include a header row.
    3. Copy the CSV or press Download to save data.csv.

    Private

    Your text stays in your browser and is never sent to a server.

    Instant

    Results update as you type, with nothing to install.

    Free

    No sign-up, no limits and no ads inside your writing space.

    JSON to CSV: frequently asked questions

    How are nested JSON objects converted to CSV columns?

    They are flattened with dot notation. For example {"user":{"name":"Asha"},"tags":["a","b"]} becomes the columns user.name, tags.0 and tags.1, so no value is lost.

    What if my objects have different keys?

    Every key that appears in any object becomes a column, in the order it is first seen. Rows that do not have a key get an empty cell.

    Why does Excel show Hindi or ₹ as strange characters?

    Older Excel versions guess the wrong encoding for CSV files. Tick "Excel-friendly download" to add a UTF-8 byte order mark, and Excel will show Hindi, ₹ and emoji correctly.

    My JSON is an object like {"data":[…]}. Does that work?

    Yes. If the top-level object has a single key holding an array, that array is used as the rows. Any other single object becomes one row.

    Is my text sent anywhere?

    No. Everything runs in your browser and your text never leaves your device. Nothing is stored on any server.