JSON to CSV Converter

Turning JSON data into a spreadsheet

JSON is the natural format for APIs, but many people who need the data work in Excel or Google Sheets. Converting an array of objects to CSV lets you sort, filter, chart and share the data without writing code. It is a quick way to hand an API export to a colleague in finance, sales or operations who wants rows and columns rather than brackets.

This converter looks at every object in the array and builds a column for every key it finds, even if some objects are missing a few fields. Nested objects are flattened into dotted column names, so an address object with a city field becomes a column called address.city. Arrays inside objects are written as text in a single cell, since spreadsheets have no natural way to show a list inside one cell.

A few details help the file open cleanly. Values that contain commas, quotes or line breaks are wrapped in quotes so they stay in the right column. If you plan to open the file in Excel and your data includes characters such as ₹ or names in Indian languages, use the download option, which adds the marker Excel needs to read the text correctly. Large numbers such as phone numbers or account IDs may be shown in scientific notation by Excel; formatting that column as text after opening avoids the problem. If the JSON is a single object rather than an array, wrap it in square brackets first. The conversion happens in your browser, so customer exports stay private.