JSON to CSV Converter
Convert JSON arrays to CSV format and back. Auto-detect columns, flatten nested objects, preview as a table, and download as a .csv file.
About JSON to CSV Converter
The JSON to CSV Converter is a free browser-based tool that lets you convert between JSON and CSV formats instantly. It handles the common task of transforming structured JSON data into a flat tabular format suitable for spreadsheets, databases, and data analysis tools.
JSON to CSV Conversion
Paste a JSON array of objects and the converter automatically detects all column headers from the object keys. Nested objects are flattened using dot notation, so a key like "address.city" appears as its own column. The output can use commas, tabs, or semicolons as delimiters, depending on your needs.
CSV to JSON Conversion
The reverse direction is just as simple. Paste CSV content with a header row and click "CSV to JSON" to get a clean JSON array where each row becomes an object. The tool respects quoted fields that contain delimiters or newlines, so standard CSV files are parsed correctly.
Preview and Export
Before copying or downloading, you can preview your converted data in a table view to verify the output looks correct. The download button saves the result as a .csv file that opens directly in Excel, Google Sheets, or any spreadsheet application. You can also copy the output to your clipboard with a single click.
All processing runs entirely in your browser with no data sent to any server. This makes the tool safe for converting files that contain API keys, user data, or any other sensitive information.
Frequently Asked Questions
What JSON structure does this converter expect?
The converter expects a JSON array of objects, where each object represents a row. The keys of the objects become CSV column headers. For example, [{"name":"Alice","age":30},{"name":"Bob","age":25}] produces a CSV with "name" and "age" columns. If different objects have different keys, all keys are collected and missing values appear as empty cells.
How does the converter handle nested objects?
Nested objects are flattened using dot notation. For example, if an object contains {"address":{"city":"NYC","zip":"10001"}}, the converter creates columns named "address.city" and "address.zip" with their respective values. Arrays within objects are converted to their JSON string representation.
Can I change the delimiter from commas to something else?
Yes. The tool supports three common delimiters - commas, tabs, and semicolons. Select your preferred delimiter before converting. Tab-delimited output is useful for pasting directly into spreadsheet applications, while semicolons are common in regions where commas are used as decimal separators.
Can I convert CSV back to JSON?
Yes. The tool is fully bidirectional. Paste CSV content into the CSV pane and click "CSV to JSON" to get a JSON array of objects. The first row of the CSV is treated as column headers, and each subsequent row becomes an object with those headers as keys.
Is my data sent to a server?
No. All conversion happens entirely in your browser using JavaScript. Your data never leaves your machine, so it is safe to convert files that contain sensitive or proprietary information.