有哪些方法可以將JSON格式的數(shù)據(jù)集轉(zhuǎn)化為EXCEL格式？

如何把json轉(zhuǎn)化為Excel json2excel

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

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

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

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

第二步驟：把需要轉(zhuǎn)換的json數(shù)據(jù)粘貼復(fù)制到文本框中

[ { "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" }]

第三步轉(zhuǎn)換即可：

接下來就解析成功了下載結(jié)果即可：

此時json已經(jīng)轉(zhuǎn)成excel文件了