365Lab CSV 免费在线CSV工具箱Free Online CSV Toolkit
免费 · 无需注册 · 浏览器本地处理Free · No sign-up · 100% in-browser

365Lab CSV 工具箱365Lab CSV Toolkit

免费在线 CSV 处理工具箱:CSV 解析预览、格式转换(JSON / Excel / XML / SQL / Markdown)、数据清洗去重、列操作、统计图表、合并拆分、搜索过滤、编码转换。所有数据仅在浏览器本地处理,绝不上传服务器,安全可靠。 A free online CSV toolkit: parse & preview, convert (JSON / Excel / XML / SQL / Markdown), clean & dedupe, column operations, statistics & charts, merge & split, search & filter, and encoding conversion. Everything runs locally in your browser — nothing is ever uploaded.

15 专业工具Tools
0 数据上传Data uploaded
100% 浏览器本地处理In-browser
50 步撤销保护Undo steps

核心功能Core Features 点击卡片直接进入对应工具 Click a card to open the matching tool

CSV 解析预览Parse & Preview

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

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

格式转换Convert

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

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

数据清洗Clean & Dedupe

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

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

列操作Column Ops

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

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

统计图表Statistics & Charts

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

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

合并拆分Merge & Split

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

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

搜索过滤Search & Filter

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

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

编码转换Encoding

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

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

文本工具Text Tools

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

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

模拟数据Mock Data

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

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

数据对比Diff Check

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

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

透视表Pivot Table

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

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

多列排序Multi-column Sort

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

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

操作配方Recipes

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

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

SQL 查询SQL Query

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

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

为什么选择 365Lab CSV 工具Why 365Lab CSV Tools

隐私安全Privacy First

所有处理均在浏览器本地完成,文件不上传任何服务器。

Everything runs locally in your browser. Your files never leave your device.

快速高效Fast & Light

支持数十万行级别数据处理与索引优化排序。

Handles hundreds of thousands of rows with optimized sorting.

随时撤销Full Undo

最多 50 步操作历史,误操作一键回退。

Up to 50 steps of history so you can roll back mistakes.

全端可用Any Device

支持电脑与手机,中英双语,深浅主题。

Works on desktop and mobile, bilingual, light & dark themes.

常见问题Frequently Asked Questions

1. 这个工具是免费的吗?1. Is this tool free?

是的,365Lab CSV 工具完全免费,无需注册登录,无使用次数限制。

Yes, 365Lab CSV Tools is completely free with no registration or usage limits.

2. 我的数据安全吗?会传到哪里?2. Is my data safe? Where is it uploaded?

安全。所有解析、转换、清洗都在您的浏览器中完成,文件不会被上传到任何服务器。

Yes. All parsing, conversion and cleaning happens in your browser. Files are never uploaded to any server.

3. 打开 GBK 编码的 CSV 出现乱码怎么办?3. My GBK CSV shows garbled text. What can I do?

使用「编码转换」功能,上传文件后点击"自动检测",即可识别 GBK / Big5 / Shift_JIS 等编码并正确显示,还可一键转换为 UTF-8。

Use the Encoding tool, upload the file and click "Auto-detect" to identify GBK / Big5 / Shift_JIS etc., then convert it to UTF-8.

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

可以。「多列排序」模块支持添加一个或多个排序键,每个键选择排序列与升/降序方向,可先按「部门」再按「金额」降序依次生效,执行前有预览、结果可一键导出。

Yes. The Multi-column Sort module lets you add multiple sort keys, each with its own column and asc/desc direction — e.g. sort by Department first, then by Amount descending. Preview before executing and export the result with one click.

查看全部常见问题 →See all FAQ →

CSV 教程与技巧CSV Guides & Tips 实用的处理方法与避坑指南 Hands-on how-tos and pitfalls to avoid

什么是 CSV 文件?CSV 格式完全入门指南 - 365Lab CSV工具 基础知识Basics

什么是 CSV 文件?CSV 格式完全入门指南What Is a CSV File? The Complete Beginner's Guide

从分隔符、编码到引号转义,一文讲清 CSV 的原理与常见误区。

From delimiters and encoding to quoting — understand how CSV works and avoid common mistakes.

阅读约 6 分钟6 min read
CSV 转 Excel:在线转换方法与常见问题 - 365Lab CSV工具 格式转换Conversion

CSV 转 Excel:在线转换方法与常见问题CSV to Excel: How to Convert & Fix Common Issues

把 CSV 转成可编辑的 .xlsx,并解决中文乱码、科学计数法等典型问题。

Turn CSV into editable .xlsx and fix garbled Chinese, scientific notation and more.

阅读约 5 分钟5 min read
CSV 乱码怎么修复?GBK/UTF-8 编码转换教程 - 365Lab CSV工具 编码处理Encoding

CSV 乱码怎么修复?GBK/UTF-8 编码转换教程Fix CSV Garbled Text: GBK/UTF-8 Encoding Conversion

打开 CSV 出现"浣犲ソ"这类乱码?检测并转换编码一键修复。

Seeing gibberish like "浣犲ソ" in your CSV? Detect and convert the encoding in one click.

阅读约 6 分钟6 min read
删除 CSV 重复行:3 种实用方法 - 365Lab CSV工具 数据清洗Cleaning

删除 CSV 重复行:3 种实用方法Remove Duplicate Rows from CSV: 3 Practical Methods

按整行、按指定列或近似重复去重,并保留首次或末次出现的记录。

Dedupe by whole row, by selected columns, or by near-duplicates — keep first or last.

阅读约 5 分钟5 min read
CSV 转 JSON:在线转换与嵌套结构处理 - 365Lab CSV工具 格式转换Conversion

CSV 转 JSON:在线转换与嵌套结构CSV to JSON: Online Conversion & Nested Structures

把表格转成 API 可用的 JSON,支持对象数组与按列分组嵌套。

Turn tables into API-ready JSON — object arrays and column-grouped nesting.

阅读约 6 分钟6 min read
用 Excel 或 Google Sheets 打开 CSV(不乱码)- 365Lab CSV工具 基础知识Basics

用 Excel 或 Google Sheets 打开 CSV(不乱码)Open CSV in Excel or Google Sheets (Without Garbage)

用导入向导正确选择编码与分隔符,解决打不开、挤成一列、乱码等问题。

Use the import wizard to pick encoding and delimiter — fix "won't open", one-column, garbled issues.

阅读约 5 分钟5 min read

浏览全部文章 →Browse all articles →

关于我们About Us

365Lab 致力于提供免费、安全、易用的在线数据工具。本 CSV 工具站全部功能纯浏览器端实现,无需安装、无需注册,保护你的数据隐私。欢迎访问 https://www.365lab.top/ 了解我们的更多项目。

365Lab is dedicated to free, secure and easy-to-use online data tools. This CSV tool site runs entirely in your browser — no install, no registration, data stays private. Visit https://www.365lab.top/ to see more of our projects.