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.
If you want some sample data to play with, we recommend trying the random CSV generator at ExtendsClass.
Having trouble getting the correct structure? Take a look at the examples page. If you are still stuck, get in touch and we'll try to help you out!
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.
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.