Gjson - JSON & Excel Tool
Extension Actions
A powerful JSON tool with advanced Excel export. Format, compress, and convert JSON to Excel with custom column mapping.
gexcel 是一款功能强大的 JSON 在线处理与 Excel 导出工具,以 Chrome 扩展的形式运行,无需安装任何软件,打开即用。
### 核心功能
JSON 编辑与处理
- 基于 Monaco Editor(VS Code 同款编辑器)的专业 JSON 编辑器,支持语法高亮、代码折叠、错误提示
- 一键格式化 / 压缩 / 转义 / 去转义
- 实时 JSON 语法校验,格式错误即时提醒
- 右侧交互式树状结构视图,直观查看 JSON 层级
- 支持左右/上下分屏布局切换,可自由拖拽调整面板大小
- 亮色/暗色主题切换
- 一键下载 JSON 文件
JSON 转 Excel 导出
- 深度解析复杂嵌套 JSON 结构,自动展开数组为多行数据
- 智能合并数组中所有对象的 Key(不只看第一条数据)
- 可视化字段选择面板,树状缩进显示,支持父子节点级联勾选
- 自定义 Excel 表头名称,随心映射字段名
- 拖拽调整字段顺序,整组拖拽不打散
- 填充/不填充模式:控制父级字段是否在每行重复显示
- 大整数自动转文本,避免 Excel 科学计数法显示
- 纯前端导出,数据不上传,保护隐私
### 适用场景
- 后端接口调试,快速格式化查看 JSON 响应
- 将 API 返回的 JSON 数据批量转为 Excel 报表
- 日志分析,把 JSON 格式日志转为表格便于筛选
- 数据清洗,从复杂嵌套 JSON 中提取所需字段
### 隐私说明
gexcel 完全在本地浏览器运行,不收集、不上传任何用户数据。零权限申请,安心使用。
---
## English Description
gexcel is a powerful JSON processing and Excel export tool that runs as a Chrome extension — no software installation required, open and use instantly.
### Key Features
JSON Editing & Processing
- Professional JSON editor powered by Monaco Editor (same as VS Code) with syntax highlighting, code folding, and error hints
- One-click format / compress / escape / unescape
- Real-time JSON validation with instant error feedback
- Interactive tree view for intuitive JSON structure exploration
- Switchable side-by-side or top-bottom split layout with resizable panels
- Light / Dark theme toggle
- One-click JSON file download
JSON to Excel Export
- Deep parsing of complex nested JSON structures, automatically expanding arrays into multiple rows
- Intelligently merges all keys across array elements (not just the first item)
- Visual field selection panel with tree-style indentation and parent-child cascading checkboxes
- Custom Excel header names — freely rename columns during export
- Drag-and-drop field reordering with group-aware movement
- Fill / No-fill mode: control whether parent-level values repeat on every row
- Large integers auto-converted to text to prevent Excel scientific notation
- 100% client-side export — your data never leaves your browser
### Use Cases
- API debugging: quickly format and inspect JSON responses
- Data reporting: convert API JSON responses into Excel spreadsheets in bulk
- Log analysis: transform JSON-formatted logs into filterable tables
- Data extraction: pick specific fields from deeply nested JSON structures
### Privacy
gexcel runs entirely in your local browser. No data is collected or uploaded. Zero permissions required.