将JSON数据导入Excel中

2023-12-15 02:42| 来源: 网络整理| 查看: 265

将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 } ] }