Data & Code

CSV to JSON

Convert header-based CSV data into JSON objects.

Read the guide

Run the tool

The calculation runs in your browser. This tool does not send your input to JVR Software.

More information

Back to the tool

What it is and when to use it

CSV to JSON turns a comma-separated table into a list of JSON objects. Use it for a small spreadsheet export, an API test fixture or a one-off record conversion. The first row becomes the set of JSON property names, so meaningful and unique headers make the output easier to use.

How it works

The converter reads comma separators and CSV double-quoted fields. A doubled quote can represent a literal quote inside a quoted cell. All values are emitted as strings because a CSV record does not carry type information. Missing columns may be represented as empty strings.

How to use it

  1. Export comma-delimited UTF-8 text with one header row.
  2. Paste the header and records together, then run the tool.
  3. Check the first object and the row count, then convert any values that your destination requires as numbers, booleans or null.

Worked example

Enter name,count on the first line and Ava,2 on the second. You get an object with name set to "Ava" and count set to "2". If the destination API expects a number, convert that count explicitly after reviewing the type requirements.

Reading the result

Property names are copied from the column headers. A header with a spelling difference becomes a different JSON key. Inspect rows with quotation marks, blank cells or commas inside values to make sure the source export encoded them as intended.

When a spreadsheet exported phone numbers or product codes, compare those strings with the spreadsheet source, including leading zeroes. If the source application dropped a digit before export, this tool cannot restore it. Check dates against the exporting locale before assigning them another type.

Common mistakes and limits

A semicolon-separated export is a different delimiter format. Convert it using your spreadsheet's export options before using this tool. Avoid duplicate and empty header names because repeated keys can overwrite each other. This is not a full schema validator for irregular feeds.