Use this tool to convert CSV data to JSON. There are 4 types of JSON conversions:
- CSV to JSON - array of JSON structures matching your CSV
- CSV to Keyed JSON - Structure of JSON with the specified key column as the key value to a structure
of the remaining fields
- CSV to JSON Array - An array of CSV values where the CSV values are in an array
- CSV to JSON Column Array - An array of CSV values where each column of values are in an array
You have the option of making your attribute names upper and lower case.
You can limit the number of records processed also.
You can select the fields to output and rearrange JSON fields.
You can filter JSON output by using the query tool.
You can sort CSV data in ascending or descending order before converting to JSON.
See also JSON to CSV
and CSV To GeoJSON