Burger mobile menu

JSON to Excel XLS file

Published: 2 Nov, 2020

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.

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.

 

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. 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.

 

It is not easy to map JSON into EXCEL XLS file. Main problem is that JSON can contains nested and inconsistent data. 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. Sounds probably very complicated, but this is the reality and power of storing data in JSON format. 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.

That’s the reason why we created this application. Behind it we implemented sophisticated algorithms which are identifying data types inside JSON, then it is choosing what is the best way of flattening arrays and objects and transform it into nice looking, human-readable Excel XLS file.

 

Application is created in a way to consume all kinds of JSONs, even with nested objects, but you must remember that this is very hard to transform and present nested objects from JSON into flat table in Excel XLS file. We suggest to use following data syntax in your JSON files for successful Excel XLS transformation:

  1. Keep consistency of data inside JSON. Our algorithms will handle it, but data inside Excel can be in not nice-looking form. Most preferable forms are:
    a) Array of objects or array of arrays
    b) Array of numbers/strings
    c) Object containing arrays or objects under its properties
    .
  2. Do not mix data types inside one data structure. Our algorithms will handle that, but data inside Excel can be in not nice-looking form. Keep the following rules in your JSON files:
    a) Under one array keep the same types of data like only: objects, arrays or numbers/strings
    b) Do not mix data under one array or object, example: arrays/objects among numbers/strings
    .
  3. Avoid too nested data in you JSON. If you have on 3rd or higher nest in your JSON next nested data especially like objects or arrays of objects, it means that in this place this data should be handled into another table (sheet) combined with index/key relation between both tables/sheets. This functionality is not implemented yet in our algorithm, so currently in this place you will get stringified object or array.
    .

Enjoy using our app 🙂

 

Tags: , , , ,


Scroll top
Loading
Zdjęcie w lewo Zdjęcie w prawo