JSON 数组转 Excel
把 JSON 数组写成 xlsx:对象数组按键的并集生成表头,二维数组原样写入,输出 xlsx 的 base64 供下载。写出逻辑在 Rust 编译的 WebAssembly 里完成。
浏览器本地运行所有计算都在你的浏览器里完成,数据不会离开本机。
JSON 数组
xlsx 的 base64
输出是 xlsx 文件的 base64,复制后解码保存即可打开。
正在加载解析模块…
粘贴 JSON 数组后开始生成 xlsx
行数: 0 · 字节: 0
这个工具能做什么
- 把接口返回的 JSON 列表导出成 Excel 发给同事。
- 把脚本产出的二维数组落成表格文件。
- 给一份数据做人工校对用的表格版本。
示例
输入
[{"name":"Ada","age":37},{"name":"Bob","age":42}]输出
UEsDBBQAAAAIAAAAIQBMKF1b/AAAAPcBAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sjdFdSsQwEAfw95wizLtNP0RlSbPssngCPUBsZ9tgkylJbOvtxa60tiA4TwPzz28YIo+T7fiAPhhyJWRJChxdRbVxTQmvL893T8BD1K7WHTks4RMDHBWTI/n30CJGPtnOhRLaGPuDEKFq0eqQUI9ust2VvNUxJOQbEXqPup4f2U7kafogrDYOGP+pWTr4/1h0vZoKL1R9WHTxhnnsdDTkQmv6AGphmZx3XnTUiklPI/clZKCYrL67UwY8lhCiByUHpRuUYlBSVOo2P2/nTtslwKTwNK5ovqL5HC4ed1a+sU61/osqVqqYs/f5jio21Jne9hST4vfhYvkyxb4AUEsDBBQAAAAIAAAAIQB8YltQqgEAAN0FAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbLWUzW7bMBCE73kKgddApJwCRRFYySFNT/0JkBTodU2uLcLkkuAytvz2hajYcYHUdlB3D9JBnJ1vhyKnt7131QoT20CtmMhGVEg6GEuLVvx8+lJ/EhVnIAMuELZigyxuby6mT5uIXPXeEbeiyzleK8W6Qw8sQ0TqvZuH5CGzDGmhIuglLFBdNc1HpQNlpFznoYcYm1z3bHaN1uu1XH8owqummahf374+lt7iohprq7HHNbWlYQCN4qaop59xDs8uV/d9Rhrn7r0T1d2INUzWCojRWQ3ZBlLDV/V38czSAfGKjPRcY6/RSe4Qs5xZgrSRHnQK9wQzh0Z6sHTIJKHjIy5/xl6/RC4TurKGOxv5cn+WHytMyRqsHiDl7+CxFap3ah3SchbCUg5rt4G/1HsAwnxuNZqgnz1SlhwTgikJ+G0Sw9T7SK91CK5oWZXX5C3KM7PuPE9JL3focXyObP/CUdqc4sp545D/744Vi5NgOkhoHnOytBiZzvnf7PU+CmOCfkghstIh4ftJtkdoUNcxhYgp2xMy2NlCjGfeExyuBIPmDZypKpfy60n6DVBLAwQUAAAACAAAACEAzJDqGOcAAABYAgAACwAAAF9yZWxzLy5yZWxzrdLPSgMxEMfxe58izL2bbQURadpLEXoTWR9gTGb/sEkmJKOmby+IqBUtgs75x5fPYTa7Grx6olwmjgZWTQuKomU3xcHAfXezvAJVBKNDz5EMHKnAbrvY3JFHmTiWcUpF1eBjMTCKpGutix0pYGk4UazB95wDSmk4DzqhnXEgvW7bS50/N+BLVB2cgXxwa1DdMdHf4jqQoENBbTnTMmVOlGWiAqrDPJAYcGxvM6fyumhq8KB/EF38XsR9P1nas30MFOU7GFWh6MidN2FKZ0mr/ySdLj401etnzvMD8/yO0Sd/sF2ot3sBUEsDBBQAAAAIAAAAIQBjc48oLQEAANgCAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJ1SXUvDMBR9368Ied+yjSEy0g5BRHxxsKnPMb1dg2kScq+l89dL261bp6KYx3OT83UjV3VpWQURjXcJn02mnIHTPjNul/Cn7d34mjMk5TJlvYOE7wH5Kh3JdfQBIhlAVpfWYcILorAUAnUBpcKJD+Dq0uY+lopw4uNO+Dw3Gm69fi/BkZhPp1cCagKXQTYOPSEfsbPTsi8r+q9A5nXjFZ+3+wDI05Zc3oRgjVZkvEs3BQA9bKQ4B7tr96CaJtbKROygFq5oWYEmHxmaD0j4nLNXhdAoJLxS0ShHB6XBm24yHByHNiDF9MXHN2z8oBQ9OCQSPzH9KmEW6ax9bhZ/4ezQNuehDvG1D7k1ZAEf87WKdMQu+5md99NmOu6hz9gvYZj6Gw8XglKcvuLJ+ydQSwMEFAAAAAgAAAAhADzITfTWAAAAiAEAABEAAABkb2NQcm9wcy9jb3JlLnhtbH2QS0sDMRSF9/0VIfvJzVQQGTrtzpWCoILbkFynwbzIvTrTfy8daTYtnu15fHB2hyUG8YOVfE6j7JWWApPNzqdplO9vj92DFMQmORNywlGekORhv9nZMthc8aXmgpU9klhiSDTYMsojcxkAyB4xGlK5YFpi+Mw1GiaV6wTF2C8zIWy1voeIbJxhA+fBrrRFuRHX+qM42yjlu4Z101nAgBETE/SqB9myjDXSzcLqwL+g6PlU8Gb7YjbUQr4F53lW890a3Wrdw8fz0+t6SOfT+VCLEvYN/AtQSwMEFAAAAAgAAAAhACSgS17iAQAA4AUAAA0AAAB4bC9zdHlsZXMueG1stVTLbtswELznKwjeY1lCWrSBlBxSGOihQYC4Ra6UtLIJLLkCuTKkfn2hl/WwA7Ro69NwdzizD1PxY21QnMB5TTaR4WYrBdiMcm0Pify+391+ksKzsrlCspDIBrx8fLiJPTcIr0cAFrVB6xN5ZC7vg8BnRzDKb6gEWxssyBnFfkPuEPjSgcp9e8lgEG23HwOjtJU3Yvbr1O5P/DuCVBQ6gy+UVQYs94o5ZS+OSv9j35Tg5UMnHhdk2YuMKsuJDIfoOTMdu5D/KU4KExlGMlilMkJygo9goNVZp60y0N99UqhTpy8YhTIam55zKd/1OigYbcnNGXEw1dpjP3anEc/dRYvuNOLKo1TM4OxOI4oBt6NKpCULK7/F7T8SOzjVhNGH9/R6PNafksvBXd9Pn1vZIhS8np3Th+NFkKlch1JiJrOO5lodyCpc1Dv3Hk9jzRkgvraP4K24XnhdCFuZneGveSK3UrQLG6FGHGAv2h8G7ziYa8/sZk7R3zmJuhiAKktsniuTgtt1L2v1t16Kh3f/Uz2K/p16P8S3xfy6kV5f1jkt2iecyOdWD2deaaWRtX1vUaNNXk87mnisUoSl+1aKHApVIe/PyURO+BvkujKfz6wXfSIeWBPuWXetURxMn+SpsV9QSwMEFAAAAAgAAAAhAEF5QWKIAAAApwAAABQAAAB4bC9zaGFyZWRTdHJpbmdzLnhtbDXHMQ7CMAwAwJ1XWN5pAgNCqGkHJF4AD4ha00ZK7BK7qPyeBW67tt9KhjdVTcIBD41HIB5kTDwFfNxv+zOCWuQxZmEK+CHFvtvBT6tqsJXMGnA2Wy7O6TBTidrIQryV/JRaomkjdXK6VIqjzkRWsjt6f3IlJkYYZGUL6BFWTq+Vrv93rVO17gtQSwMEFAAAAAgAAAAhAGFsJfHWAAAAUQEAAA8AAAB4bC93b3JrYm9vay54bWyNjsFOxDAMRO/9Cst3mhYQgqrpXlZIe+MAH2AadxttEldxgPL3iO2yZ04jeTxvpt+tMcAnZ/WSLLZ1g8BpFOfT0eLb6/PNI4IWSo6CJLb4zYq7oeq/JJ/eRU6wxpDU4lzK0hmj48yRtJaF0xrDJDlS0Vry0eiSmZzOzCUGc9s0DyaST7gRuvwfhkyTH3kv40fkVDZI5kDFS9LZL4pDBQBwnfeSwVHh9qm5tzhRUEZzeTkv0WFTSBTZ4p4KIZwvB2exRciddxbzwd1dg+aSrHrzV7M5v+4PUEsDBBQAAAAIAAAAIQC6wuVcfQAAAJEAAAAQAAAAeGwvY2FsY0NoYWluLnhtbD3MQQ7CIBAAwLuvIHsXqgdjDLQHE1+gD9jQtZCwC2GJqb/35jxg/LJzMR/qmqsEONkJDEmsa5YtwOv5OF7B6EBZsVShAF9SWOaDj1jiPWEWs3MRDZDGaDfnNCZiVFsbyc7lXTvjUFv75rR1wlUT0eDiztN0cYxZYPbuv80/UEsDBBQAAAAIAAAAIQCC6D5n8AAAAM4CAAAaAAAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHOtks9KxEAMxu8+xZC7nXYVEdlxLyLsVesDDG3aGXb+MYnavr2w626rVPDQXEK+w5cfX7LdDd6JD8xkY1BQFSUIDE1sbegVvNXP1/cgiHVotYsBFYxIsHu82r6g02xjIGMTicG7QAoMc3qQkhqDXlMRE4bBuy5mr5mKmHuZdHPQPcpNWd7JPPeAX6Zi3yrI+7YCUY8J/2Meu842+BSbd4+BF3ZINugRRK1zj6zgOJ7Eqhi8A/kHxGZNCOLRIU0Up/m8X3zXIsfNmhyfMR/IIPKEcpFIHts5lUWY21VDMTpj+8rZhn6ezVy+nEj++L4psy9QSwMEFAAAAAgAAAAhAK20q+fTBgAAajYAABMAAAB4bC90aGVtZS90aGVtZTEueG1s7VtPb9s2FL/3UxC8t/6fJkHUInaSdmvSBonbocdniZbYUKRA0kl8G9rjgAHDumGXAbvtMGwr0AK7dJ+mW4etA/oVBlq2K8mSzLSZmzbJIYApvt97fP/5ZK9dPw4ZOiRSUcEdXLtSxYhwV3iU+w6+2926vIyR0sA9YIITBw+JwtevXVqDVR2QkKDjkHG1Cg4OtI5WKxXlBiQEdUVEhB+HrC9kCFpdEdKveBKOKPdDVqlXq0uVECjHiENIHHyn36cuQV0Dia9dQgihCYdNRkLCtYpXx09cJvcNI5KiH1Mm9nkHtfTaeF0NVYdJdAjMwUeUe+KoS441RgyU7jDp4OroD1cyiJUcyDVYZdqWTYLF1ugvj8UM3Ogk9XwW0u9NedS2mitXN/KlrudIbQG5ubnZ2azlSzkLCa5LeJEykrDNreVaO1fSXIgptIXEnWqr2iyBLpK6MR96pd1ut1aKoRsF0M350MvVpeZ6vRi6WQDdstB1e73TWSqGbhVAL82H3rq6stQsgc5ArMFqwCg/mA9soi8/OHIA1mC1L9hNO+TlarW6nBvZsxhmdZpqUgmoL7i2ykAhPBByS3CdKxkDTTnSw4j0wSUO7kDYkxSy0o13E0hsLdjjqvl7jPBIuZJG2sGfRsBxgub1859fP3+KXj9/8uLhsxcPf3vx6NGLh7/aIN0E7ieRXv341b/ff47+efrDq8ffWAKoJMCfv3zxx+9fW1LqJOXLb5/89ezJy+++/Punxzb06xJ6SfouDYlCt8kR2hMhcCsRSE++I0Q3AJqCgECEYEO5qYMU5e0hMCvCNknb7J6k3LOivDF4kDrvfiAHmtpQ3grCFOWOEKwtpJ2ObhnxkjoacN9SXjlIEu4BHFqJ28l45eYgCkhYGKRp2oCkjrrLgGvwCScamWfigBAbnPuUpuy7Q10plOhrdJ+iNlA7xXdpT+ej3KQhMBhanakbQMoCO/dQWzArATbIYZoUuA/MiilhKevdgIGG0O7UELIk6TbowOqg+0PppgyvtATuEybQpkeUsgK5I4epI98CRi09docNwzSp1PTAinQbhEiSboiDTgBhZHduyoMk8SfqQAgGaFdoO7lFOqeYz4JR4Paeeo8S/Y7J9C71g3xnN08G0ipnEJHOcUPWBzLD3rQJBXXedACUn6gDYLQni5R00QEsqgNYl9QuM2XrvjXhOa32GzDgu4QHF8W+SGMXxf6i2J/nYm+dQRdd4mcLeTw2mIwC0hOC0G5A0KeM7eshI9sqv0NQglFvizI2+3SyY8RnOuGIgg7LP3ulFG0NVn0Jo4dICv0Z1cF+ABFxcC0jdpJC5cqd2oEioRxcLQCZd5ByqjGlplzHRK28wW0RP9A7wovpGrkT31wVTqQsOXbFnNtKLQ0j8GJU07j6YammFvNdiG5qrbfUTWtBuomfFQabuUpQjsC8tqkt1WPNIeUCI54J4IJ0MAn4jzUbjF3I0q4BeORt6BL+UGt8/LHSWrBOP4wYq54sxkatQ2HtN6x4aVvAODpy8Eqr3sLIhcjBfQYaIzeMPAcr05QB87mDXV1k3/m9xdv7TNryKzbJNRtI1XlEFgaf0/GM2UZS6Q1QQcx4tL/IloyXGKPeahqHeB/WqJyF8zeWa+ft/PFaYQyTfp+4ujSOE1sKBYz3zCutYqCJ3A+8I9RjA7kHnoObcYryqNIOrk8+SAcbTx19Spd2mwKSfU07t+qMCYFFAYwT+rJtPo+ZleeA6bmLfaBEgW8eF9hgsTZqnBkbWeXsCxtd2Cjtei7hpOGVBoELIZGATNp1sJA6EL6EKKDulhRcz3dvKTRioE0oIGa+tmZihBwWtGBJX405lwrHqB/oPeojSX0H60ASsqvHEfkustXG/eIcCSfsS+pZmYaNBaI56u+RQ8K6pmAvmSDHKJi0LmVVNBe1NHlmHubVx55vCvPF+Ov07mbNs37Hytxbm4u7tjZPMuJJXF5WPiyN/v+TgIRy4p7y5Mqpt1pn5UofgQ6Q+edgl0qXZWf0me3mzt4Ve8TVaDoKQdrBl01Pa5L9dLHn4Fq8WJJXDePzOZorVc25nEYn4spqipgXV4tSzsLiqpUTVq3TjirzpKgXGQ3qJi/z4mWzlPPjBHO/6z0grt4gfRiwzG8WVLRB+jMdkIp2ZfZdI6z2hDfMW2cq7qVmn6jCyyvje6SPqHdcmh4yXjv+Fn7xGGQve5aEGaf8GqfFb4xacjmf8qyfFs8pbv45BX/Dc/Rm2JovKzlnjDrrnBnzxh15yp9Gln7vHlZfsIdV34OH1c68h+njU/GwhD+N5mw5uc1o51hL6Ex+JbGtdOXapWmCfAP4H1BLAQIuAxQAAAAIAAAAIQBMKF1b/AAAAPcBAAAYAAAAAAAAAAAAAACkgQAAAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWxQSwECLgMUAAAACAAAACEAfGJbUKoBAADdBQAAEwAAAAAAAAAAAAAApIEyAQAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQIuAxQAAAAIAAAAIQDMkOoY5wAAAFgCAAALAAAAAAAAAAAAAACkgQ0DAABfcmVscy8ucmVsc1BLAQIuAxQAAAAIAAAAIQBjc48oLQEAANgCAAAQAAAAAAAAAAAAAACkgR0EAABkb2NQcm9wcy9hcHAueG1sUEsBAi4DFAAAAAgAAAAhADzITfTWAAAAiAEAABEAAAAAAAAAAAAAAKSBeAUAAGRvY1Byb3BzL2NvcmUueG1sUEsBAi4DFAAAAAgAAAAhACSgS17iAQAA4AUAAA0AAAAAAAAAAAAAAKSBfQYAAHhsL3N0eWxlcy54bWxQSwECLgMUAAAACAAAACEAQXlBYogAAACnAAAAFAAAAAAAAAAAAAAApIGKCAAAeGwvc2hhcmVkU3RyaW5ncy54bWxQSwECLgMUAAAACAAAACEAYWwl8dYAAABRAQAADwAAAAAAAAAAAAAApIFECQAAeGwvd29ya2Jvb2sueG1sUEsBAi4DFAAAAAgAAAAhALrC5Vx9AAAAkQAAABAAAAAAAAAAAAAAAKSBRwoAAHhsL2NhbGNDaGFpbi54bWxQSwECLgMUAAAACAAAACEAgug+Z/AAAADOAgAAGgAAAAAAAAAAAAAApIHyCgAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHNQSwECLgMUAAAACAAAACEArbSr59MGAABqNgAAEwAAAAAAAAAAAAAApIEaDAAAeGwvdGhlbWUvdGhlbWUxLnhtbFBLBQYAAAAACwALAL4CAAAeEwAAAAA=
输出是 xlsx 的 base64;页面里复制后解码保存成 .xlsx 即可用 Excel 打开。
常见问题
对象数组的列是怎么定的?
按所有对象键的并集,顺序是键第一次出现的顺序;某个对象缺的键写成空格。
能写公式或样式吗?
不能。写入的是纯值(数字、布尔、文本),没有公式、样式、合并单元格与列宽。
空数组会怎样?
会写出一个只有一张空表的合法 xlsx,行数是 0。
数字会变文本吗?
不会。JSON number 写成数字单元格,读回来是 37.0 这种浮点值。
关键词:json转excelarr2excel数组转xlsx导出excelwasm