将JSON数据导入Excel中

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