CSV to JSON

Convert CSV data to JSON and back.

🔒 This file is processed in your browser. It is never uploaded anywhere.

…

What it is for

CSV and JSON are the two commonest ways of moving tabular data, and each world prefers its own. CSV is what spreadsheets and business software export: rows and columns separated by commas. JSON is what web applications and APIs consume.

Converting between them is constant in any data work. You receive a listing exported from a business system and need to load it into an application; or the other way round, you have an API response and want to open it in a spreadsheet to analyse it with pivot tables.

The first row of the CSV is taken as the header: each column names a field in the resulting JSON, so every row becomes an object with those fields.

How it works

  1. Paste your CSV data (comma-separated values), with the first row as the header.
  2. Click "CSV → JSON" to convert it, or "JSON → CSV" for the reverse.
  3. Copy the converted result.

When to use it

Loading data into an application

A listing exported as CSV becomes JSON so it can be imported where that format is expected.

Analysing in a spreadsheet

Going from JSON to CSV lets you open the data in Excel or Calc and work it with familiar tools.

Preparing test data

Converting a small CSV to JSON is the quick route to sample data for testing.

Practical tips

  • The tool expects commas as the separator. Many European exports use semicolons: replace them before pasting.
  • Take care if the content itself contains commas, as in addresses: they can split the row into extra columns.
  • The first row must be the header with the column names.
  • Check numbers and dates after converting: regional formats are the most common source of surprises.

Frequently asked questions

What if my data uses semicolons instead of commas?

This tool expects commas as the separator; if your CSV uses semicolons, replace them with commas before pasting (watch out if the content itself contains commas).

Does it work with very large CSV files?

It works with anything that fits when pasted into the text box; for very large files the browser may take a few seconds.

Related tools

Word counterCount words, characters and paragraphs in a text.JSON formatterFormat and validate JSON, with error detection.Base64 encoderEncode or decode text as Base64.URL encoderEncode or decode text for use in URLs.