JSON to CSV Converter
Convert a JSON array of objects into a CSV file. Nested objects become dot notation columns and formula like cells are neutralised for spreadsheets.
Runs on your device
Result
Results appear here after you select “Convert”.
What it does
Export API data to a spreadsheet without writing a script. The converter collects every key across all rows, flattens nested objects to columns such as address.city, and escapes values according to RFC 4180.
How to use it
- Paste a JSON array (or a single object).
- Choose the delimiter.
- Convert and download the CSV.
Example
The example fills in realistic values and runs the tool. Select Try an example above to see it.
When it helps
- Sharing API results with nondevelopers.
- Importing records into Excel or Google Sheets.
- Quick data audits.
Questions
What happens to arrays inside objects?
They are written as JSON text in a single cell so no data is lost.
Why do some cells start with an apostrophe?
Values beginning with an equals, plus, minus or at sign are prefixed so spreadsheet apps do not execute them as formulas (CSV injection protection).
More developer tools
See all 25- HTML Entity Encoder & Decoder Escape text for safe use inside HTML, encode every non-ASCII character as a numeric entity, or decode named and numeric entities back to text.
- Diff Checker Compare two texts line by line and see exactly which lines were added or removed, with an option to ignore whitespace changes.
- Cron Expression Explainer Translate a five field cron expression into plain English and list its next scheduled run times in your local time zone.
- Number Base Converter Convert integers of any size between binary, octal, decimal, hexadecimal and base 36 using exact BigInt arithmetic.
- JSON to TypeScript Interfaces Generate TypeScript interfaces from a sample JSON payload, with nested types, optional properties inferred from arrays, and safe property names.
- IPv4 Subnet Calculator (CIDR) Calculate network address, broadcast, usable host range, subnet mask, wildcard mask and host count from any IPv4 address and CIDR prefix.
People also use
Browse all 200 tools- Roman Numeral Converter Convert numbers to Roman numerals and back, from 1 to 3999, with validation that catches invalid forms like IIII or VX. Quick utilities
- Net Worth Calculator Add up your assets and debts to calculate your net worth, with a breakdown you can update every few months to track progress. Personal finance
- Scientific Expression Calculator Evaluate expressions such as 2sin(30) + sqrt(16)/3 with trig, logs, powers and factorials, in degrees or radians, without using eval. Student & maths
- Habit Tracker Track daily habits on a simple weekly grid with streak counts. Tick each day you do it; everything is saved privately in your browser. Time & productivity