JSON转EXCEL
对象数组导出为 .xlsx 工作簿。
关于「JSON转EXCEL」
它属于「JSON 工具」分类：JSON 的格式化、结构变换与各种数据格式互转。
完全免费、无需注册；所有处理都在浏览器本地完成，文件不会上传到任何服务器。
相关关键词：JSON转EXCEL、JSON 工具、excel、xlsx、导出、在线工具、免费
如何使用「JSON转EXCEL」
- 打开工具：打开「JSON转EXCEL」页面，无需注册、无需安装任何软件。
- 准备输入：准备好要处理的内容或文件：文本可直接粘贴，文件可拖入页面（本工具属于「JSON 工具」）。
- 填入内容：把内容粘贴进输入框，或把文件拖入页面；也可以点击「示例」先填入样例数据试一下。
- 设置选项并处理：按需调整页面上的选项，然后点击处理 / 转换 / 生成按钮。
- 获取结果：处理完全在浏览器本地完成，结果可直接复制或下载，文件不会上传到任何服务器。
常见问题
- 导出的文件能用 WPS 打开吗？
- 可以。生成的是标准 .xlsx 格式，Microsoft Excel、WPS、Numbers 以及各类在线表格都能正常打开。
- 工作表名有什么限制？
- Excel 规定工作表名不能超过 31 个字符，且不能包含 <code>: \ / ? * [ ]</code> 等字符。超长部分会被自动截断。
- xlsx 和 csv 怎么选？
- xlsx 支持多工作表、列宽、数据类型等完整特性；csv 是纯文本，兼容性最好但只能存单张表且没有格式。需要再加工就选 xlsx，只是交换数据选 csv。
- 数字被显示成科学计数法怎么办？
- 这是 Excel 对长数字串的默认显示行为。如果是订单号、身份证号这类不参与运算的字段，建议在 JSON 里就用字符串类型。
JSON to Excel (English)
Export an array of objects as an .xlsx workbook.
Belongs to “JSON Tools”: Format, transform and convert JSON to and from various data formats.
Free, no sign-up; everything runs locally in your browser and files are never uploaded.
Keywords: JSON to Excel, JSON Tools, excel, xlsx, export, online tool, free
How to use it
- Open the tool：Open the “JSON to Excel” page — no sign-up and nothing to install.
- Prepare the input：Prepare the content or file to process: paste text or drop a file onto the page (this tool belongs to “JSON Tools”).
- Provide the input：Paste your content into the input box or drop a file onto the page; you can also click “Sample” to try example data first.
- Adjust options and run：Adjust the options if needed, then click the process / convert / generate button.
- Get the result：Everything runs locally in your browser; copy or download the result — your files are never uploaded.
FAQ
- Can WPS open the file?
- Yes. It is standard .xlsx, openable by Microsoft Excel, WPS, Numbers and most online sheets.
- Any limits on sheet names?
- Excel limits sheet names to 31 chars and forbids <code>: \ / ? * [ ]</code>. Longer names are auto-truncated.
- xlsx or csv?
- xlsx keeps multiple sheets, column widths and data types; csv is plain text with best compatibility but single sheet and no formatting. Use xlsx for further editing, csv for data exchange.
- Numbers show as scientific notation?
- That is Excel’s default for long digit strings. For IDs or numbers not used in math, store them as strings in the JSON.
More tools in JSON Tools
- JSON Formatter/Minifier — Beautify, minify, validate and highlight JSON.
- Sort JSON Keys — Recursively sort object keys alphabetically to ease diffing.
- Flatten JSON — Flatten nested structures into a.b.c single-level keys.
- Unflatten JSON — Restore dotted-path objects into nested structures.
- JSON to CSV — Convert an array of objects into a downloadable CSV.
- CSV to JSON — Parse CSV text or files into a JSON array.
- Excel to JSON — Upload an Excel file and convert sheets to JSON.
- JSON to XML — Convert JSON structures into well-indented XML.
- XML to JSON — Parse an XML document into an equivalent JSON object.
- JSON to YAML — Convert JSON into more readable YAML.
- YAML to JSON — Parse YAML config into standard JSON.
- JSON to SQL — Generate INSERT statements and CREATE TABLE DDL from arrays.
- SQL to JSON — Reverse-engineer JSON data from INSERT statements.
- JSON to Base64 — Convert JSON to and from Base64 with UTF-8 support.
- JSON ⇄ Cookie — Convert between Cookie strings and JSON key-values.
- JSON Diff — Recursively compare two JSON documents, marking add/delete/change.