EXCEL转JSON
上传 Excel 文件，按工作表转为 JSON。
关于「EXCEL转JSON」
它属于「JSON 工具」分类：JSON 的格式化、结构变换与各种数据格式互转。
完全免费、无需注册；所有处理都在浏览器本地完成，文件不会上传到任何服务器。
相关关键词：EXCEL转JSON、JSON 工具、excel、xlsx、导入、在线工具、免费
如何使用「EXCEL转JSON」
- 打开工具：打开「EXCEL转JSON」页面，无需注册、无需安装任何软件。
- 准备输入：准备好要处理的内容或文件：文本可直接粘贴，文件可拖入页面（本工具属于「JSON 工具」）。
- 填入内容：把内容粘贴进输入框，或把文件拖入页面；也可以点击「示例」先填入样例数据试一下。
- 设置选项并处理：按需调整页面上的选项，然后点击处理 / 转换 / 生成按钮。
- 获取结果：处理完全在浏览器本地完成，结果可直接复制或下载，文件不会上传到任何服务器。
常见问题
- 文件会上传到服务器吗？
- 不会。解析完全依靠浏览器端的 JavaScript 完成，文件只在当前页面的内存中存在，关闭标签页即释放。
- 日期为什么变成了数字？
- Excel 内部用序列号存储日期。勾选“保留原始值”时看到的就是这个底层数值；取消勾选即可得到格式化后的日期文本。
- 公式会被计算吗？
- 读取的是 Excel 保存时缓存的计算结果，而不是重新求值。如果公式结果未被保存，对应单元格可能为空。
- 能处理多大的文件？
- 受浏览器内存限制，一般几十兆、十万行以内没有问题。超大文件建议先在 Excel 中拆分。
Excel to JSON (English)
Upload an Excel file and convert sheets to JSON.
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: Excel to JSON, JSON Tools, excel, xlsx, import, online tool, free
How to use it
- Open the tool：Open the “Excel to JSON” 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
- Is the file uploaded to a server?
- No. Parsing runs entirely in browser JavaScript; the file lives only in the current page’s memory and is freed when you close the tab.
- Why did dates become numbers?
- Excel stores dates as serial numbers internally. With “keep raw values” you see that underlying number; otherwise you get the formatted date text.
- Are formulas evaluated?
- What is read is the cached result Excel saved, not a re-evaluation. If a formula result was not saved, the cell may be empty.
- How large a file can it handle?
- Limited by browser memory; usually tens of MB / up to ~100k rows is fine. Split very large files in Excel first.
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.
- JSON to Excel — Export an array of objects as an .xlsx workbook.
- 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.