KitJade
Developer ToolsRuns in your browserNew

CSV to JSON

Turn CSV rows into clean JSON objects.

Use the CSV to JSON tool

Runs in your browserUpdated Report a problem

What this csv to json does

CSV to JSON reads the first row as field names and turns each later row into an object. A real parser handles quoted fields, escaped quotes, commas inside values and line breaks inside quoted fields — the cases that break a naive split on commas.

The delimiter is detected from the header row, so tab-separated and semicolon-separated exports work too. Numbers and booleans are converted to JSON types by default; disable inference if every value should stay a string.

Why use it

  • Move a spreadsheet export into an application or API fixture.
  • Inspect data with a tool that understands JSON types.
  • Normalise a CSV before importing it into a database.

How to use it

  1. 1Paste the CSV or open a .csv file.
  2. 2Check the detected delimiter and the type inference option.
  3. 3Copy the JSON or download it as a file.

Worked examples

Simple table

Input

name,age
Ada,36
Linus,56

Output

[{"name":"Ada","age":36},{"name":"Linus","age":56}]

Quoted comma

Input

city,note
Pune,"Roads, bridges"

Output

[{"city":"Pune","note":"Roads, bridges"}]

Common mistakes

  • Assuming every value should be a string; IDs with leading zeros can lose them when converted to numbers.
  • Forgetting that duplicate header names need renaming to avoid overwriting fields.
  • Using a spreadsheet's display formatting instead of the raw values when exporting.

Frequently asked questions

What happens to duplicate column names?
Later duplicates are renamed with a numeric suffix so no data is lost. A warning lists the rename.
Are empty cells null or empty strings?
They become empty strings by default. Use the output as a starting point and adjust in your code if your schema needs null.
Can it read semicolon-delimited files?
Yes. The delimiter is detected automatically, and you can override it with the delimiter option.

Related tools

All tools

JSON to CSV

Turn JSON arrays into spreadsheet-ready CSV.

Runs locallyNew

Duplicate Line Remover

Remove repeated lines while keeping the original order.

Runs locallyNew

JSON Formatter

Beautify or minify JSON, with precise error positions.

Runs locally

JSON Validator

Pinpoint JSON errors by line and column, instantly.

Runs locally