CSV to JSON Converter

Direction

Source data

Delimiter

В русском Excel обычно точка с запятой.

Result

Result[ { "name": "Анна", "city": "Москва", "age": 29 }, { "name": "Пётр", "city": "Казань", "age": 34 } ]
Data rows2
Columns3
Headersname, city, age
Output characters132

A table and an array of objects are the same thing

Turns a table into an array of objects and back, with a configurable delimiter and automatic number detection.

Every system exports CSV — accounting packages, ad platforms, databases — while working with the data in code is easier in JSON. The first row becomes the keys and each following row an object.

The delimiter is an input for a reason. Excel in many locales writes CSV with semicolons, because the comma is taken by the decimal separator. Opened with the wrong delimiter, the file collapses into a single column.

What this calculator shows

The converted result in the direction you chose
Row and column counts and the list of headers
The size of the result in characters

What to keep in mind

Numbers are detected automatically and land in JSON unquoted; everything else stays a string.
Surrounding quotes are stripped, but commas inside quoted fields are not fully parsed — complex files need a real CSV parser.

FAQs

Which delimiter does my file use?

Open it in a plain text editor and look. Locale-dependent Excel writes semicolons, English Excel commas, and database exports often use tabs.

Why does Excel mangle non-Latin characters?

It opens CSV in the system codepage rather than UTF-8. Adding a byte order mark, or importing through the text wizard with an explicit encoding, fixes it.

What if a value contains the delimiter?

The standard says quote the field. This parser is simple, so for files with commas inside fields a semicolon delimiter is safer.

How do I handle nested JSON?

CSV is flat and cannot express nesting. Flatten those fields into separate columns, or serialise them into a string first.

Worked example

A three-column table

Input: name, city, age with two data rows

Output: An array of two objects, age as a number

Note: Age became a number rather than a string, which matters if the data goes on to be sorted or compared. Names and cities stayed strings.

Useful links

All tools in Dev Tools

CSV to JSON Converter

Result

Related tools

JSON to YAML Converter

JSON formatter and validator

Line Sorter & Deduplicator

Useful links