如何把json轉化為Exceljson2excel

JSON是碼農們常用的數據格式，輕且方便，而直接手敲JSON卻是比較麻煩和令人心情崩潰的（因為重復的東西很多），并且現在很多普通用戶也需要把json轉excel，比如導出的微信數據==，所以很多碼農可能會和我一樣，選擇用Excel去輸入數據，然后再想辦法轉換成JSON格式。小編今天推薦使用Excel直接另存為JSON的方法。

該方法的特點是：除可以正常的直接按照表頭作為key,內容作為value輸出之外，還可以根據指定的規則(schema)輸出JSON，如可以將ID相同的輸出到一組，如將年齡相同的人放到一組等等。

今天給大家推薦一個在線的json轉excel的工具簡單快捷,一鍵使用。

在線工具地址:http://www.yzcopen.com/doc/jsonexcel
如圖:第一步

第二步驟：把需要轉換的json數據粘貼復制到文本框中

[
{"id":"1","name":"基神","age":"18"},
{"id":"2","name":"B神","age":"18"},
{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},{"id":"2","name":"B神","age":"18"},
{"id":"3","name":"曹神","age":"18"}
]

第三步轉換即可：

接下來就解析成功了下載結果即可：

此時json已經轉成excel文件了