JSON to CSV
Convert JSON arrays and nested objects to clean, RFC 4180 compliant CSV or TSV files in your browser.
Convert JSON to CSV Online in Seconds
Need to export REST API results, database query dumps, or web scrape records into Microsoft Excel or Google Sheets? The JSON to CSV Converter translates complex JSON arrays and objects into clean, RFC 4180 compliant comma-separated values.
Unlike online converters that send your data to external servers, ToolShed performs all parsing, flattening, and formatting locally on your machine. Your proprietary payloads, customer emails, PII, and financial metrics stay completely private.
Key Capabilities
Automatic Nested Object Flattening
Deeply nested JSON properties like user.profile.bio are automatically unfolded into intuitive dot-notation spreadsheet columns.
RFC 4180 Standard Quoting
Cells containing commas, double quotes, or embedded newlines are properly escaped and quoted according to the international RFC 4180 CSV standard.
Multi-Delimiter & TSV Support
Switch seamlessly between standard Comma (,), European Semicolon (;), Tab (\\t) for direct copy-paste into Google Sheets, or Pipe (|).
Union of Diverse Keys
If items in your JSON array contain varying schemas, the tool generates a unified header set containing every encountered field with missing values filled cleanly.
Related Data & JSON Tools
Explore companion utilities in the ToolShed workspace:
Frequently Asked Questions
- How do I convert a JSON file or API response to CSV?
- Paste your JSON array or object into the input box (or click "Upload JSON" to pick a .json file). The tool instantly converts the data into RFC 4180 compliant CSV format ready to copy or download into Excel, Google Sheets, or Apple Numbers.
- How does it handle nested JSON objects and arrays?
- With "Flatten nested objects" enabled (default), nested properties are automatically flattened into dot-notation column headers (for example, {"address": {"city": "New York"}} becomes an "address.city" column). If disabled, nested objects are serialized as JSON strings in the cell.
- Can I choose different delimiters like Tab (TSV) or Semicolon?
- Yes. Use the Delimiter dropdown to choose between Comma (,), Semicolon (;) for European locales, Tab (\t) for TSV spreadsheets, or Pipe (|).
- What if some objects in the array have different keys?
- The converter inspects all objects in your JSON array and collects every unique property key as a column header. Rows missing specific keys are safely assigned blank cells.
- Is my JSON uploaded to any server or database?
- No. ToolShed processes all transformations 100% client-side inside your browser using standard JavaScript. Your private API keys, customer lists, financial data, and personal records never leave your device.