Convert CSV to JSON

Choose from the following 5 JSON conversions offered by this tool:
CSV to JSON - array of JSON structures matching your CSV, nested JSON via column headers, and JSONLines (MongoDB) mode
CSV to Keyed JSON - Generate JSON with the specified key field as the key value to a structure of the remaining fields, also known as an hash table or associative array. If the key field value is unique, then you have "keyvalue" : { object }, otherwise "keyvalue" : [ {object1}, {object2},... ]
CSV to JSON Array - An array of CSV values where the CSV values are in an array, or a structure with column names and data as an array
CSV to JSON Column Array - An array of CSV values where each column of values are in an array
Generate JSON via Template - Using our template engine, easily customize your JSON output NEW
Automatic detection of numeric values, logical values, and nulls
TSV to JSON

Choose your attribute names to be upper or lower case
Choose to limit the number of records processed
Select the fields to output and also rearrange JSON fields
Filter JSON output by using the query tool
Create nested JSON output by using / in the column headings of CSV. Arrays are created from duplicate column names or /0, /1, ... in the heading. See Output Options NEW
Sort CSV data in ascending or descending order before converting to JSON
Convert value of NULL in CSV to be null in JSON
Optionally output null instead of "" for empty fields
Optionally do not write out field : value if field value is empty. See Output Options
Terse Mode and Json Lines Mode - one object per line with no commas separating objects.
Add top level name property name to JSON output NEW See Output Options

Output Options

Display which field positions? (Comma separated list where 1 is 1st field, 2=2nd,... i.e. 2,1,3,4)

Force Wrap numeric values in double quotes for these field positions Comma separated, leave blank for all

Add Top Level Property Name

If to Keyed JSON, which field # is key? (Default 1)

If to JSON Array, create array for column names with name = and Data name =

Always overwrite template when generating standard JSON

Consider value of NULL in CSV to be null in JSON

Do Not output field/value pair if value is empty

Recreate nested objects and arrays (Headings use /)

Terse Mode- Each record on one line , plus JSON Lines Mode no commas in between

Always display numeric strings as numeric for these fields positions Comma separated, leave blank for all

Modify template below and Press Convert

Choose Conversion Type:

Result Data:

Save your result:.jsonEOL:

You can Save the complete data and settings, and then later Load them from your saved file.
Load Saved Form
Save Form (data and settings)