将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中
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 开源Multi-agent AI智能体框架aevatar.ai,欢迎大家贡献代码
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· AI技术革命,工作效率10个最佳AI工具