renderlog.in ↗

JSON → CSV

FreePrivateNested flattening

Convert a JSON array of objects to CSV. Nested objects use dot-notation column names.

Need the other direction? CSV → JSON

JSON input (array of objects)
CSV output
Ctrl+Enter Convert

Convert JSON to Excel (CSV) Online

Paste a JSON array of objects and export it as a CSV file ready to open in Excel, Google Sheets, or LibreOffice Calc. Nested objects are flattened automatically using dot-notation column names. Download the result with one click: no account, no upload, no server. To go the other direction, use CSV to JSON to turn a spreadsheet back into structured data.

JSON Input vs. CSV / Excel Output

Input JSON
[
  {
    "name": "Alice",
    "age": 30,
    "address": {
      "city": "London",
      "zip": "EC1A"
    }
  },
  {
    "name": "Bob",
    "age": 25,
    "address": {
      "city": "Berlin",
      "zip": "10115"
    }
  }
]
CSV Output (opens in Excel)
name,age,address.city,address.zip
Alice,30,London,EC1A
Bob,25,Berlin,10115

How to Use

  1. Paste a JSON array of objects into the left editor panel
  2. Click Convert to CSV or press Ctrl+Enter
  3. Copy the CSV output or click the download button to save a .csv file
  4. Open the file in Excel, Google Sheets, or import it into your database

Features

  • Automatic column headers detected from all unique keys across every row
  • Nested object flattening: address.city and address.zip become separate columns
  • Proper CSV escaping for values containing commas, quotes, or newlines
  • One-click .csv file download ready for Excel or Google Sheets
  • Reverse direction available: CSV to JSON for round-trip editing
  • Shows row and column counts after conversion
  • 100% private: runs entirely in your browser, nothing is uploaded

Frequently Asked Questions

Can I open the output directly in Excel?

Yes. Click the download button to save a .csv file, then open it in Excel, Google Sheets, LibreOffice Calc, or any spreadsheet application. Excel recognises CSV files natively and displays each field in a separate column.

How does it handle nested JSON?

Nested objects are flattened with dot-notation keys. For example, {"address": {"city": "London"}} becomes a column called address.city. This keeps the CSV flat so every spreadsheet tool can read it without extra configuration.

What if my JSON has arrays of objects?

The converter expects a top-level JSON array of objects, where each object maps to one row and each unique key becomes a column. If your JSON is wrapped in an outer object, extract the array first using the JSON Flatten or JSON Formatter tools, then paste it here.

Related Tools