Text Tool Suite Logo

JSON to CSV Converter

Convert JSON to CSV online. Paste or upload an array of objects, choose your delimiter (comma, tab, semicolon, or pipe), include a header row, and download a clean CSV file ready for Excel or Google Sheets.

JSON Input

Conversion Options

CSV Output

id,name,email
1,John Doe,[email protected]
2,Jane Smith,[email protected]
TL;DR — convert JSON to CSV safely in your browser

Paste or upload JSON (array of objects), choose your delimiter and header option, preview the result, then copy or download a .csv. Everything runs client‑side — no uploads.

JSON to CSV Converter – Export JSON Arrays to Excel & Google Sheets Free

Convert a JSON array of objects to CSV for Excel or Google Sheets. Choose comma, tab, semicolon, or pipe delimiter, include a header row, and download the CSV file in seconds — no uploads, no account. Everything runs locally in your browser so your data stays private.

The tool expects an array of objects and turns those objects into rows. Keys become column names when you enable the header row option. If some rows are missing certain keys, the converter fills those cells with blanks so the table stays aligned. You can choose the delimiter that matches your environment: comma for most cases, tab when you want TSV, semicolon for locales that use it as the list separator, or pipe when commas appear frequently in your data. A live preview lets you verify the result at a glance before you copy or download it.

Real‑world JSON is not always perfectly flat. If your objects contain nested structures or arrays, decide whether to flatten those fields into separate columns or simply stringify the nested value before converting. Keeping a predictable, flat shape across all rows will produce the cleanest CSV. When something’s off, you’ll see a clear error message so you can correct the input quickly without guesswork.

Working in both directions? Use the companion CSV to JSON to move data back into JSON with header detection and inferred types. If your payload needs a quick tidy, the JSON Formatter & Validator can pretty‑print, minify, and validate against a schema. For side‑by‑side comparisons of two exports, open the Difference Checker. And when you need to fix a label or normalize values before export, Find & Replace makes quick edits painless.

Because everything happens locally, the converter is safe to use with sensitive records. It’s fast, lightweight, and designed to remove friction from the last mile of data handling — getting structured JSON into a spreadsheet without detours through big tools or custom scripts.

Opening the CSV in Excel or Google Sheets

  • Google Sheets — drag and drop the downloaded CSV file directly onto an open Sheets tab, or use File → Import. Sheets auto-detects the comma delimiter in most cases.
  • Excel (comma delimiter) — double-click the .csv file to open it directly. If columns appear merged, use Data → Text to Columns and select Comma.
  • Excel (semicolon delimiter for European locales) — choose Semicolon as your delimiter before downloading. European Excel installations use semicolons as the list separator, so the file will open correctly without any extra import steps.
  • TSV for copy-paste — select the Tab delimiter and paste the output directly into Google Sheets or Excel; both apps split on tab characters automatically.

Key features

  • Instant JSON → CSV conversion in the browser (no uploads)
  • Delimiter options: comma, tab, semicolon, or pipe
  • Optional header row derived from object keys
  • Live preview with one‑click Copy and Download
  • Accepts pasted JSON or uploaded .json files
  • Clear error messages for invalid JSON input
  • Fast and private — everything stays on your device

Tips

  • The input should be an array of objects: [{...}, {...}]. Keep keys consistent across rows.
  • For regions where Excel expects semicolons, choose the Semicolon delimiter before downloading.
  • If your data has nested objects or arrays, flatten or stringify those fields first for predictable columns.
  • Need a round‑trip? Convert back later with the CSV to JSON tool.

Frequently asked questions

Is my data uploaded to a server?
No. The converter runs entirely in your browser, which is safer for sensitive data.
What JSON format does this expect?
An array of flat objects works best (for example: [{"id":1,"name":"A"},{"id":2,"name":"B"}]). If keys differ between objects, you may see empty cells in the CSV.
Excel shows values in one column — what now?
Pick the delimiter your spreadsheet expects (often Semicolon in some locales) or use the spreadsheet’s "Text to Columns"/import dialog and specify the delimiter you exported with.
Can I include a header row?
Yes. Enable Include header row to use object keys as column names at the top of the CSV.
What JSON format works best for CSV conversion?
An array of objects works best, where each object is a row and keys become columns. Keep keys consistent across all objects for predictable, well-aligned columns.
Can I convert CSV back to JSON?
Yes. Use the CSV to JSON tool for the reverse conversion — it supports header detection, delimiter auto-detect, and inferred data types.
How do I convert JSON to CSV for Excel online for free?
Paste your JSON array of objects, choose Comma or Semicolon delimiter (semicolon for European Excel locales), enable Include header row, and click Download CSV. Open the file directly in Excel — no account needed.
How do I convert a JSON array to a spreadsheet online?
Paste your JSON array into the converter, enable the header row option, and download the CSV. Import it into Google Sheets or Excel — object keys become column headers and each object becomes a row.
How do I convert JSON to TSV (tab-separated values) online?
Select the Tab delimiter option. The output will be tab-separated instead of comma-separated — compatible with Google Sheets paste and most spreadsheet apps.

You might also like