posts - 40,comments - 0,views - 31012

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

image-20230613120017324

posted on   吃饱饱没烦恼  阅读(11934)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 开源Multi-agent AI智能体框架aevatar.ai,欢迎大家贡献代码
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· AI技术革命,工作效率10个最佳AI工具
< 2025年3月 >
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5

点击右上角即可分享
微信分享提示