📋 CSV 表格处理CSV Table

把 CSV 转换为 JSON 或 Markdown 表格,或行列转置;还可按列排序、按列筛选数据行。支持逗号、分号、Tab 及自定义分隔符,全部在本地完成。Convert CSV to JSON or a Markdown table, or transpose rows and columns; also sort or filter data rows by column. Comma, semicolon, Tab or custom delimiter — all local.

① 输入 CSV① Input CSV

② 排序与筛选② Sort & filter

排序、筛选与按列去重仅作用于「CSV → 其他」方向,作用于表头之外的数据行。Sort, filter & column dedupe apply only to the “CSV → else” direction, on data rows (excluding the header).

③ 输出③ Output

📚 CSV 引号与转义规则📚 CSV quoting & escaping

CSV 没有强制标准,但存在通用规则:① 含逗号(或分隔符)、换行、引号的字段必须用双引号包裹;② 字段内的双引号写成两个连续引号(`""`)转义;③ 是否「首行是表头」依文件而定——本工具按首行当表头处理。例如 a,"b,c",d 是三个字段(第二个值为 b,c)。CSV has no strict standard but common rules: ① fields containing the delimiter, newlines or quotes must be wrapped in double quotes; ② embedded quotes are escaped by doubling (`""`); ③ whether the first row is a header depends on the file — this tool treats it as the header. E.g. a,"b,c",d is three fields (the second value is b,c).

分隔符不限于逗号:分号、Tab、竖线等同样常见(取决于区域设置与导出工具)。本工具支持逗号/分号/Tab/竖线及自定义分隔符,并带完整的引号解析与转义(含字段内换行),因此可以正确处理「被引号包裹、内含分隔符与换行」的复杂单元格。Delimiters are not limited to commas: semicolons, tabs and pipes are common (depending on locale and exporting tool). This tool supports comma/semicolon/Tab/pipe plus a custom delimiter, with full quote-aware parsing and escaping (including embedded newlines), so complex quoted cells with embedded delimiters and line breaks parse correctly.

使用说明How to use

怎么用How to use
  1. 粘贴 CSV 内容Paste CSV content
  2. 选择分隔符与方向(CSV→JSON/Markdown/转置)Choose delimiter and direction (CSV→JSON/Markdown/transpose)
  3. 可按列排序、筛选Sort or filter by column

示例:姓名/年龄表 → JSON 数组Example: A name/age table → JSON array

全程在你的浏览器本地完成,文本不会上传服务器。Runs entirely in your browser; your text is never uploaded.