别直接双击:用"导入"最稳Don't Double-Click: Use "Import"
直接双击 CSV 时,Excel 会用系统默认编码(中文 Windows 常为 GBK),一旦文件是 UTF-8 就会乱码。正确做法是走"数据 → 从文本/CSV"导入向导,在那里手动选编码和分隔符。
Double-clicking lets Excel assume the system default encoding (often GBK on Chinese Windows); a UTF-8 file then turns to garbage. The right way is "Data → From Text/CSV", where you pick encoding and delimiter manually.
Excel 导入向导要点Excel Import Wizard Tips
- 文件原始格式选「65001: Unicode (UTF-8)」处理中文 UTF-8 文件。
- 分隔符选「逗号」,若文件用分号/制表符则对应选择。
- 预览正常后再"加载"到工作表。
- Pick "65001: Unicode (UTF-8)" for Chinese UTF-8 files.
- Set the delimiter to comma, or semicolon/tab if that's what the file uses.
- Load only after the preview looks right.
Google SheetsGoogle Sheets
在 Sheets 里用「文件 → 导入 → 上传」,导入设置里同样可选分隔符与编码,通常对 UTF-8 更友好。
In Sheets use "File → Import → Upload"; the import dialog also lets you set delimiter and encoding, and is usually friendlier to UTF-8.
打不开 / 显示异常的排查When It Won't Open Right
- 整列挤在一格里:分隔符选错了,参考 分隔符与引号。
- 中文乱码:编码错了,用 编码转换 先转成 UTF-8 再导入。
- 数字变科学计数法:把列设为"文本"格式,详见 CSV 转 Excel。
- Everything in one column: wrong delimiter — see delimiter & quoting.
- Garbled Chinese: wrong encoding — convert to UTF-8 first.
- Numbers become scientific: set the column to "Text" format; see CSV to Excel.
更省事的办法:用 365Lab CSV 解析工具 直接在浏览器里预览与清洗,无需和 Excel 编码较劲,且数据不上传。
Easier path: Use the 365Lab CSV Parser to preview and clean right in the browser — no Excel encoding battles, and nothing is uploaded.
想马上试试?打开在线解析工具,拖入 CSV 即可正确预览,全程本地处理。
Want to try now? Open the parser, drop in your CSV to preview correctly — locally, no upload.