JSON to CSV Converter

Convert JSON arrays of objects or JSONLines into CSV for Excel. Paste, upload, or fetch from URL — download or copy instantly.

JSON Input
Array Path (optional: e.g. data.items)
Settings
Delimiter
Quote Char
Options
XML to CSV CSV to XML JSON Editor URL Encoder

JSON to CSV Converter — How It Works

This tool converts JSON data (arrays of objects or JSONLines format) into CSV, which can be directly opened in Microsoft Excel, Google Sheets, or any spreadsheet application without additional parsing.

Supported JSON Formats

// Array of objects (standard) [{"name":"Alice","age":30},{"name":"Bob","age":25}] // JSONLines — one JSON object per line {"name":"Alice","age":30} {"name":"Bob","age":25}

Array Path

If your JSON nests the array inside keys, use Array Path to target it. Example: use data.users for {"data":{"users":[...]}}. Supports dot notation and array indices like results[0].rows.

Options Explained

  • Header row: Adds column names from JSON keys as first CSV line — required for Excel column recognition.
  • Force quotes: Wraps every field in quotes — useful when values might contain commas or special characters.
  • Remove line breaks: Strips newlines from values to prevent multi-line CSV cells in Excel.
  • Custom delimiter: Change comma to tab, semicolon, or pipe for different regional CSV formats (e.g. semicolon for European Excel).

FAQ

Can I convert nested JSON to CSV?

Use Array Path to target the nested array. Object values within each row are converted to strings. For complex nested structures, consider flattening the JSON first using the JSON Editor tool.

What is JSONLines format?

JSONLines (NDJSON) is a format where each line is a valid JSON object — no wrapping array brackets needed. Many data export tools, log files, and streaming APIs use this format. This converter detects and handles it automatically.

Why use semicolon instead of comma?

In countries where comma is used as the decimal separator (Germany, France, most of Europe), Excel uses semicolon as the default CSV delimiter. Set ";" in the Delimiter field for files destined for European Excel installations.