Related Tools
How to Use
- 1Paste a JSON array of objects into the input field. The input must be a valid JSON array where each element is an object (e.g., [{"name": "Alice", "age": 30}, {"name": "Bob", "age": 25}]).
- 2Alternatively, click 'Load Example' to populate the input with a sample JSON array demonstrating nested objects, various data types, and edge cases.
- 3Click 'Convert to CSV' to generate the CSV output. Nested objects are automatically flattened using dot notation (e.g., 'address.city'), and all values containing commas or quotes are properly escaped.
- 4Preview the converted data in the table below the output to verify that column headers map correctly to your JSON keys and that values appear as expected.
- 5Copy the CSV text to your clipboard using the Copy button, or click Download to save it as a .csv file that can be opened directly in Excel, Google Sheets, or LibreOffice Calc.
- 6If the output does not look right, check that your input is a valid JSON array of objects — single objects, primitive arrays, or malformed JSON will produce an error message.
About JSON to CSV Converter
The JSON to CSV Converter transforms any JSON array of objects into a valid, RFC 4180-compliant CSV file with proper field escaping and automatic nested object flattening. Each object in the input array becomes a row, and all unique keys across every object are collected to form the complete set of column headers. Nested properties are flattened using dot notation — for example, an object like {"address": {"city": "New York", "zip": "10001"}} produces columns named 'address.city' and 'address.zip' — so even complex API responses with deeply nested structures convert cleanly to tabular format.
JSON (JavaScript Object Notation) is the dominant data interchange format for web APIs, configuration files, and NoSQL databases, while CSV remains the standard for spreadsheet applications, business intelligence tools, and bulk data imports into relational databases. The impedance mismatch between these two formats — JSON's hierarchical structure versus CSV's flat tabular rows — is a daily friction point for developers, data analysts, and anyone who works with data pipelines. This converter bridges that gap instantly without requiring custom scripting.
The converter handles all CSV escaping rules correctly: field values containing commas are wrapped in double quotes, values containing double-quote characters have those quotes escaped by doubling them, and line breaks within values are preserved inside quoted fields. This ensures the output file opens correctly in Excel, Google Sheets, LibreOffice Calc, Apple Numbers, and any other application that reads CSV files. The built-in table preview lets you verify the conversion visually before downloading.
Common use cases include exporting REST API responses for stakeholder review in spreadsheets, converting MongoDB or Elasticsearch query results to CSV for data analysis in Excel or pandas, preparing JSON datasets for import into SQL databases using bulk CSV import tools, and creating human-readable reports from machine-generated JSON logs. The dot-notation flattening is particularly valuable when working with APIs that return nested user profiles, address objects, or metadata structures.
For data engineering workflows, the ability to quickly convert JSON to CSV without writing code saves significant time. Instead of writing Python scripts with the csv and json modules, or installing command-line tools like jq and csvkit, you can paste your JSON data and get a downloadable CSV file in seconds. This is especially useful for one-off conversions, ad-hoc data exploration, and situations where you need to share data with non-technical stakeholders who work exclusively in spreadsheets.
All processing runs entirely in your browser using client-side JavaScript. Your JSON data is never transmitted to any server, making this tool safe for converting sensitive API responses, customer data exports, financial records, and proprietary business data. The conversion happens in memory on your device with no server-side logging, no file uploads, and no third-party data collection.
Frequently Asked Questions
What JSON format is accepted?
The input must be a JSON array of objects: [{...}, {...}]. Each object in the array becomes one row in the CSV output, and all unique keys found across every object become the column headers. Primitive arrays (like [1, 2, 3]) or single objects (not wrapped in an array) are not supported — wrap them in an array first.
How are nested objects handled?
Nested objects are automatically flattened using dot notation. For example, {"address": {"city": "NY", "state": "NY"}} produces two columns: 'address.city' and 'address.state'. This flattening works recursively for multiple levels of nesting, so deeply nested API responses are fully expanded into flat columns. Arrays within objects are serialized as JSON strings in the cell value.
Can I open the CSV in Excel or Google Sheets?
Yes. The downloaded .csv file is fully compatible with Microsoft Excel, Google Sheets, LibreOffice Calc, Apple Numbers, and any other application that supports CSV import. The file uses UTF-8 encoding and follows RFC 4180 escaping rules, which all major spreadsheet applications understand. If you see encoding issues with special characters in Excel, try using the 'Import Data' function instead of double-clicking the file.
Is my data sent to a server?
No. All conversion happens entirely in your browser using client-side JavaScript. Your JSON data never leaves your device, no network requests are made during conversion, and there is no server-side processing or logging. You can verify this by monitoring the Network tab in your browser's developer tools while performing a conversion.
What happens if objects have different keys?
The converter collects all unique keys across every object in the array to build the complete set of CSV columns. If an object is missing a key that other objects have, the corresponding cell in that row will be empty. This union-based approach ensures no data is lost, even when working with heterogeneous JSON arrays where different records have different fields.
How does the converter handle special characters in values?
Values containing commas, double quotes, or line breaks are automatically wrapped in double quotes per the CSV standard. Double-quote characters within values are escaped by doubling them (e.g., a value containing 'say "hello"' becomes '"say ""hello"""' in the CSV). This ensures the output file parses correctly in any standard-compliant CSV reader.
Can I use this to export data for SQL database import?
Yes. Many relational databases support CSV bulk import through tools like MySQL's LOAD DATA INFILE, PostgreSQL's COPY command, or SQL Server's BULK INSERT. Convert your JSON data to CSV here, download the file, and use your database's import utility. Make sure the column headers in the CSV match your database table's column names for a smooth import.
What is the maximum file size I can convert?
There is no hard-coded file size limit. The converter runs in your browser's memory, so the practical limit depends on your device's available RAM. JSON arrays with up to 10,000-20,000 objects typically convert instantly. Larger datasets with 50,000+ objects may take a few seconds. For very large JSON files exceeding several hundred megabytes, consider using command-line tools like jq combined with csvkit for streaming conversion.