In Excel, you can load add-ins published in Microsoft Appsource, there is one add-in called "excel to json" can meet your requirement, it can handle simple and complex json files, like nested or multilayer json.