That’s the reason why we created this application. So it is not possible to make some basic and easy algorithm to map values from nested JSON structure, into flat table structure of Excel XLS files. Sounds probably very complicated, but this is the reality and power of storing data in JSON format. In one object you can have numbers or strings stored directly under some properties and in the same JSON file you can have arrays of objects or objects containing another arrays. Main problem is that JSON can contains nested and inconsistent data. It is not easy to map JSON into EXCEL XLS file. In many cases it is needed to export data from one system in one format like JSON, next import it another system, where maybe, you need to store it in human-readable form, like in Excel XLS files. JSON data format is widely used in software development and in many other jobs where users are working on data, especially, when in usage are more then one application. You can use here whatever JSON syntax you want – even complex nested objects and arrays with values, and JSON TO EXCEL app will consume it, and give you nice and clean Excel XLS file to download.

Xhr.JSON to Excel is application which allows you to copy-paste JSON text or upload a JSON file and convert its content into Excel XLS file. Inform that interactive phase is finished and send information to MSTR. M圜onnector.fetchTable = function(table, params, doneCallback) ) Connector must define fetchTable function Var m圜onnector = mstr.createDataConnector() mstr is a global object from mstrgdc-2.0.js, which represents the data connector framework

Open json file in excel