[]

#Tool

This tools converts a CSV (comma separated value) file or text into a JSON. There are options available to either select a file from local system or to provide a csv text in the text area. If both are provided tool uses the csv in file. There is an option to select whether the first row of csv should be considered as the column headings or not and depending on that it creates the JSON from CSV.

#Knowledge

CSV

CSV is Comma separated Value. In this the values are separated by comma. Usually a csv file is created which contains multiple lines of csv strings. A relational data can be written in csv format where values at same index in each line are considered for the same column. This format is used to transfer the data between systems, storages. CSV files are used to import or export the data from systems. Sometimes first line of CSV file is considered as the column names for rest of the data and if column names are not present then, columns are inferred based on the index of the values while importing the file. Below are examples of csv file.

File with Column names

column1,column2,column3
this,is,first
this,is,second
this,is,third

File without Column names

this,is,first
this,is,second
this,is,third

JSON

JSON stands for Javascript Object Notation. It is an open standard file format and data interchange format that uses human-readable text to store and transmit data objects consisting of attribute-value pairs and arrays (or other serializable values). It is a common data format with diverse uses in electronic data interchange, including that of web applications with servers. JSON is a language-independent data format. It was derived from JavaScript, but many modern programming languages include code to generate and parse JSON-format data. JSON filenames use the extension .json.

Example 1

{'item1':'value1', 'item2':['value2','value3']}

Example 2

[{'key1':'value3'},{'key1':'value4'}]