JSON to CSV Converter
Convert a JSON array of objects to CSV format instantly in your browser.
Most REST APIs return data as JSON arrays of objects, but the tools used to analyse, share, or import that data β spreadsheets, BI dashboards, ETL pipelines β expect CSV. Manually extracting columns is tedious and error-prone, especially when the array has dozens of keys or inconsistently present optional fields.
This converter accepts a JSON array, detects all unique keys across every object, and emits a correctly quoted CSV with a header row. It handles missing values gracefully, fills nested objects as JSON strings rather than silently dropping them, and gives you a file you can drag straight into Excel, Google Sheets, or your data pipeline. Useful for API prototyping, report generation, and one-off data migrations.
How to Convert JSON to CSV Online
- 1
Paste Your JSON Array
Paste a JSON array of objects. The tool validates the input and shows a clear error if the format is not a JSON array.
- 2
Review the Column Headers
Array keys become CSV column headers. Nested objects are flattened with dot-notation keys. A warning is shown when flattening occurs.
- 3
Copy or Download the CSV
Copy the CSV output or download it as a .csv file ready for use in Excel, Google Sheets, or any data tool.
How JSON-to-CSV Conversion Works
The converter first validates that the input is a JSON array of objects, then performs a union of all keys across every element β essential when the API returns objects with optional fields that are absent in some records. This union becomes the CSV header row, and every object is then serialised in header order, substituting an empty string for absent keys.
Values require careful handling during serialisation. Strings that contain commas, double quotes, or newlines must be wrapped in double quotes, with embedded double quotes doubled per RFC 4180. Numbers and booleans are written as literals. Nested objects and arrays cannot be flattened automatically without losing information, so they are serialised as compact JSON strings β clearly marked so downstream consumers know to parse them further if needed.
Why Use FileCrank JSON to CSV?
- β Converts JSON arrays to CSV with keys as column headers.
- β Flattens nested objects using dot-notation automatically.
- β Swap direction to CSV-to-JSON without losing your input.
- β Runs entirely in your browser β no data sent to any server.
Features & Specs
Frequently Asked Questions
What JSON structure can be converted to CSV?
The input must be a JSON array of objects where each object has the same keys. If objects have inconsistent keys, missing values are left blank. Primitives and arrays of non-objects cannot be converted.
How are nested JSON objects handled?
Nested objects are flattened using dot-notation. {"user": {"name": "Alice"}} becomes a column named user.name. Arrays inside objects are converted to a JSON string in the cell. A warning is shown when flattening is applied.
Does the output CSV include a header row?
Yes. The first row of the output CSV is always the header row, derived from the keys of the first object in the JSON array.
Can I switch from JSON-to-CSV to CSV-to-JSON without losing my data?
Yes. Use the direction swap button to switch tools. Your input is preserved in the new tool's input panel.
Browser Converter vs. jq + csvkit vs. ETL Tools
The `jq` and `csvkit` combination is powerful in a pipeline but requires shell access and knowledge of both tools' syntax. Full ETL platforms like Airbyte or Fivetran are designed for recurring scheduled loads, not quick one-off conversions. A browser converter is the right tool when you have a JSON payload in hand right now and need a CSV in the next thirty seconds β no environment to set up, no commands to remember.
Related Tools
CSV to JSON Converter
Convert CSV data to a JSON array of objects instantly in your browser.
JSON Viewer, Formatter & Editor
View, edit, and format JSON in a live interactive tree. Inline value editing, key rename, add/remove nodes, JSONC comment support, and one-click export β all in your browser.
CSV Viewer & Smart Table
Open any CSV as an interactive smart table β sort columns, filter rows, edit cells live, and export to CSV, XLS, or XLSX. All client-side, no signup.
FileCrank JSON to CSV Converter transforms a JSON array of objects into a CSV table with dot-notation flattening for nested structures, running entirely in your browser.
Advertisement