T

JSON to CSV

Online JSON to CSV Converter

JSON to CSV Description

Convert JSON arrays to CSV format easily for use in spreadsheet applications like Excel or Google Sheets. Supports custom delimiters, field selection, and interactive table preview.

How to use

  1. Paste your JSON array into the input field or click 'Demo' to see an example.
  2. The tool will automatically extract available fields. You can selectively toggle fields in the settings.
  3. Choose your preferred CSV delimiter (comma, semicolon, tab, etc.).
  4. Toggle between 'Text View' and 'Table View' to inspect the results.
  5. Download the CSV file or copy the text to your clipboard.

Common Scenarios

  • Exporting data from an API (JSON) into Excel or Google Sheets (CSV).
  • Converting database exports for easier analysis in spreadsheet software.
  • Migrating data between different systems that prefer flat file formats.

Data Structure

  • Input: An array of objects [{ "key": "value" }, ...].
  • Output: A delimited values string (CSV) where the first line contains keys.

Principles

The tool flattens the JSON structure. It identifies all unique keys across the objects to form columns and then maps each object's values to the corresponding column index. It handles nested objects by flattening them with dot notation.