Mentigo Icon
MentigoInstrument deck
deck Data & Code Utilities JSON ⇄ CSV Converter
Back to deck
Data & Code Utilities

JSON ⇄ CSV Converter

Turn JSON arrays into spreadsheet-ready CSV files or parse CSV exports back into structured JSON, with delimiter options and type detection.

Runs privately in your browser — your input is never uploaded or tracked.

JSON to CSV Converter (and CSV to JSON) Online

Convert JSON arrays to CSV spreadsheets or turn CSV exports back into structured JSON with this free online converter. It is the fastest way to move data between APIs and Excel or Google Sheets — paste JSON and download a spreadsheet-ready CSV, or paste CSV and get clean JSON records, all processed privately in your browser.

The converter handles the tricky parts automatically: nested objects are flattened into columns, delimiters (comma, semicolon, tab) are configurable, quoted fields with embedded commas are parsed correctly, and numbers and booleans are type-detected when converting CSV back to JSON.

How to Convert JSON to CSV (or CSV to JSON)

  1. Paste your data

    Drop a JSON array of objects, or raw CSV text (with or without a header row), into the input.

  2. Pick your options

    Choose the delimiter and header behavior; nested JSON fields are flattened into dot-notation columns automatically.

  3. Convert instantly

    The output appears immediately — CSV rows from your JSON, or JSON records from your CSV.

  4. Copy or download

    Copy the result to your clipboard or save it as a file ready for Excel, Google Sheets, or your codebase.

Why Use This JSON ⇄ CSV Converter?

  • Two-way conversion

    JSON to CSV for spreadsheets and reports; CSV to JSON for APIs, seeds, and fixtures — one tool.

  • Nested object flattening

    Nested JSON keys become readable column names, so complex API data fits a flat spreadsheet.

  • Delimiter options

    Comma, semicolon, or tab — match regional Excel conventions and TSV pipelines.

  • Type detection

    When parsing CSV, numbers and booleans are recognized so your JSON has real types, not just strings.

  • Private, browser-only processing

    Customer data and exports never leave your machine — no upload, no retention.

Frequently Asked Questions

How do I open JSON data in Excel?

Convert the JSON array to CSV with this tool, download or copy the result, and open it in Excel or import it into Google Sheets. Each object becomes one row and each key becomes a column.

What JSON structure converts best to CSV?

An array of flat objects with consistent keys converts perfectly. Nested objects are flattened into dot-notation columns; deeply irregular structures may need cleanup first.

How are commas inside values handled?

Fields containing commas, quotes, or newlines are wrapped in double quotes per the CSV standard (RFC 4180), so spreadsheets parse them correctly.

Can I convert CSV with a semicolon delimiter?

Yes — choose the semicolon delimiter option, which is common for European locales where Excel exports use ; instead of ,.

Does the converter preserve column order?

Yes. Columns follow the key order of your first JSON object, and CSV headers map to JSON keys in their original order.