使用指南User Guide

快速开始Quick Start

1. 打开工具页Open the Tools page

   点击顶部"在线工具"，或用上方按钮直接进入 解析页。

   Click "Tools" in the top bar, or jump straight to the Parse page.

2. 导入数据Load your data

   拖放或点击选择 CSV/TSV/Excel 文件，也可以直接粘贴 CSV 文本；支持自动编码检测。

   Drag & drop or pick a CSV/TSV/Excel file, or paste CSV text directly. Auto encoding detection is supported.

3. 在预览中处理Work in the preview

   左侧模块可对表格执行清洗、列操作、统计、过滤等，全部实时生效并可撤销（最多 50 步）。重复性的处理可以用「操作配方」录制后一键重放。

   Use the modules on the left to clean, edit columns, compute stats, or filter — all live and undoable (up to 50 steps). Repeatable workflows can be recorded as Recipes for one-click replay.

4. 导出结果Export your result

   在"转换"页面选择目标格式（CSV/JSON/Excel/XML/SQL 等）一键下载，或直接复制文本；复杂查询可以切换到「SQL 查询」按需取数。

   On the Convert page, choose a target format (CSV/JSON/Excel/XML/SQL...) and download — or copy the text directly. For more complex queries, switch to "SQL Query" and pull just what you need.

按模块使用Module-by-module

• CSV 解析预览：导入、预览、分页浏览、双击单元格编辑、批量复制/删除。Parse & Preview: import, preview, paginated browse, double-click cells to edit, batch copy/delete.
• 转换：CSV ⇄ JSON / Excel / XML / SQL / Markdown / HTML。中文列名自动安全转换。Convert: CSV ⇄ JSON/Excel/XML/SQL/Markdown/HTML with safe handling of Chinese column names.
• 清洗：去重、空值处理、去空格、批量替换、正则替换、数据校验、脱敏。Clean: dedupe, null handling, trim, batch & regex replace, validation and masking.
• 列操作：重命名、增加/删除、拆分/合并、转置、正则提取；通过「计算列」可用 30+ 函数（数学/文本/日期/聚合）构造新列。Columns: rename, add/delete, split/merge, transpose and regex extract; compute new columns with 30+ functions (math/text/date/aggregate) via a safe formula evaluator.
• 统计图表：选中列生成分布、聚合、透视式汇总，并输出柱状/饼/折线/散点图与 CSV。Stats & Charts: per-column profiles, aggregations and bar/pie/line/scatter charts with CSV export.
• 合并拆分：多文件合并；按行数/列拆分，支持 ZIP 打包下载。Merge & Split: merge multiple files; split by rows/columns and download as ZIP.
• 搜索过滤：多条件（等于/包含/区间/正则）组合过滤，结果一键导出。Search & Filter: combine conditions (equals/contains/range/regex) and export results.
• 编码转换：GBK / Big5 / Shift_JIS / EUC-KR / UTF-8 互转，自动检测修复乱码。Encoding: convert between GBK/Big5/Shift_JIS/EUC-KR/UTF-8 and auto-detect garbled files.
• 文本工具：大小写、去首尾空格、替换空值、slug/ROT13/去前导零等逐单元格文本处理。Text: per-cell transforms such as case conversion, trim, null replace, slug/ROT13/leading-zero removal.
• 模拟数据：按列配置模板一键生成随机测试数据，适合演示与测试。Generate: create random test data from column templates — great for demos and testing.
• 数据对比：以当前数据为基准，上传另一份 CSV，按主键对比新增/删除/变更行；可设数值容差、忽略大小写/首尾空格、忽略某些列，必要时交换基准与目标。Diff: compare against another CSV by key column to spot added, removed and changed rows — with numeric tolerance, case/space ignore, ignored columns and direction swap.
• 透视表：行/列维度 + 聚合方式交叉汇总为统计矩阵；可切「原始值 / 占行合计% / 占列合计% / 占总计%」用于结构分析，可导出或载回（载回始终用原始数值）。Pivot: cross-tabulate rows with row/column dimensions and aggregations; toggle the display between raw values and % of row / % of column / % of grand total for structural analysis. Loaded-back results always use raw values.
• 多列排序：添加一个或多个排序键（列 + 升/降序 + 智能/自然排序/拼音/仅数值 + 空值置顶置底），先预览后执行并导出。Sort: add multiple sort keys (column + asc/desc, mode smart/natural/pinyin/numeric, nulls first/last), preview, then apply and export.
• 操作配方：把重复性的处理动作（去重/清洗/排序/列操作等）录制为一条「配方」，保存后可一键重放，适合周报、月报等模板化场景。Recipes: record a repeatable chain of operations (dedupe, clean, sort, column ops, ...) as a recipe and replay it with one click — great for recurring weekly or monthly workflows.
• SQL 查询：当前数据会自动注册成表 data，直接写 SQL（SELECT / WHERE / GROUP BY / JOIN / 聚合 / 窗口函数等），结果可导出或载回继续处理。SQL Query: your current data is registered as a table named data — write SQL (SELECT/WHERE/GROUP BY/JOIN/aggregates/window functions) and export or load results back.

快捷键Keyboard shortcuts

工具页内置常用快捷键（撤销 / 重做 / 全选 / 复制 / 粘贴 / 删除行列 / 主题切换等）。进入 工具页 后，点击右上角「快捷键帮助」按钮可查看完整快捷键列表。

The tools page ships useful shortcuts (undo/redo, select all, copy/paste, delete row/column, theme toggle, etc.). Open the "Shortcuts help" button in the tools page for the full list.

数据安全与隐私Data safety & privacy

• 纯本地处理：全部功能在您的浏览器中运行，文件不上传服务器。
• Fully local: everything runs in your browser; files are never uploaded.
• 断网可用：页面加载后即使断开网络，已导入数据仍可继续处理。
• Offline friendly: once loaded, you can keep working even after going offline.
• 可撤销：最多 50 步历史，误操作随时回退，放心尝试。
• Undoable: up to 50 steps of history so you can experiment freely.

更多帮助More help

仍有疑问？先看看常见问题，或通过关于我们页面的邮箱联系团队。

Still stuck? Check the FAQ, or reach out via the email on the About page.