API exports
Open customer, order or lead data from an API in a spreadsheet.
JSON to CSV
Open API data in Excel or Google Sheets. The conversion happens in your browser.
Your files stay with you. Your files never leave your browser. This tool runs on your device: nothing is uploaded to our servers, so there is nothing for us to store or see.
How to use it
- Paste a JSON array, for example a list of customers, or open a .json file.
- Choose the separator and whether to flatten nested objects.
- Copy the CSV or download data.csv.
Where it helps
Reports
Turn JSON logs or analytics into a table you can sort and chart.
Sharing data
Hand non-technical colleagues a file they can open in Excel.
Good to know
Stays in your browser
Your text is processed on your device and never sent to our servers.
Formula protection
Adds an apostrophe to cells starting with = + - or @.
Arrays stay in one cell
Lists are written as JSON text, since a cell can't hold a list.
Questions people ask
How do you convert JSON to CSV for Excel or Google Sheets?
Paste a JSON array, such as a list of customers, or open a .json file. Choose the separator and whether to flatten nested objects into columns like address.city. Each object becomes a row and its keys become the header. Copy the CSV or download data.csv, which is UTF-8, so Indian names and the rupee sign survive.
- Rows From objects. Keys become headers.
- a.b Flattened. Nested objects.
- UTF-8 Encoding. ₹ and Hindi survive.
- =+-@ Formula protection. Optional.
What JSON shape works best?
A list of objects with similar keys, like [{"name":"Asha","city":"Pune"}, ...]. Each object becomes a row and the keys become the header. A single object becomes one row, and a list of lists is written as plain rows. Keys missing from some objects simply leave those cells empty.
What happens to nested objects and arrays?
Nested objects are flattened into columns with dotted names, such as address.city and address.pin. Arrays are written into one cell as JSON text, because a spreadsheet cell can't hold a list. If you need each array item on its own row, reshape the data before converting.
Why would I turn on formula protection?
A cell that starts with =, +, - or @ can run as a formula when opened in Excel, which attackers can abuse through data they control, such as a name field. The option adds a leading apostrophe to such cells. Leave it off if you need the exact original text.
Will Excel show Indian names and rupee signs correctly?
The file is UTF-8. If Excel shows odd characters, import it with Data, From Text/CSV and choose UTF-8 as the file origin, or open it in Google Sheets, which reads UTF-8 by default. Double-clicking a CSV in older Excel versions is what usually causes the garbled text.
Which separator should I choose?
A comma works for most tools and for English-language Excel. Choose a semicolon if your Excel uses commas for decimals, as some European settings do, or a tab if your values contain lots of commas. The receiving system's import settings usually tell you which one it expects.
What if my JSON is wrapped in an object?
Many APIs return something like {"data": [...]} or {"results": [...]}. Copy just the array inside, starting at the square bracket, and paste that. A single object would become a single row. The JSON formatter makes it easy to see where the array starts. Then each record in the array becomes its own row in the CSV.
How are the column headers chosen?
The tool collects the keys from the objects in the order it first meets them, so the columns usually follow the first record. Keys that only appear in later records are added at the end. Rename or reorder columns in your spreadsheet afterwards if you need a different layout.
Are numbers and dates kept as they are?
Values are written as text in the CSV, exactly as they appear in the JSON. Your spreadsheet then decides how to show them. Excel may turn long numbers or IDs into scientific notation and drop leading zeros, so format those columns as Text when importing.
Can I open the result in Google Sheets?
Yes. Download data.csv and use File, Import in Google Sheets, or paste the copied CSV into a cell and choose Split text to columns. Google Sheets reads UTF-8 correctly, so names in Hindi, Tamil or other scripts and the rupee sign show properly. Sorting, filtering and charts then work as usual.
How do I export leads or contacts this way?
If a system gives you JSON, through an API or an export, paste it here to get a CSV you can import into a CRM, an email tool or a spreadsheet. Marketiism can export contacts as CSV directly and import them too, so you won't need this step there.
Is there a size limit?
The conversion runs in your browser, so very large files depend on your device's memory. Files of a few megabytes convert comfortably. For much larger exports, split the JSON into parts or use a command-line tool such as jq on your own computer instead. Most everyday exports are well within that.
Why does a value with commas break my columns?
It shouldn't here. Values that contain the separator, quotes or line breaks are wrapped in double quotes, following the CSV standard, so spreadsheets read them as one cell. If another tool splits them, check that it's importing with the same separator you chose here. Opening the file in Google Sheets is a quick test.
Is my data uploaded?
No. The JSON is read and converted in your browser, and nothing reaches our servers. That makes it safe for customer lists, order data and other records you shouldn't hand to an unknown website. Still, close the tab when you're done on a shared computer.
Does it work on a phone?
Yes. You can paste JSON or open a file from your phone and download the CSV. Checking and editing the CSV is easier in a spreadsheet app or on a computer, but the conversion itself works on any modern mobile browser, entirely on your device.
Is the JSON to CSV converter free?
Yes. It's free with no sign-up and no limit on use. It's one of the free developer tools from Marketiism, alongside the CSV to JSON converter and the JSON formatter. Marketiism also builds business software, software that runs WhatsApp, billing and CRM. Use it as often as you need.
Want this inside your own account?
Marketiism keeps your invoice numbers, GST reports, UPI payment links and WhatsApp reminders in one place. Leave your details and we'll call to set it up for your business, or start the trial yourself.
More Developer tools
CSV to JSON
Convert CSV rows into a JSON list, with numbers and true/false detected.
JSON Formatter
Format, validate and minify JSON, and see exactly which line has a mistake.
JSON to YAML
Convert JSON into clean YAML for configs, Kubernetes and CI files.
YAML to JSON
Convert YAML config files into JSON and catch indentation mistakes.
XML Formatter
Pretty-print or minify XML and find unclosed or mismatched tags.
HTML Minifier and Beautifier
Shrink HTML by removing comments and extra spaces, or re-indent it for reading.