将excel格式的文件（csv、xls）转成json

最新推荐文章于 2024-08-12 14:09:57 发布

maomaoxmz

最新推荐文章于 2024-08-12 14:09:57 发布

阅读量2.3k

点赞数

分类专栏： JSON

本文链接：https://blog.csdn.net/maomaoxmz/article/details/80915220

版权

JSON 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

本文介绍了如何将Excel文件（csv、xls）转换为JSON格式，并提供了在线工具进行转换和校验，最后展示了如何对生成的JSON进行压缩。

摘要由CSDN通过智能技术生成

1. 将csv里面的文字复制粘贴到

网址：https://www.bejson.com/json/col2json/

结果如下：

id   name
Free Size   Free Size
XXS   XXS
XS   XS
S   S
M   M
L   L
XL   XL
XXL   XXL
XXXL   XXXL
XXXXL   XXXXL
Special Body   Special Body

-------------------------> 转成：

[
{"id":"Free Size","name":"Free Size"},
{"id":"XXS","name":"XXS"},
{"id":"XS","name":"XS"},
{"id":"S","name":"S"},
{"id":"M","name":"M"},
{"id":"L","name":"L"},
{"id":"XL","name":"XL"},
{"id":"XXL","name":"XXL"},
{"id":"XXXL","name":"XXXL"},
{"id":"XXXXL","name":"XXXXL"},
{"id":"Special Body","name":"Special Body"},

]

2. 转化后，进行校验

网址：https://www.bejson.com/

一般校验会出现问题：因为后面多个逗号

结果如下：

[{

       "id": "Free Size",
       "name": "Free Size"
   },
   {
       "id": "XXS",
       "name": "XXS"
   },
   {
       "id": "XS",
       "name": "XS"
   },
   {
       "id": "S",
       "name": "S"
   },
   {
       "id": "M",
       "name": "M"
   },
   {
       "id": "L",
       "name": "L"
   },
   {
       "id": "XL",
       "name": "XL"
   },
   {
       "id": "XXL",
       "name": "XXL"
   },
   {
       "id": "XXXL",
       "name": "XXXL"
   },
   {
       "id": "XXXXL",
       "name": "XXXXL"
   },
   {
       "id": "Special Body",
       "name": "Special Body"
   }   --------------------------------------这里无逗号

]

3. 对json进行压缩

网址：https://www.bejson.com/zhuanyi/

结果如下：

[{"id":"Free Size","name":"Free Size"},{"id":"XXS","name":"XXS"},{"id":"XS","name":"XS"},{"id":"S","name":"S"},{"id":"M","name":"M"},{"id":"L","name":"L"},{"id":"XL","name":"XL"},{"id":"XXL","name":"XXL"},{"id":"XXXL","name":"XXXL"},{"id":"XXXXL","name":"XXXXL"},{"id":"Special Body","name":"Special Body"}]