JSON to CSV Converter
JSON to CSV conversion flattens nested JSON objects into tabular format. Each JSON object becomes a CSV row, keys become column headers. Nested objects flatten with dot notation: {"user": {"name": "John"}} becomes user.name column. Arrays typically repeat parent row or join with delimiter. For example, [{"id":1,"name":"John"},{"id":2,"name":"Jane"}] converts to CSV with headers "id,name" and rows "1,John" and "2,Jane". Useful for Excel import, database bulk loads, and data analysis.
Convert JSON to CSV and CSV to JSON online. Bidirectional converter with configurable delimiters, nested object flattening, preview table, and download. Handles arrays, null values, and dot notation.
Works OfflineDark ModeNo Ads
Options
JSON Input
CSV Output
How to Use
- Enter your value in the input field
- Click the Calculate/Convert button
- Copy the result to your clipboard
Frequently Asked Questions
- How do I convert JSON to CSV?
- Paste a JSON array of objects into the input field and the converter will automatically produce CSV output. Each object becomes a row, and each unique key becomes a column header. You can configure the delimiter (comma, semicolon, tab, or pipe) and choose whether to include headers or flatten nested objects.
- Can I convert CSV back to JSON?
- Yes. Switch to the "CSV → JSON" tab, paste your CSV data, and the converter will produce a JSON array of objects. The first row is used as column headers and each subsequent row becomes a JSON object. Dot-notation headers like "address.city" are unflattened into nested objects automatically.
- How does the converter handle nested JSON objects?
- When "Flatten Nested Objects" is enabled, nested objects are converted to dot-notation keys. For example, {"address": {"city": "NY"}} becomes a column header "address.city" with value "NY". This is the most common approach for converting hierarchical JSON to flat CSV rows.
- What happens with null values and arrays in JSON?
- Null values are converted to empty CSV fields. Arrays within values are joined with commas and wrapped in quotes. For example, ["admin", "editor"] becomes "admin,editor" in the CSV output. When converting back from CSV, empty fields become null in JSON.
- What delimiters are supported?
- The converter supports four delimiter options: comma (,) which is the standard CSV separator, semicolon (;) which is common in European locales, tab for TSV (tab-separated values) files, and pipe (|) for pipe-delimited formats. Choose the delimiter that matches your target system.
- Is there a size limit for conversion?
- The conversion runs entirely in your browser, so there are no server-side upload limits. Performance depends on your device, but typical JSON files up to several megabytes convert instantly. The preview table shows the first 10 rows so you can verify the output before downloading.