365Lab CSV 工具箱365Lab CSV Toolkit

上传 CSV/TSV 文件在线预览，支持大文件流式解析、单元格编辑、批量操作与分页浏览。

Upload and preview CSV/TSV files with streaming for large files, inline editing, batch actions and pagination.

CSV ⇄ JSON / Excel / XML / SQL / Markdown / HTML 互相转换。

Convert between CSV, JSON, Excel, XML, SQL, Markdown and HTML.

去重、空值处理、去空格、批量替换、数据校验，让数据更干净。

Deduplicate, handle nulls, trim spaces, batch replace and validate your data.

添加 / 删除 / 重命名 / 拆分 / 合并 / 排序 / 计算 / 转置列。

Add, delete, rename, split, merge, sort, compute and transpose columns.

列概要分析、聚合统计、柱状 / 饼 / 折线 / 散点图，支持导出图表与 CSV。

Column profiles, aggregations, bar/pie/line/scatter charts with CSV and image export.

合并多个 CSV 文件，或按行数 / 列拆分，并支持打包下载 ZIP。

Merge multiple CSV files, or split by rows/columns and download as ZIP.

多条件组合过滤、全局搜索、过滤结果一键导出。

Multi-condition filtering, global search and one-click export of filtered results.

UTF-8 / GBK / Big5 / Shift_JIS / EUC-KR 等互转，自动检测乱码。

Convert between UTF-8, GBK, Big5, Shift_JIS, EUC-KR and more, with auto-detection.

列值大小写与空白快速转换，CSV/TSV 互转，行序打乱与反转整理。

Case and whitespace transforms, CSV/TSV swap, shuffle or reverse rows.

按列配置批量生成姓名、邮箱、手机号等随机测试数据，内置多套快捷模板。

Generate random mock test data (names, emails, phones) with built-in templates.

以当前数据为基准，与另一份 CSV 对比，一键找出新增、删除与修改的行。

Compare the working data with another CSV to find added, removed and changed rows.

按行、列维度交叉汇总数据，支持计数、求和、平均值等聚合分析。

Cross-tabulate data by row and column dimensions with count, sum, average and more.

按一个或多个列对数据排序，升序/降序，多排序键依次生效，支持空值规则与不区分大小写。

Sort data by one or more columns, ascending/descending, with empty-value rules and case-insensitive options.

把重复性的处理动作录制成一条「配方」，保存后一键重放，适合周报、月报模板。

Record a repeatable chain of operations as a recipe and replay it with one click — ideal for weekly or monthly workflows.

当前数据当成表 data，直接写 SQL 查询、聚合、筛选，结果可载回继续处理。

Query your data as a data table with SQL — aggregates, filters and more — then load results back into the workspace.