CSV to JSON Converter
Spreadsheet Rows Into Clean Records

Jobs This CSV to JSON Converter Handles for You

This CSV to JSON converter reads the rows of a spreadsheet file and writes each one as a JSON object. The first row supplies the names, and every row after it becomes one record. Your browser does the reading, so the file never leaves your computer.

CSV looks simple, but it hides traps. A name like "Ahmed, Bilal" contains the very comma that separates columns. A zip code such as 05400 loses its zero if anything treats it as a number. Meanwhile, a note typed over two lines breaks the file into extra rows. A careless converter gets all three wrong.

This one follows the rules that spreadsheets use when they write CSV. Then it shows a checks table: the delimiter it detected, the rows it read, and anything it had to fix along the way.

Reading CSV the Way Spreadsheets Write It

The format is described in RFC 4180, and Excel, Google Sheets and LibreOffice all follow it closely. A field wrapped in double quotes may contain commas, quotes and even line breaks. Inside such a field, two quotes in a row stand for one real quote.

The reader handles every one of those cases. It also removes the invisible byte order mark that Excel adds to the start of UTF-8 files. Otherwise that mark would sneak into the name of your first column and break every lookup on it.

Convert CSV to JSON With the Right Types

A CSV file stores every value as plain text. JSON, on the other hand, knows numbers, true and false, and null. So the converter looks at each value. A plain number becomes a JSON number, and true or false become real booleans.

Some numbers must stay text, though. A zip code or a phone number with a leading zero keeps its quotes, because 05400 and 5400 are different things. In fact, the whole column stays text, so 05400 and 74000 never end up as two different types. Likewise, an ID longer than fifteen digits stays text, since JavaScript would round it. Prefer everything as strings? Then switch type detection off.

Headers Like user.name Turn Into Nested Objects

Flat tables often stand in for nested data. A column called address.city really means "the city inside the address". Turn on dotted names, and the converter rebuilds that structure, so address.city and address.zip end up inside one address object.

This is the exact reverse of what our JSON to CSV converter does. Therefore you can export JSON to a sheet, edit it with colleagues, and bring it back without losing its shape.

Objects or Arrays: Picking the Output Shape

Most code wants a list of objects, where every value sits next to its name. That is what you get when the first row holds the names. Some charting libraries and data tools prefer plain rows, though. For them, switch the header option off, and each line becomes a simple array in the same order as the file.

The layout of the text is your choice as well. Two spaces suit a file that people will read and edit. Four spaces or tabs match many code styles. One line with no spaces at all is the smallest option, so it works best inside an API request or a config value.

Excel to JSON in Two Steps

There is no need for a plugin or a macro. Inside Excel, open File, go to Save As, then select CSV UTF-8 from the list. Next, open that file here or paste its contents. The JSON shows up the moment you paste.

Excel in much of Europe saves with semicolons instead of commas, because the comma is its decimal mark. The converter spots this by itself and says which delimiter it used. You can still pick one by hand if a file is unusual.

What Happens to Broken Rows

Hand-edited files are rarely perfect. If a row is shorter than the header, its missing keys stay empty, and the checks table counts them. When a quote opens and never closes, the converter stops and names the exact line, since guessing there would scramble every row after it.

Who Turns Spreadsheets Into JSON

Coders run into this every week. A product list kept in a sheet becomes seed data for a database. A table of translations becomes a language file. For instance, a designer can hand over a spreadsheet of test users, and a developer can load it into a mock API a minute later.

It also helps people who never code. Many website builders, form tools and automation services accept JSON imports. So a sales list or an event schedule can move from a sheet into those tools without retyping a single row. The MDN guide to JSON is a friendly place to learn what the result means.