JSON to CSV Converter

Convert between JSON and CSV instantly. Handles nested objects, custom delimiters. Runs in your browser.

About This Tool

This converter handles both directions: JSON to CSV and CSV to JSON. When converting JSON to CSV, nested objects are flattened using dot notation. For example, {"user": {"name": "Alice"}} becomes the column user.name. Arrays are serialized as JSON strings.

For CSV to JSON, you can choose your delimiter (comma, semicolon, or tab) and specify whether the first row contains headers. Without headers, columns are named column_1, column_2, etc.

Everything runs entirely in your browser. No data is sent to any server, stored, or logged.

Frequently Asked Questions

How to Use the JSON to CSV Converter

Paste a JSON array of objects into the input area or upload a .json file. Click Convert and the tool will flatten any nested properties using dot notation (for example, address.city) and produce a clean CSV output. You can preview the result in a table, copy it to your clipboard, or download the .csv file directly.

To convert CSV back to JSON, switch to the CSV to JSON tab. Paste your CSV data or upload a .csv file, select your delimiter (comma, semicolon, or tab), and click Convert. The tool parses each row into a JSON object using the header row as keys.

Why Convert Between JSON and CSV

JSON is the standard data format for APIs, web applications, and configuration files, while CSV remains the most widely supported format for spreadsheets, databases, and data analysis tools. Converting between the two is one of the most common tasks in data workflows.

Many teams export data from REST APIs in JSON format but need to open it in Excel, Google Sheets, or import it into a SQL database. This tool handles the conversion instantly without uploading your data to any server.

Common Use Cases

  • Developers converting API responses to spreadsheet-friendly CSV
  • Data analysts preparing JSON datasets for Excel or Google Sheets
  • QA engineers converting test data between formats
  • Product managers exporting analytics data for reporting
  • Database administrators converting CSV exports to JSON for API imports
Pro Tip

Nested JSON objects are automatically flattened using dot notation. For example, {"address":{"city":"Paris"}} becomes the column address.city. Need to encode data for URLs? Try our URL Encoder.