This website has many other features, including output formats like CSV, XML, and HTML. You can input the URL of your JSON file or directly upload it from your local machine, and you’ll be able to download a text file or an Excel document. So, when working with big data in Gigasheet, you do not have to write a single line of code or set up a database. CDKM is a free site that will convert JSON files into Excel documents. Gigasheet is a no-code big data worksheet. Gigasheet, by default, supports ZIP format, so you can directly upload compressed JSON files without having to un-compress them first. Often JSON files are too large, and users compress them to ZIP format to save storage. Gigasheet, on the other hand, has no such constraints so you can process large multi-gigabyte JSON files.

Gigasheet allows you to upload files from different sources - local storage or the cloud storage services like Google Drive, Dropbox, SFTP, and AWS S3.Įven though MS Excel is easily accessible on modern PCs, it cannot process more than 1,048,576 rows of data. There are some other very significant advantages of using Gigasheet over other options.įirst of all, Gigasheet is a web application that you can access from the web browser on your PC, laptop, and even a mobile device.

function main(workbook: ExcelScript.Comparing the processes above shows that using Gigasheet to convert JSON to CSV for Excel is much easier than the other two, especially if the file is large or if you aren't intimately familiar with the data structure. For more information about working with JSON, read Use JSON to pass data to and from Office Scripts. Note that for column names with spaces, be sure to place your key in quotation marks, such as with 'Event ID' in the sample. Hope this can save someone else some time. You can change the interface TableData structure to match your table columns. Went through a couple of solutions, this is the one that worked best for me.

Load json into excel