为什么要导入到 Google SheetsWhy Import into Google Sheets

Google Sheets 是一款免费的在线表格,支持多人实时协作、云端保存、跨设备访问。当你拿到一份 CSV 数据(例如从数据库导出的客户列表、电商订单、问卷结果),把它导入 Google Sheets 就能立刻筛选、排序、做图表,而不必安装任何软件。

Google Sheets is a free online spreadsheet with real-time collaboration, cloud saving and cross-device access. When you receive a CSV export (a customer list, e-commerce orders, survey results), importing it into Sheets lets you filter, sort and chart instantly — no software install required.

方法一:直接上传新建表格Method 1: Upload to Create a New Sheet

  1. 打开 sheets.new 新建一个空白表格;或在 Google 云端硬盘点击"新建 → 文件上传",选中你的 .csv 文件。
  2. 上传完成后,双击该文件,Google 会自动用 Google Sheets 打开它。
  3. 如果所有内容挤在一列,说明分隔符没被识别,请继续看"方法二"手动分列。
  1. Open sheets.new for a blank sheet, or in Google Drive click "New → File upload" and select your .csv.
  2. Once uploaded, double-click the file and Google opens it in Sheets automatically.
  3. If everything lands in one column, the delimiter wasn't detected — see Method 2 to split it manually.

方法二:用"导入"按分隔符分列Method 2: Use "Import" to Split by Delimiter

当数据没有被正确分列,或你想精确控制格式时,用菜单导入最稳妥:

When columns aren't split correctly, or you want precise control, the menu import is safest:

  • 在 Google Sheets 中选择 文件 → 导入 → 上传,选择 CSV。
  • 在导入设置里:分隔符选"逗号"(或自动检测);编码选 UTF-8(中文不乱码的关键);转换为日期和数字可按需开启或关闭。
  • 点击"导入数据",即可按列正确展开。
  • In Sheets choose File → Import → Upload and pick the CSV.
  • In the import options: set Separator to comma (or auto-detect); set Encoding to UTF-8 (the key to no Chinese garble); toggle Convert to date and number as needed.
  • Click "Import data" and the columns expand correctly.
提示:如果中文显示为乱码,几乎都是编码选错。先把文件转成 UTF-8 再导入,详见我们的 CSV 乱码修复教程;如果一列被当成文本、一列被当成数字,注意"转换为日期和数字"开关。
Tip: If Chinese shows as garble, the encoding is almost always wrong. Convert the file to UTF-8 first — see our garbled-text fix guide. If one column becomes text while another becomes a number, watch the "Convert to date and number" toggle.

常见坑与解决办法Common Pitfalls & Fixes

1. 大文件上传失败或很慢1. Large files fail or are slow

Google Sheets 单个表格约支持 1000 万单元格。超过此规模时,建议先用 365Lab 在线 CSV 工具 在浏览器本地完成筛选、去重、拆分,再导入,既快又不上传隐私数据。关于大文件处理,参见 大文件 CSV 处理技巧。

A single Sheet supports roughly 10 million cells. Beyond that, first filter, de-duplicate or split with the 365Lab CSV toolkit locally in your browser — fast and private. See Handling Large CSV Files.

2. 身份证号、手机号变成科学计数法2. IDs and phone numbers turn into scientific notation

长数字(如 18 位身份证号)被 Sheets/Excel 当成数字后会显示成 1.23E+17。导入时务必把该列设为"纯文本"格式,或在 CSV 中给数字加前置单引号。完整方案见 CSV 数字变科学计数法怎么办。

Long numbers (like an 18-digit ID) are treated as numbers and shown as 1.23E+17. Set that column to "Plain text" on import, or prefix the value with a single quote in the CSV. The full fix is in CSV Numbers Turning into Scientific Notation.

3. 分隔符是分号而不是逗号3. The delimiter is a semicolon, not a comma

欧洲版 Excel 导出的 CSV 常用分号。导入时分隔符要改选"分号",或在导入前用 分隔符与引号规则 一文的方法统一成逗号。

European Excel often exports CSV with semicolons. Choose "semicolon" as the separator, or first normalize to commas using the method in Delimiter & Quoting Rules.

Google Sheets 与 Excel 打开 CSV 的区别Sheets vs Excel for Opening CSV

两者都能打开 CSV,但 Google Sheets 完全在浏览器运行、便于协作;桌面 Excel 功能更全但容易因区域设置把分号当逗号。无论用哪个,先把编码和分隔符搞对都不会错。想了解更深层差异,参考 CSV 与 Excel 的区别 与 用 Excel / 表格软件打开 CSV。

Both open CSV, but Sheets runs entirely in the browser and is great for collaboration, while desktop Excel is more powerful yet often misreads semicolons as commas due to regional settings. Either way, getting encoding and delimiter right is what matters. For the deeper comparison see CSV vs Excel and Opening CSV in Excel / Sheets.

想先整理再导入?用 365Lab 在线工具在本地完成解析、清洗、去重、分列,再下载干净的 CSV 上传到 Google Sheets,全程数据不上传。

Want to tidy up before importing? Use 365Lab to parse, clean, de-duplicate and split locally, then upload a clean CSV to Sheets — your data never leaves your device.

打开 CSV 在线工具 →Open the CSV Toolkit →