CSV table to JSON array

This online calculator can help you, if you have set of data in form of CSV table, and want to quickly make it usable inside your Javascript program. It may be test harness data, dummy data or whatever.
Here is how it work

1. Set up CSV columns to object properties mapping. You should specify them using the same separator as in CSV file. It you omit the name, this column will be skipped.
2. Paste your CSV contents
3. Tweak fields separator if needed. Default is semicolon.
4. Decide if you want empty strings replaced with nulls

As a result you will get JSON which can be copied to wherever you need.
If, by some chance, you have an error line - which is when number of fields does not match number of properties, line number and line text will be reported, so you can find and fix it.

CSV to JSON array

Columns to properties

1;One;Green;Big 2;Two;Red;Small

CSV

Field separator

Replace empty string with null

Calculate

JSON

 

Error line number

 

Error line

 

save Save extension Widget