How to Change CSV to JSON (and JSON to CSV)

Developer · Step-by-step guide · 4 steps · 2 min read

CSV is the simple text format that spreadsheets save. JSON is the format many apps use. This tool moves data from one to the other.

Open the CSV to JSON Converter

In the pictures, orange letters like A show where to look. Each step tells you its letter.

Step 1: Paste your data

In 1 Your data, paste CSV or JSON into Paste CSV or JSON. A CSV file saved from Excel or Google Sheets works well. See A in the picture.

Step 2: Check the settings

In 2 Settings, pick what splits the columns in Delimiter. It is usually a comma. Keep First row is the header ticked if the first line has column names. See B in the picture.

CSV converter with a small table of names, cities and orders — Your data (A) and the settings (B).

Step 3: Press Convert

Press Convert. The tool works out if you pasted CSV or JSON. See C in the picture.

Step 4: Check and download

A preview table shows your rows. The result shows below it. Press Download .json or Download .csv to save it. See D in the picture.

Preview table and the same data as JSON — Convert (C) and the result with a preview table (D).

Tips and questions

My file uses semicolons. Will it work?

Yes. Pick Semicolon ; as the delimiter. Excel in many countries saves files this way.

Why are my numbers in quotes?

CSV files do not say if a value is text or a number. So the tool keeps values as text to be safe.

What about commas inside a value?

A value in quotes, like "Smith, John", stays in one column.

Privacy

Your data is handled in your browser. It is never sent to us. So it is safe to paste private or work data.

Try it now

The CSV to JSON Converter is free. You do not need an account.