Convert between JSON and CSV formats instantly. No data leaves your browser.
Paste a JSON array of objects.
Converted output will appear here.
Paste data on the left to see the result here.
Privacy note
JSON (JavaScript Object Notation) and CSV (Comma-Separated Values) are two of the most widely used data formats in software development, data analysis, and business operations. JSON stores data as structured key-value pairs with support for nested objects and arrays, making it ideal for APIs, configuration files, and complex data structures. CSV stores data in a flat, tabular format where each row represents a record and columns are separated by a delimiter.
Each format has strengths that make it better suited for different tasks. JSON preserves data hierarchy and types, while CSV is universally compatible with spreadsheet applications like Excel, Google Sheets, and LibreOffice Calc. Converting between the two is a common requirement when moving data between systems, importing API data into spreadsheets, or preparing data for analysis tools.
Use JSON when your data has nested structures, mixed data types, or when you need to preserve the relationship between parent and child objects. API responses, configuration files, and NoSQL database exports are typically in JSON format because they often contain deeply nested data that a flat CSV cannot represent without transformation.
Use CSV when you need to import data into spreadsheets, load data into SQL databases, share tabular data with non-technical users, or when your data is inherently flat with consistent columns across all rows. CSV files are also significantly smaller than their JSON equivalents for the same data, since they do not repeat key names on every row. Most business intelligence tools, data analysis platforms, and reporting systems accept CSV as a standard import format.
When converting JSON to CSV, nested objects are flattened using dot notation. For example, an address object with city and state fields becomes address.city and address.state as separate CSV columns. Arrays within JSON objects are converted to their string representation, since CSV cells cannot contain structured data.
When converting CSV to JSON, every value is treated as a string by default since CSV does not carry type information. If you need numeric or boolean types in your JSON output, you may need to post-process the result. Always verify your delimiter setting matches the actual delimiter used in your CSV file. European systems often use semicolons instead of commas because commas are used as decimal separators in many locales.
For maximum compatibility with Microsoft Excel, use comma as the delimiter and ensure your CSV output includes a header row. Excel can also open tab-delimited files, which avoid issues with data values that contain commas. Google Sheets handles comma-separated CSV natively through its import feature.
When your data contains special characters like commas, newlines, or quotation marks within field values, proper CSV escaping is critical. This tool automatically wraps such values in double quotes and escapes any existing double quotes by doubling them, following the RFC 4180 standard. This ensures that spreadsheet applications interpret your data correctly without splitting fields at the wrong position or creating extra rows.
Paste your JSON array of objects into the input field on the left side. The tool automatically parses the JSON, extracts all unique keys as column headers, and generates properly escaped CSV output. You can then copy the CSV to your clipboard or download it as a .csv file. The conversion happens instantly in your browser.
Nested objects are flattened using dot notation. For example, if your JSON contains an address object with a city field, the CSV header becomes address.city. This preserves the hierarchy information in a flat format that spreadsheets can display as regular columns.
The tool supports four common delimiters: comma (the CSV standard), semicolon (common in European locales), tab (for TSV files), and pipe. Select your preferred delimiter using the toggle buttons above the input area. The same delimiter setting applies to both JSON-to-CSV and CSV-to-JSON conversions.
Yes. Switch to CSV to JSON mode using the toggle at the top. Paste your CSV text with a header row, and the tool generates a formatted JSON array where each row becomes an object with keys matching the CSV column headers. You can download the result as a .json file or copy it to your clipboard.
No. All conversion processing runs entirely in your browser using JavaScript. Your data never leaves your device and is not sent to any server, logged, or stored. You can safely use this tool with sensitive or proprietary datasets.
