json2xls : Extract JSON arrays and export them to Excel XLS files, or just copy individual entries and paste them in other text editors, with this useful tool
json2xls is a straightforward application that, as its name suggests, can help you convert JSON data arrays to the XLS spreadsheet format. The program is relatively easy to use, as it supports drag and drop and allows you to select between the multiple arrays that may be found in a single JSON file.
Lightweight, portable utility that does not require Microsoft Excel
json2xls does not need to be installed, which means that it can be run from any location, even portable storage devices.Moreover, aside from Microsoft .Net Framework, it does not require any other additional components to be installed on your system.
Straightforward conversion tool that can extract JSON arrays
Importing documents into json2xls could not be simpler, as you only have to drag them to the main application window. If a JSON file contains multiple arrays, a dialogue box is displayed asking you to choose which of them should be processed.If you wish to export the entire data set to a spreadsheet file, you can click the XLS button in the top-left corner of the interface. The new document is exported to the application’s folder, but it is not possible to change the output location or the file’s name.In addition, it is possible to copy specific rows and paste them into Microsoft Excel, which can be very helpful when you only need to extract a few entries.
Minimalistic user interface that keeps things simple
While json2xls may not stand out from a visual standpoint, this is not really to be expected from a basic converter. The window is resizable, the rows are displayed using alternating colors and the entries can be sorted based on any of the available columns.Overall, json2xls is a simple tool designed for a specific purpose, and it does its job well. It enables you to convert JSON arrays to XLS, as well as extract individual entries, and it does not require Microsoft Excel.
json2xls runs on
Windows 10/11
and is available under the
Freeware
license
— the installer is 175 KB.
We’ve catalogued it under
General.
Help fellow users decide. Share your experience with json2xls.