将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中
