Full description of the file
Download VBA script to convert spreadsheet from Excel to JSON (Export Excel to JSON)
Today in this set, for you dear users, we have prepared a VBA script for converting a table from Excel to JSON (Export Excel to JSON) for download.
Sample image at runtime
Instructions for use:
Replace the example data with your own data, as many columns and rows as you need. Then click the button and the file will be saved in the same folder as the "Excel to JSON.xlsm" file. (You can also delete the button and access the script via: Developer Bar> Macros> exportJSON, and the file name, folder, etc. can be changed in the script.
Just copy the code ("ExcelToJSON.bas") to your Excel (as a VBA module), make sure your Excel is stored where you want the output to be saved.
Dear user, you are offered a download