MDataKit

CSV Profiler & CleanerCSV 统计与清洗

Profile every column of a CSV — type, empty rate, unique count, min/max — then de-duplicate and sort it.

逐列统计 CSV 的数据类型、空值率、去重数量与最值,并一键去重、排序、导出干净数据。

What is CSV Profiler & Cleaner?CSV 统计与清洗 是什么?

A CSV profiler that tells you what is actually inside a file before you process it. It parses the CSV (with quoted fields, embedded commas and escaped quotes handled correctly), then reports for every column: the inferred type — text, number or date — how many values are empty, how many distinct values exist, and the minimum and maximum for numeric columns. From there you can de-duplicate rows, sort by a column, and export the cleaned file.

一个 CSV 剖析工具,在动手处理之前先告诉你文件里到底有什么。它按 RFC 4180 正确解析 CSV(引号字段、内嵌逗号、转义引号都支持),然后逐列报告:推断出的类型——文本、数字或日期——空值数量、去重后的取值个数,数值列还会给出最值。接着可以一键去重、按列排序,并导出清洗后的文件。

How to use csv profiler & cleaner如何使用 CSV 统计与清洗

  1. Paste the CSV content into the box (or drop a file and copy it in).
  2. Press Analyse to get the per-column profile and a data preview.
  3. Use Remove duplicates or Sort by col 1 to clean the data.
  4. Download the cleaned CSV when you are happy with it.
  1. 把 CSV 内容粘贴进输入框(或拖入文件后复制内容)。
  2. 点"分析",得到逐列统计与数据预览。
  3. 用"去重"或"按第 1 列排序"清洗数据。
  4. 满意后下载清洗后的 CSV。

Common uses常见用途

FAQ常见问题

How are types detected?类型是怎么判断的?

A column is numeric when every non-empty value parses as a number, and date-like when its first value starts with a YYYY-MM-DD pattern. Everything else is text. Empty cells never force a type.

当一列所有非空值都能解析成数字时判定为数字型;首个值形如 YYYY-MM-DD 时判定为日期型;其余为文本。空单元格不会影响类型判定。

Does it handle commas inside quoted fields?引号里的逗号能处理吗?

Yes. The parser is quote-aware: commas, line breaks and doubled quotes inside a quoted field are handled the way RFC 4180 specifies, and the exported file quotes those fields again.

能。解析器是引号感知的:引号内的逗号、换行和双写引号都按 RFC 4180 规则处理,导出时也会重新给这些字段加引号。

Does remove-duplicates keep the first row?去重会保留第一行吗?

Yes. The first occurrence of each unique row is kept and the duplicates that follow it are dropped.

会。每组重复行保留第一次出现的行,其后的重复行被丢弃。

Is my data uploaded?数据会上传吗?

No. Parsing and profiling happen in the browser.

不会。解析与统计都在浏览器内完成。

Other tools其他工具

📊

Excel ⇄ JSON / CSVExcel ⇄ JSON / CSV

Open an .xlsx or .csv file, preview the sheet, then export it as…

打开 .xlsx 或 .csv 文件预览表格内容,再导出为 JSON、CSV 或…

🗄️

SQLite Query RunnerSQLite 查询

Load a .sqlite database and run SQL queries against it entirely …

载入 .sqlite 数据库,用 WASM 版 SQLite 引擎在浏览器里执行…

🔎

JSONata Query & TransformJSON 查询与转换

Query and reshape JSON with JSONata expressions, list every path…

用 JSONata 表达式查询与重塑 JSON 数据,列出全部数据路径,或把嵌套…

Sister sites友情链接 MonkeyDev dev tools hub工具总站 FreePDFKit PDF toolsPDF 工具集 ImageToolKit image tools图片工具集 AI 咒语库 AI prompt libraryAI 提示词库 DevTools developer toolkit开发工具箱 CalcKit finance calculators财务计算器 OfficeKit office utilities办公工具箱 AIkit AI & machine learningAI 与机器学习 ChartKit diagrams & charts图表与可视化 DocKit markdown & document toolsMarkdown 与文档工具