JSON to CSV Guide

This guide shows how to turn a JSON array into CSV so you can download it and open it in Excel or Google Sheets. RazTools runs locally in your browser — no upload.

When you need JSON to CSV

• You have API responses in JSON but want to analyze the data in a spreadsheet.
• You need to share data with someone who prefers CSV or Excel.
• You’re exporting from a tool that outputs JSON arrays.

How to convert JSON to CSV online

1. Copy a JSON array (usually starts with [ and ends with ]).
2. Paste it into the input box in the converter.
3. Click Convert, then Download or Copy.

Example JSON

[
  {"name":"Alice","age":28,"active":true},
  {"name":"Bob","age":31,"active":false}
]

Tips for Excel and Google Sheets

• After downloading the CSV, open it with Excel or import it into Google Sheets.
• If you see weird characters, make sure you import the file as UTF-8.
• CSV is useful when you need rows and columns from JSON data.

What happens to nested objects and arrays?

Nested objects and arrays are converted into JSON strings inside a CSV cell. This keeps the output consistent even when the input data contains deeper structures.

FAQ