Here are 3 free Excel to JSON converter software for Windows. These software take an Excel file from you and then they convert that to a JSON file easily. You can use these software to convert any XLS or XLSX file to JSON in an easy way. Most of these software create a formatted JSON file that you can use or open in any JSON viewer software. You will find some GUI based and tools having command line interface in the following list.
Mainly in development, there is a need of converting Excel data to JSON. Or, there can be other times when you need the Excel data as JSON. In that case, the software I have listed below will help you. All the software I have listed are very simple and offer a very straightforward way of converting Excel files to JSON. There are some command line tools as well that you can use if you use command line tools often. Also, if you want, you can try out some Excel To Json converter websites if you don’t need a software on your PC.
3 Free Excel to JSON Converter for Windows, Convert XLS, XLSX to JSON:
Excel2Json is one of the best free software for Windows to convert Excel to JSON. It supports both Excel file formats; XLS and XLSX. After taking a file form you it extracts the Excel data, convert that to JSON format and then finally save that as a JSON file. This is an open source and portable software to do that. However, it doesn’t format the output JSON data. But, if you want to beautify the JSON data, you can use some code beautifier software to do that.
Grab Excel2Json as a ZIP file from above link and then extract its contents to anywhere on your PC. After that, you will find the executable file of the software in the “Excel2Json-master\bin\Debug” folder. Simply open it up and the interface of the software will show up. Now, specify the target Excel file that you want to convert to JSON and then click “Convert to JSON” button. It will save the final JSON file in the same folder where its EXE is. And it gives the sheet name to the JSON file that it creates.
Exceltk is actually a command line tool that you can use to convert Excel to JSON. It takes either a XLS file or XLSX file form you and then exports that as a JSON file. It generates a formatted JSON file that you can save to any location you want. All you have to do is just run a simple command in order to carry out Excel to JSON conversion. And this is a dedicated tool for Windows. To run this tool on your PC, you don’t need any third party dependency.
Here are the steps to convert Excel to JSON.
Step 1: Download the EXE file of this tool from here and then copy it to the folder which contain the Excel file you want to convert to JSON.
Step 2: Now, open command prompt in the same folder. After that, run the command in the specified format.
exceltk.exe -t json -xls "name ofthe excel file"
After running the above command, it will save the converted Excel file as JSON in the current working directory.
This way, you can use this handy command line tool to easily convert any Excel file to JSON.
xlsx-to-json is another command line tool in Python that you can use to easily convert Excel to JSON. It lets you specify an Excel file or path to the Excel file and then saves the corresponding JSON file in the same folder. It supports both the Excel file formats; XLS and XLSX. And the best part is that the final JSON file that it creates is beautifully formatted. You won’t have to further beautify that.
This tool is entirely written in Python and depends on some other dependencies. So, if you have Python installed on your PC, then you can start using it. And the below steps will help you.
Step 1: Download the ZIP file of the tool from here. After that, extract the file somewhere on your PC. Now, go the folder where you have extracted the contents of the ZIP file of xlsx-to-json. And make sure that the “xlstojson.py” is visible. Open command prompt window there and then run these commands one after another.
pip install xlrd or pip2.7 install xlrd
pip install xlwt or pip2.7 install xlwt
Step 2: After the above commands complete successfully, you can run this main command. It will ask you to specify path to the Excel file that you want to convert to JSON. So, specify the path to the Excel file and it will save the corresponding JSON file in the same folder where the Excel file is.
In this way, you can use this command line tool to easily convert an Excel file to JSON. And the software that I have listed above are very good to handle the Excel to JSON conversion.
These are the only free software and tools that I could find to convert Excel to JSON. All the tools that I have mentioned work perfectly when it comes to convert XLS or XLSX files to JSON. I have added some command line tools as well that you can use to batch convert Excel to JSON through a batch file. So, if you are looking for some free Excel to JSON converter, then the above listed tools will be helpful. Also, if you know some other free Excel to JSON converter software, then you can tell me.