Free Online JSON to CSV Converter

This converter accepts a JSON array of objects, where each object represents a row and each key becomes a column header. For example: [{"name": "Alice", "age": 30}, {"name": "Bob", "age": 25}]. The objects do not need to have identical keys — missing values are left as empty cells in the CSV output.

Nested objects are flattened using dot notation. For example, if an object contains {"address": {"city": "NYC", "zip": "10001"}}, the CSV will have columns named 'address.city' and 'address.zip'. Arrays within objects are converted to comma-separated strings enclosed in quotes.

This tool focuses on JSON-to-CSV conversion. For the reverse direction (CSV to JSON), you can use a dedicated CSV to JSON converter. The two formats have different strengths: JSON handles nested and hierarchical data well, while CSV is ideal for flat, tabular data.

You can choose from comma (standard CSV), tab (TSV format, great for pasting into spreadsheets), semicolon (common in European locales where commas are decimal separators), or pipe. The default delimiter is a comma, which is compatible with virtually all spreadsheet applications.

Download the CSV file using the download button, then double-click it to open in Excel. If columns do not separate properly, use Excel's Data > From Text/CSV import wizard and specify the correct delimiter. For non-English locales, you may need to use semicolon as the delimiter instead of comma.

Since all processing happens in your browser, the practical limit depends on your device's available memory. Most modern browsers can handle JSON files up to 50–100 MB without issues. For very large datasets, consider using a command-line tool or programming library instead.

CSV is a plain-text format and does not have native data types. Numbers, booleans, and null values are converted to their string representations. Dates remain as-is in whatever format they appear in the JSON. Spreadsheet applications may auto-detect and convert certain formats when importing.

Values containing commas, double quotes, or newlines are automatically enclosed in double quotes per the RFC 4180 CSV standard. Double quotes within values are escaped by doubling them (e.g., a value containing 'say "hello"' becomes '"say ""hello"""'). This ensures compatibility with all standard CSV parsers.