A excel with VBA that able to export content to json and a C# enum class file
This is a sample project, download the “ExcelToJson.xlsm” and enable the macro, when u change the content and save the excel,it’ll be export json files.
Each sheet will be exported as a json file which’s name is the sheet name.
Still, it will export a .cs file with all enum,so you can use the enum in Unity.
PS:There’s no error check in this excel,make sure you fill the right content
This excel only generate “ANSI” encoding file,if you want “UTF-8″format, try “AnsiToUtf8.py”