JSON to CSV Converter

Convert a JSON array of objects into a CSV table. Handles quoting, escaping, and rows with mixed keys. Runs entirely in your browser.

Loading tool...

This tool takes a JSON array of objects and converts it into a clean CSV table you can open in Excel, Google Sheets, or any spreadsheet program. The conversion happens entirely in your browser — paste internal or sensitive data freely; nothing leaves your machine.

How to convert JSON to CSV

  1. Paste your JSON into the input box on the left. The top level must be an array (e.g. [{"name":"Ada","role":"Engineer"}, ...]).

  2. Hit Convert to CSV. The CSV output appears on the right with a one-click Copy button.

  3. Need to go the other way? Use the CSV → JSON tool instead.

What this converter handles

  • Mixed keys — if some objects in your array have different fields, the CSV header is the union of every key found, in first-seen order.

  • Quoting — cells that contain commas, quotes, or newlines are wrapped in double quotes; internal quotes are doubled per RFC 4180.

  • Nested values — arrays and nested objects inside cells are stringified to JSON so you keep the data in the export.

  • Empty / null values — emitted as empty cells so they import cleanly into spreadsheets.

When to use it

Typical use cases: importing a JSON API response into Excel or Google Sheets, prepping a CSV upload for a third-party service that doesn't accept JSON, generating a quick report from a database query, or just sanity-checking the shape of a response without writing throwaway code.