JSON to CSV Converter
Convert JSON arrays to CSV format for spreadsheet import and data analysis.
What Is a JSON to CSV Converter?
JSON (JavaScript Object Notation) is a widely used data format for APIs, databases, and configuration files. While JSON is great for nested, hierarchical data, spreadsheets and data analysis tools like Excel, Google Sheets, or Pandas work best with flat, tabular CSV (Comma-Separated Values) format. This tool bridges that gap — paste any JSON array of objects and instantly get a clean, properly-formatted CSV file ready for import.
The converter automatically detects all unique keys across every object in your array and uses them as column headers. Fields containing commas, quotes, or newlines are properly escaped according to RFC 4180 standards, ensuring your CSV is compatible with all major spreadsheet applications.
How to Use This Tool
- Paste your JSON — Input a valid JSON array of objects into the text area. Use the sample buttons to try example data.
- Configure options — Choose your delimiter (comma, semicolon, tab, or pipe), quoting style, and whether to include headers or flatten nested objects.
- Click Convert — The tool auto-detects all keys, builds headers, and generates a properly escaped CSV string.
- Preview & Download — Inspect the preview table to verify the output, then download as a
.csvfile or copy it to your clipboard.
Common Use Cases
- 📊 Data Analysis: Export API responses or database query results to Excel or Google Sheets for pivot tables and charts.
- 🔗 CRM Import: Convert customer or contact JSON data to CSV for bulk import into Salesforce, HubSpot, or Mailchimp.
- 🧪 Testing & QA: Convert test fixture JSON into CSV for reporting or comparison tools.
- 📦 E-commerce: Prepare product catalog JSON for upload to Shopify, WooCommerce, or Amazon Seller Central.
- 📈 Business Intelligence: Feed structured JSON data into BI tools like Tableau, Power BI, or Looker.
Frequently Asked Questions
What JSON format does this tool accept?
The tool accepts a JSON array of objects — for example, [{"key":"value"}, ...]. Each object in the array becomes a row in the CSV. If you have a single JSON object (not an array), wrap it in square brackets first: [{...}]. The tool does not currently support deeply nested arrays as cell values (those are serialized as strings).
How are commas and quotes inside values handled?
The converter follows RFC 4180 CSV standards. Any field containing a comma, double-quote, or newline character is automatically wrapped in double quotes. Double-quote characters inside a field are escaped by doubling them (""). When "Quote All Fields" mode is selected, every field gets quoted regardless of content.
What happens if objects in my array have different keys?
The converter scans all objects to build a complete, unified set of column headers. If a particular object is missing a key that other objects have, the corresponding cell will be left empty (or filled with an empty string if that option is enabled). This ensures a consistent rectangular table even with heterogeneous JSON.
What does "Flatten nested objects" do?
When enabled, nested objects like {"address": {"city": "NYC", "zip": "10001"}} are flattened into dot-notation columns: address.city and address.zip. This is useful when your JSON has one level of nesting you want spread across multiple CSV columns instead of being serialized as a JSON string.
Can I use a semicolon or tab as a delimiter?
Yes. The tool supports comma (,), semicolon (;), tab (\t), and pipe (|) as delimiters. Semicolon-delimited files are common in European locales where commas are used as decimal separators. Tab-separated values (TSV) are widely compatible with Excel and many programming tools.
Is my data sent to any server?
No. All conversion happens entirely in your browser using JavaScript. Your JSON data never leaves your device and is never sent to any server. This makes the tool safe to use with sensitive or proprietary data.