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

JSON to CSV Converter Online

Convert JSON arrays to CSV format in one click. Nested objects are automatically flattened with dot-notation keys. Download the result and import it into Excel, Google Sheets, or any database. No upload required. If you are starting from a spreadsheet instead, use CSV to JSON and move results back here when you need CSV again.

Where Is This Useful?

Excel & Google Sheets
Export API data as a spreadsheet for reporting, pivoting, or sharing. Normalize messy payloads first with the JSON Formatter or JSON Cleaner.
Database Import
Bulk-import into PostgreSQL, MySQL, or other SQL stores using COPY/LOAD. When analysts return CSV edits, turn rows back into JSON with CSV → JSON.
Data Pipelines
Feed API responses into ETL, lakes, or BI tools that expect flat columns. Deep nesting? Flatten keys with JSON Flatten, then export here.
CSV → JSON
Round-trip in the browser: export JSON as CSV here, edit in Sheets, then paste the sheet into CSV → JSON to recover an array of objects. Compare versions with JSON Diff when needed.

How to Use

  1. Paste a JSON array of objects into the left panel
  2. Click Convert to CSV or press Ctrl+Enter
  3. Copy the CSV or click ↓ to download as .csv

Example

Input JSON
[
  { "name": "Alice", "age": 30 },
  { "name": "Bob",   "age": 25 }
]
CSV Output
name,age
Alice,30
Bob,25

Features

  • Automatic header detection from all object keys
  • Nested object flattening (address.city becomes a column)
  • Partner page CSV to JSON for the reverse direction and round-trip edits
  • Proper CSV escaping for commas, quotes, and newlines
  • One-click .csv file download
  • Shows row and column counts after conversion
  • 100% private; runs entirely in your browser

Frequently Asked Questions

Does the JSON need to be an array?

Yes. The converter expects a JSON array of objects, where each object becomes a CSV row. Each unique key across all objects becomes a column header.

What happens to nested objects?

Nested objects are flattened using dot notation. For example, {"address": {"city": "London"}} becomes a column called address.city.

Can I open the CSV in Excel?

Yes. Download the .csv file and open it directly in Excel, Google Sheets, LibreOffice Calc, or import it into any database.

I have CSV and need JSON again? Where do I go?

Open the CSV to JSON tool. Paste your CSV (including headers); you get a JSON array of objects you can format, validate, or pipe back into APIs. Use it together with this page when you edit data as a spreadsheet and then need structured JSON.

Related Tools