使用excel自带的函数就能将数据生成json,最后再手动处理一下最好
="{""tag"":"""&A1&""",""name"":"""&D1&""",""type"":"""&C1&""",""input"":""text"",""level"":""高"",""score"":""70"",""value"":"""&E1&""",""status"":""已启用""},"
将代码放到G1然后扩展
自定义列然后选中G列直接复制到sublime在手动处理一下最后的一个逗号就行