Skip to content
Utilerio

CSV to JSON

Convert a CSV file or pasted rows into a JSON array.

JSON output

The result will appear here.

Was this tool useful?

About this tool

CSV is what spreadsheets, marketplace exports and accounting systems produce. JSON is what APIs and scripts consume. Moving between them is one of the most common small chores in day-to-day integration work.

The details are where CSV files go wrong: which delimiter, whether the first row is data or headers, how quoted fields containing the delimiter are handled. All three are settings here, and the delimiter can be detected automatically when you are not sure.

How to use it

  1. Paste the rows or upload a .csv file.
  2. Choose the delimiter. Exports from Turkish and European systems very often use a semicolon, because the comma is the decimal separator there.
  3. Leave the header toggle on if the first row contains column names — the JSON keys come from it.
  4. Turn on type conversion to get real numbers and booleans instead of strings.
  5. Convert, then copy or download the JSON array.

Examples

Semicolon-separated export with headers

sku;name;price
TL-001;Label roll;19,90
[
  { "sku": "TL-001", "name": "Label roll", "price": "19,90" }
]

Common problems

Every row comes out as a single field.
The delimiter setting does not match the file. Open the CSV in a text editor and look at the first line: if you see semicolons, select semicolon.
A row is split in the middle of a value.
A value containing the delimiter must be wrapped in double quotes, and quotes inside it doubled. An unbalanced quote earlier in the file shifts everything after it.
Decimal values are wrong after type conversion.
19,90 is a decimal in Turkish notation but not in JSON. With a comma delimiter it also splits the field. Export with a semicolon delimiter, or convert the decimals in your own step.

Frequently asked questions