Code drawer

CSV ↔ JSON converter

Reshape small datasets privately, without opening a spreadsheet app.

Privacy built inYour work stays with you

JSON output

Your result will appear here.

Your work stays private in your browser while you use this tool.

In short

What does csv ↔ json converter do?

Convert a header-based comma-, semicolon-, or tab-delimited table into an array of JSON objects, or flatten an array of JSON objects into a delimited table with the union of its keys.

Input
CSV with a header row or an array of JSON objects.
Result
Converted CSV or formatted JSON.
Price
Free
Account
Not required
A quick, useful guide

How to use csv ↔ json converter

01

Add your input

CSV with a header row or an array of JSON objects.

02

Choose your settings

Reshape small datasets privately, without opening a spreadsheet app.

03

Save or copy

Converted CSV or formatted JSON.

A practical tip

Check fields containing commas, quotes, or line breaks after conversion.

Practical uses

When to use csv ↔ json converter

Turn a small spreadsheet export into records for a fixture or API request.

Export a JSON array as CSV for review in a spreadsheet application.

Normalize duplicate or blank source headers into usable JSON property names.

Worked example

A concrete csv ↔ json converter example

Input
name,note Ada,"Hello, world"
Settings
CSV to JSON with comma delimiter
Result
The output is an array containing {"name": "Ada", "note": "Hello, world"}. The comma inside the quoted field remains part of the note.
What to expect

How it works

The CSV parser walks the text character by character, supports doubled quotes and embedded delimiters or line breaks in quoted fields, and treats the first row as headers. Blank headers become column_N and duplicate headers gain numeric suffixes. JSON-to-CSV collects every object key, stringifies nested values into cells, and quotes cells when required.

Know before using

Limits and edge cases

  • CSV input must contain a header and at least one data row, and only comma, semicolon, or tab can be selected as the delimiter. The converter does not infer types, so CSV cells remain strings.
  • This tool is best for modest datasets; very large files may slow the page. JSON input must be a non-empty array of objects, and nested arrays or objects are stored as JSON text inside a single CSV cell.
References

Standards and sources

Common questions

CSV ↔ JSON converter FAQ

Is csv ↔ json converter free to use?

Yes. CSV ↔ JSON converter is free to use.

Does csv ↔ json converter keep my work private?

Yes. Your work stays private while you use the tool — nothing you enter is uploaded.

How are duplicate CSV headers handled?

The first header keeps its trimmed name; later duplicates receive _2, _3, and so on. An empty header becomes column_1, column_2, or the corresponding position.

Will the value true in CSV become a JSON boolean?

No. CSV has no universal type metadata here, so every parsed cell is emitted as a JSON string. Change types after conversion if your destination requires booleans or numbers.