365Lab CSV 免费在线CSV工具箱Free Online CSV Toolkit

常见问题 FAQFrequently Asked Questions

最后更新:2026 年 9 月。如未找到答案,欢迎通过关于我们页面邮箱联系我们。

Last updated: September 2026. If you don't find an answer, contact us via the email on the About page.

1. 这个工具免费吗?有什么限制?1. Is the tool free? Are there any limits?

完全免费,无需注册登录,无使用次数与功能限制,长期开放。

Completely free. No registration, no usage limits, and no feature restrictions.

2. 我的数据会传到服务器吗?安全吗?2. Is my data uploaded anywhere? Is it safe?

不会。本站为纯浏览器端工具(Client-side),所有解析、转换、清洗、统计均在您的浏览器本地完成,文件不会被上传到任何服务器。请放心使用。

No. This is a fully client-side tool — all parsing, conversion, cleaning and statistics run locally in your browser. Files are never uploaded to any server.

3. 支持哪些文件格式?3. Which file formats are supported?

支持 CSV、TSV 的解析导入;可导出 CSV、TSV、JSON、Excel(.xlsx)、XML、SQL、HTML、Markdown 等格式;也可导入 Excel(.xlsx/.xls)转为 CSV 处理。

CSV and TSV can be imported; export supports CSV, TSV, JSON, Excel (.xlsx), XML, SQL, HTML and Markdown. Excel files (.xlsx/.xls) can also be imported for CSV processing.

4. 打开 CSV 乱码(GBK/繁体)怎么办?4. My CSV shows garbled text (GBK/traditional Chinese). What to do?

使用「编码转换」工具:上传文件后点击"自动检测",可识别 GBK / Big5 / Shift_JIS / EUC-KR 等编码并正确解码,也可手动选择后一键转存为 UTF-8。

Use the Encoding tool: upload the file and click "Auto-detect" to identify GBK / Big5 / Shift_JIS / EUC-KR etc., decode it correctly, or convert it to UTF-8.

5. 支持多大的数据量?会不会卡?5. How large a file can I process? Will it freeze?

支持数十万行级别。解析采用流式与大文件优化,排序等操作使用索引加速;表格默认分页渲染,避免一次性渲染卡顿。

Hundreds of thousands of rows are supported. Parsing is stream-optimized, sorting is index-accelerated, and the table renders in pages to avoid lag.

6. 手机上可以用吗?6. Does it work on mobile?

可以。页面自适应手机屏幕,导航折叠为菜单,触控友好;同时支持中英双语切换与深色/浅色主题。

Yes. The interface adapts to mobile screens with a collapsible menu and touch-friendly controls, plus bilingual support and light/dark themes.

7. 如何合并多个 CSV 文件?7. How do I merge multiple CSV files?

进入「合并拆分」工具,可一次性添加多个 CSV 文件,选择按行列头合并或直接拼接,合并结果可在表格中预览并下载。

Open the Merge & Split tool, add multiple CSV files, choose to merge by headers or concatenate, then preview and download the result.

8. 怎么按重复内容去重?8. How do I remove duplicate rows?

进入「数据清洗」工具,勾选"去重"并选择要判断的列(全部或指定列),即可删除重复行;操作可随时撤销。

Open the Clean tool, tick "Deduplicate" and choose the columns to compare (all or specific ones) to remove duplicate rows. Every action is undoable.

9. 支持 Excel 导入导出吗?9. Can I import/export Excel files?

支持。解析页可导入 .xlsx/.xls;转换工具可把当前数据导出为 .xlsx,下载后可直接用 Excel / WPS 打开,中文与多工作表风格友好。

Yes. You can import .xlsx/.xls in the Parse tool and export the current data as .xlsx, which opens directly in Excel / WPS.

10. 操作错了可以撤销吗?10. Can I undo mistakes?

可以。站点内置最多 50 步操作历史,清洗、列操作、替换等均可用"撤销 / 重做"回退。快捷键方面请见工具页右上角「快捷键帮助」。

Yes. The site keeps up to 50 steps of history; cleaning, column edits and replacements can all be undone/redone. See "Shortcuts help" in the tools page.

11. 可以按多列排序吗?11. Can I sort by multiple columns?

可以。进入「多列排序」工具,添加一个或多个排序键,每个键可指定排序列、升/降序方向、排序方式(智能 / 自然排序 / 拼音 / 仅数值)与空值位置;执行前有前 20 行预览,结果可一键导出。

Yes. Open the Multi-column Sort tool, add one or more sort keys — each with column, asc/desc, mode (smart / natural / pinyin / numeric) and null placement — e.g. sort by Department first, then by Amount descending. Preview the first 20 rows and export with one click.

12. 如何用透视表分析数据?12. How do I analyze data with a pivot table?

进入「透视表」工具,指定行维度(可多列组合)、列维度与聚合方式(计数、求和、平均值等),即可把明细数据交叉汇总为统计矩阵;数值显示可切「原始值 / 占行合计% / 占列合计% / 占总计%」用于结构分析。结果可导出或载回继续编辑(载回时始终使用原始数值)。

Open the Pivot Table tool, set row dimensions (multi-column supported), a column dimension and an aggregation method (count, sum, average, etc.) to cross-tabulate raw rows into a statistics matrix. Toggle the value display between raw values and % of row / % of column / % of grand total for structural analysis. Export or load it back — loaded-back results always use raw values.

前往工具页 →Go to Tools →