This JSON to CSV converter turns a JSON array of objects into clean comma separated values that open straight into a spreadsheet. You paste a JSON array, where each item is an object with named fields, and the tool reads every object, builds a header row from all the keys it finds, and writes one CSV row per object. It runs entirely in your browser, so nothing you paste is uploaded to a server and your data stays private on your device. Developers, analysts, marketers and anyone moving data between an API and a spreadsheet use this to avoid hand editing or writing a one off script. The converter handles values that contain commas, quotes or line breaks by wrapping them in double quotes and doubling any internal quotes, which is the standard CSV escaping that Excel, Numbers and Google Sheets all understand. It also collects keys across every object, so if some objects have extra fields the header still includes them and missing values come through as empty cells. Three tips help you get a clean result. First, make sure your input is a true JSON array that starts with a square bracket and contains objects, not a single object on its own. Second, keep field names consistent across objects so the columns line up the way you expect. Third, if a value is itself an object or a nested array it will be written as JSON text inside the cell, so flatten deeply nested data first if you want tidy columns. Once converted, copy the output and paste it into a new spreadsheet, or save it with a dot csv extension and open it directly.
Runs in your browser. Nothing is uploaded.
The tool parses your text as JSON, expecting an array of objects. It gathers every key across all objects to form the header row, then writes one row per object, filling missing fields with blanks. Values with commas, quotes or line breaks are wrapped in double quotes with internal quotes doubled.
Pasting an array of two people with name, age and city fields returns a header row of name,age,city followed by two data rows. A value containing a comma is automatically wrapped in double quotes so the columns stay aligned.
If you've found a bug, or would like to contact us, or learn more about James Graham and Calculate.co.nz.
Calculate.co.nz is partnered with Interest.co.nz for New Zealand's highest quality calculators and financial analysis.
All calculators and tools are provided for educational and indicative purposes only and do not constitute financial advice.
Calculate.co.nz is proudly part of the Realtor.co.nz group, New Zealand's leading property transaction literacy platform, helping Kiwis understand the home buying and selling process from start to finish. Whether you're a first home buyer navigating your first property purchase, an investor evaluating your next acquisition, or a homeowner planning to sell, Realtor.co.nz provides clear, independent, and trustworthy guidance on every step of the New Zealand property transaction journey.
Calculate.co.nz is also partnered with Health Based Building and Premium Homes to promote informed choices that lead to better long-term outcomes for Kiwi households.
Calculate.co.nz is hosted in Auckland via SiteHost new Zealand.
All content on this website, including calculators, tools, source code, and design, is protected under the Copyright Act 1994 (New Zealand). No part of this site may be reproduced, copied, distributed, stored, or used in any form without prior written permission from the owner.
© 2019 to 2026 Calculate.co.nz. All rights reserved.