# Convert JSON to CSV

> Save JSON data from an API or an export as a CSV table to open it in Excel or Google Sheets. No upload.

Your colleague in sales wants the data in Excel, you have it as JSON. It works best with a list of objects, like [ {…}, {…} ]. Each object becomes a row and the keys become columns.

- Open in browser: https://pockettoolbox.org/en/json-to-csv
- Tool: [All-In-One File Converter](https://pockettoolbox.org/en/file-converter)
- Runs entirely in your browser; files and input are never uploaded.

## How it works

1. Drop the JSON file in.
2. Convert and open the CSV in Excel or Google Sheets.

## FAQ

### Excel shows everything in one column.

Open the file via Data > From Text/CSV and Excel detects the comma delimiter. Google Sheets handles it directly.

### What happens to nested objects?

They end up as JSON text in a single cell. For clean columns, the JSON should be as flat as possible.

## Popular tasks

- [Convert JPG to PDF](https://pockettoolbox.org/en/jpg-to-pdf)
- [Convert PNG to JPG](https://pockettoolbox.org/en/png-to-jpg)
- [Convert WebP to JPG](https://pockettoolbox.org/en/webp-to-jpg)
- [Convert Images to WebP](https://pockettoolbox.org/en/convert-image-to-webp)
- [Convert HEIC to JPG](https://pockettoolbox.org/en/heic-to-jpg)
- [Convert SVG to PNG](https://pockettoolbox.org/en/svg-to-png)
- [Convert JPG to PNG](https://pockettoolbox.org/en/jpg-to-png)
- [Convert PNG to PDF](https://pockettoolbox.org/en/png-to-pdf)
- [Convert PNG to ICO](https://pockettoolbox.org/en/png-to-ico)
- [Convert WebP to PNG](https://pockettoolbox.org/en/webp-to-png)
- [Convert HEIC to PNG](https://pockettoolbox.org/en/heic-to-png)
- [Convert HEIC to PDF](https://pockettoolbox.org/en/heic-to-pdf)
- [Convert AVIF to JPG](https://pockettoolbox.org/en/avif-to-jpg)
- [Convert BMP to JPG](https://pockettoolbox.org/en/bmp-to-jpg)
- [Convert TIFF to JPG](https://pockettoolbox.org/en/tiff-to-jpg)
- [Convert ICO to PNG](https://pockettoolbox.org/en/ico-to-png)
- [Image to Base64](https://pockettoolbox.org/en/image-to-base64)
- [Make a Photo Black and White](https://pockettoolbox.org/en/black-and-white-photo)
- [Convert CSV to JSON](https://pockettoolbox.org/en/csv-to-json)
- [Convert XML to JSON](https://pockettoolbox.org/en/xml-to-json)
- [Convert YAML to JSON](https://pockettoolbox.org/en/yaml-to-json)
- [Convert STL to OBJ](https://pockettoolbox.org/en/stl-to-obj)
- [Convert MP4 to MP3](https://pockettoolbox.org/en/mp4-to-mp3)
- [Convert WAV to MP3](https://pockettoolbox.org/en/wav-to-mp3)
- [Convert M4A to MP3](https://pockettoolbox.org/en/m4a-to-mp3)
- [Convert MP3 to WAV](https://pockettoolbox.org/en/mp3-to-wav)
- [Convert FLAC to MP3](https://pockettoolbox.org/en/flac-to-mp3)
- [Convert OGG to MP3](https://pockettoolbox.org/en/ogg-to-mp3)

---
PocketToolbox (https://pockettoolbox.org/en)