CSV has been a standard format for decades used to import data into almost every database system. Json format is a much newer format, but many databases also now support it. But because Json allows arrays for any value and supports subdocuments, it can be problematic for simple importing into a single relational table.

This tool, that uses the Didgets data management platform, can easily import Json files to form relational tables with just a few clicks of the mouse. The user can then manipulate the data and query it for specific subsets just like any other database. The results can then be exported back out to Json, Json Lines, XML, HTML, CSV, or other formats.

This works even if you have millions of documents (i.e. records) within the file or if you have subdocuments or arrays within each record.

The tool is currently in beta and is available for free download at https://www.Didgets.com/download