将JSON数据导入Excel中
1、将在浏览器中的JSON数据复制出来,在桌面或者其他位置创建一个文本文件,将JSON数据粘贴进去,并将文件名的后缀改为.JSON格式,例如JSON.JSON
{
"students": [
{
"name": "John Doe",
"math": 90,
"science": 85,
"english": 92
},
{
"name": "Jane Smith",
"math": 95,
"science": 88,
"english": 91
},
{
"name": "Mike Johnson",
"math": 85,
"science": 92,
"english": 89
},
{
"name": "Emily Brown",
"math": 88,
"science": 90,
"english": 93
},
{
"name": "David Wilson",
"math": 82,
"science": 87,
"english": 90
},
{
"name": "Sarah Davis",
"math": 91,
"science": 89,
"english": 94
},
{
"name": "Daniel Martinez",
"math": 94,
"science": 92,
"english": 86
},
{
"name": "Olivia Anderson",
"math": 87,
"science": 91,
"english": 88
},
{
"name": "Michael Thomas",
"math": 90,
"science": 93,
"english": 85
},
{
"name": "Sophia Taylor",
"math": 95,
"science": 85,
"english": 92
},
{
"name": "Christopher Clark",
"math": 89,
"science": 88,
"english": 91
},
{
"name": "Ava Rodriguez",
"math": 93,
"science": 92,
"english": 89
},
{
"name": "Matthew Turner",
"math": 86,
"science": 90,
"english": 93
},
{
"name": "Isabella Walker",
"math": 91,
"science": 87,
"english": 90
},
{
"name": "James Hill",
"math": 89,
"science": 91,
"english": 94
},
{
"name": "Grace Lopez",
"math": 90,
"science": 94,
"english": 92
},
{
"name": "Benjamin Green",
"math": 92,
"science": 86,
"english": 89
},
{
"name": "Chloe Hall",
"math": 87,
"science": 90,
"english": 88
},
{
"name": "Logan Young",
"math": 88,
"science": 92,
"english": 85
},
{
"name": "Emma King",
"math": 94,
"science": 89,
"english": 93
},
{
"name": "Jacob Baker",
"math": 85,
"science": 91,
"english": 90
}
]
}
这里我用的是visual studio code打开文件,这个文件也可以用记事本打开粘贴即可。
2、创建一个新Excel文件
3、在数据选项卡-获取数据-来自文件-从JSON
4、选择对应的JSON文件后,点击转到表中
5、选择value,选择扩展到新行中
6、再选择value,取消使用原列名作为前缀,点击确认
7、点击关闭并上载
8、成功将JSON数据导入到Excel中