别直接双击:用"导入"最稳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。
更省事的办法:用 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.

打开 CSV 解析工具 →Open the CSV Parser →