CSV 教程与技巧CSV Tutorials & Tips
实用的 CSV 处理方法、避坑指南与效率技巧,帮助你把表格数据处理得又快又稳。
Practical CSV how-tos, pitfalls to avoid and efficiency tips to help you process tabular data faster and safer.
基础知识Basics
什么是 CSV 文件?CSV 格式完全入门指南What Is a CSV File? The Complete Beginner's Guide
从逗号分隔到编码、引号转义,一文讲清 CSV 的原理、常见误区,以及它为什么适合数据交换。
From delimiters to encoding and quoting — understand how CSV works, common mistakes, and why it's great for data exchange.
格式转换Conversion
CSV 转 Excel:在线转换方法与常见问题CSV to Excel: How to Convert & Fix Common Issues
把 CSV 转成可编辑的 .xlsx,并解决中文乱码、科学计数法、日期变数字等典型问题。
Turn CSV into editable .xlsx, and fix typical issues like garbled Chinese, scientific notation and dates turning into numbers.
编码处理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, and prevent it from happening again.
数据处理Processing
如何合并多个 CSV 文件(无需 Excel)How to Merge Multiple CSV Files (No Excel Needed)
把几十个结构相同的 CSV 合并成一个,支持按表头对齐、纵向拼接与批量打包下载。
Combine dozens of same-structured CSVs into one — align by header, stack rows, and download as a batch.
数据清洗Cleaning
删除 CSV 重复行:3 种实用方法Remove Duplicate Rows from CSV: 3 Practical Methods
按整行、按指定列或按"近似重复"去重,并保留首次或末次出现的记录。
Dedupe by whole row, by selected columns, or by near-duplicates — and keep the first or last occurrence.
基础知识Basics
CSV 与 Excel 的区别:何时使用哪个CSV vs Excel: When to Use Which
一个纯文本、一个带格式与公式。搞清楚两者的取舍,避免选错格式导致数据丢失。
One is plain text, the other carries formatting and formulas. Learn the trade-offs so you never lose data by picking the wrong format.
数据清洗Cleaning
CSV 数据清洗:10 个实用技巧Clean CSV Data: 10 Practical Tips
去空格、统一大小写、处理空值、纠正日期、脱敏手机号……一套可复用的清洗清单。
Trim spaces, normalize case, handle nulls, fix dates, mask phone numbers — a reusable cleaning checklist.
性能优化Performance
如何处理超大 CSV 文件(百万行不卡)How to Handle Huge CSV Files (Millions of Rows)
Excel 打不开大文件?用流式解析、分页、列筛选与命令行工具高效处理百万行数据。
Excel chokes on big files? Use streaming parsing, pagination, column filtering and command-line tools to handle millions of rows.
格式转换Conversion
CSV 转 JSON:在线转换与嵌套结构CSV to JSON: Online Conversion & Nested Structures
把表格转成 API 可用的 JSON,支持对象数组与按列分组嵌套,并避开类型与编码坑。
Turn tables into API-ready JSON — object arrays and column-grouped nesting — while avoiding type and encoding pitfalls.
格式转换Conversion
CSV 转 SQL:批量生成 INSERT 语句CSV to SQL: Generate INSERT Statements in Bulk
把表格灌进 MySQL / PostgreSQL / SQLite,处理字段类型、引号转义与批量导入。
Load tables into MySQL / PostgreSQL / SQLite — handle column types, quote escaping and batch import.
格式转换Conversion
CSV 转 PDF:把表格导出成可打印文档CSV to PDF: Export Tables as Printable Documents
把报表、名单导出为排版固定、可打印的 PDF,处理中文、列宽与分页问题。
Export reports and rosters to fixed-layout, printable PDF — handling Chinese, column width and pagination.
基础知识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, and garbled issues.
基础知识Basics
CSV 分隔符与引号:逗号、分号、制表符怎么选CSV Delimiters & Quotes: Comma, Semicolon or Tab?
分隔符怎么选?字段里有逗号怎么办?讲清引号转义与 TSV 取舍,避免拆列错误。
Which delimiter? What if a field has a comma? Quoting rules and TSV trade-offs to avoid wrong splits.
数据分析Analytics
用 CSV 做数据分析:从 pandas 到可视化Analyze CSV Data: From pandas to Visualization
用 Excel 透视表、Python pandas 与命令行分析 CSV:读取、清洗、分组统计与可视化。
Analyze CSV with Excel pivots, Python pandas and the CLI — read, clean, group-by and visualize.
格式转换Conversion
CSV 转 vCard:批量生成通讯录联系人CSV to vCard: Generate Contact Files in Bulk
把联系人 CSV 转成 .vcf,讲清字段映射、编码换行,并给出导入手机与邮箱的方法。
Turn a contacts CSV into .vcf — field mapping, encoding/line-breaks, and how to import to phone & mail.
格式转换Conversion
CSV 转 XML:在线转换与结构映射CSV to XML: Online Conversion & Structure Mapping
把 CSV 转成 XML:根节点与行元素设计、属性 vs 子元素、命名空间与编码注意事项。
Convert CSV to XML — root/row design, attributes vs child elements, namespaces and encoding notes.
基础知识Basics
如何创建 CSV 文件:空白模板与保存方法How to Create a CSV File: Templates & Saving
用记事本、Excel、Google Sheets 新建 CSV,提供空白模板、字段命名规范与 UTF-8 保存要点。
Create CSV with Notepad, Excel or Sheets — blank template, field-naming rules and UTF-8 saving tips.
数据清洗Cleaning
CSV 日期与数字格式:避免 Excel 把数据搞乱CSV Date & Number Formats: Stop Excel Breaking Data
ISO 8601 日期、前导零丢失、科学计数法、货币与千分位等格式问题及修复方法。
ISO 8601 dates, lost leading zeros, scientific notation, currency & thousands — and how to fix them.
故障排查Troubleshooting
CSV 常见错误与修复:一份排错清单Common CSV Errors & Fixes: A Checklist
汇总最常见的 CSV 错误——乱码、错位、引号未转义、行尾符差异,并给出排查步骤。
The most common CSV errors — garbling, shifts, unescaped quotes, line endings — with troubleshooting steps.
格式转换Conversion
CSV 转 Markdown 表格:写文档与 Wiki 更快CSV to Markdown Tables: Faster Docs & Wikis
把 CSV 转成 Markdown 表格:对齐、转义竖线与换行、表头分隔行,以及写入 README/Wiki。
Convert CSV to Markdown tables — alignment, escaping pipes/newlines, header dividers, and docs/Wiki use.
基础知识Basics
CSV 与 TSV 的区别:何时用逗号,何时用制表符CSV vs TSV: When to Use Commas, When to Use Tabs
CSV 与 TSV 只差一个分隔符。本文讲清两者优劣、常见误区,以及字段含逗号/制表符时该怎么选。
CSV and TSV differ only by a delimiter. Learn the pros, cons, myths, and when to pick which.
数据清洗Cleaning
CSV 排序与筛选:按列整理数据的实用方法Sort & Filter CSV: Practical Ways to Organize Columns
按某列排序或只保留满足条件的行?讲清 Excel、命令行与在线工具的排序筛选方法与坑。
Sort by a column or keep only matching rows? Excel, CLI and online methods, plus pitfalls.
常见错误Troubleshooting
CSV 的 UTF-8 BOM 问题:识别、危害与去除方法UTF-8 BOM in CSV: Detect, Risks & How to Remove
Excel 保存的 CSV 常带 BOM,导致首列乱码、解析报错。讲清识别与去除方法。
Excel-saved CSVs often carry a BOM, causing header garbage and parse errors. Detect and remove it.
格式转换Conversion
把 CSV 导入 MySQL / PostgreSQL 数据库:完整步骤Import CSV into MySQL / PostgreSQL: The Full Steps
用 LOAD DATA、COPY 把 CSV 导入数据库,覆盖编码、类型匹配与常见报错。
Load CSV into MySQL/PostgreSQL with LOAD DATA and COPY — encoding, typing and common errors.
数据分析Analytics
CSV 数据校验:发现并修复数据质量问题CSV Data Validation: Find & Fix Quality Issues
导入或分析前如何检查缺失、重复、类型与编码问题,并修复。
Before import or analysis, check and fix missing, duplicates, types and encoding issues.
数据分析Analytics
CSV 分组与汇总:用透视思路快速统计Group & Summarize CSV: Pivot-Style Stats Fast
按类别汇总 CSV(如各地区销售额),讲清透视表、pandas 与命令行方法。
Summarize CSV by category (e.g. sales by region) with pivot tables, pandas and the CLI.
格式转换Conversion
CSV 转 HTML 表格:在线把 CSV 变成网页表格CSV to HTML Table: Turn CSV into Web Tables Online
想把 CSV 显示在网页、博客或邮件里?一键生成已转义、可直接粘贴的 HTML 表格代码。
Show CSV on a page, blog or email? Generate escaped, paste-ready HTML table code in one click.
基础知识Basics
CSV 与 JSON 的区别:何时使用哪个格式CSV vs JSON: When to Use Which Format
扁平表格用 CSV,层级数据用 JSON。对比结构、场景、转换边界与体积,附决策清单。
Flat tables → CSV, hierarchical → JSON. Compare structure, use cases, conversion limits and size, with a checklist.
基础知识Basics
CSV 导入 Google Sheets:完整步骤与常见问题Import CSV into Google Sheets
上传、按分隔符分列、设置编码与日期格式,解决大文件与中文乱码。
Upload, split by delimiter, set encoding and date format; fix large files and garble.
故障排查Troubleshooting
CSV 数字变科学计数法?身份证号、长数字不乱码CSV Numbers & Scientific Notation
18 位身份证号、手机号变 1.23E+17?用文本格式、前置单引号、等号写法保住位数。
IDs/phones turning into 1.23E+17? Keep digits with text format, leading quote or equals sign.