CSV to JSON converter with Nesting

JSONify It is a CSV to JSON converter designed to help you easily convert tabular data from spreadsheets, CSV files or any delimited file into JSON. What makes JSONify It stand out from other CSV to JSON converters available online is its ability to generate nested JSON. This is particularly useful for those looking to create multilevel visualizations such as zoomable/drilldown treemaps and Foamtrees, both of which require a specifically nested format of JSON to function.

Step 1. Enter Data



Input and Output Options

Separator:

Header:

Basic Output Options

Base Structure:

Index:

Nesting Options

Name Key:

Children Key:

Column to Sum:

Field Name:

Average Field:

Field Name:

Wrapper Options

Include wrapper?

Name Value:

JSON Preview


What is JSON?

JSON, or JavaScript Object Notation, is a format of data storage that utilizes key-value (or attribute-value) pairs to represent data. This format of data representation is used primarily in programming, and is a default datatype in most programming languages (although they can be called different things - i.e. a Python dictionary). The strength of JSON is its flexibility, allowing for a given dataset to be stored in a variety of different ways, ensuring that the minimum reworking of the data is required given an expected use case for that data.

When would I use this?

Oftentimes in programming, data in a tabular source such as an Excel spreadsheet, Google Sheet, CSV file, or some other form of delimited file (e.g. TSV) will be required to generate some output. In many cases the data will be a small static dataset that is unlikely to change regularly. In this case, it is often far simpler to do a one time conversion, using a tool like JSONify It, than to create a script to parse the data from a CSV or other static file.

For those who have some experience in creating visualizations, particularly online visualizations using JavaScript and libraries such as D3.js or Highcharts, one thing that you will often come across is the need to convert your data into JSON. Typically this need will arise because the data you receive or collect will be in the more human-friendly format of a spreadsheet.

Why this converter?

Currently, there are a number of CSV to JSON converters lying around on the internet for people to use, and most of them work more or less as expected. The key feature that JSONify It has - aside from a much friendlier UI than most other converters - is the unique ability to generate nested JSON files. This is particularly useful for data with categorical features that can be used to partition the data. With a nested JSON, subsets of the data can easily be selected without having to loop through the entire object. On the visualization side, this type of nested JSON is typically very useful for visualizations where the user can drill down into subsegments, such as zoomable Treemaps and Voronoi diagrams.

The other big plus for JSONify It is your privacy and data security. We do NOT store, monitor or track any of the data that passes through this website. In fact, this app does not even have a database in which it could store anything. Your data is yours and that is the way it will stay. How can we prove it? This project is completely open source so you can check out the repository on GitHub for yourself. You should also feel free to raise any issues you encounter at the same location.