Google Sheets and CSV: Import, Export, and Avoid Broken Data

Sheets Is Friendly—and Still Can Mutate Data

Google Sheets is often gentler than desktop Excel with CSV, but it still auto-detects types, reformats dates by locale, and can surprise you on download. Explicit import settings beat dragging a .csv onto Drive and hoping.

Step-by-Step: Import CSV into Google Sheets

Use File → Import for control.

• File → Import → Upload (or import from Drive).
• Choose Create new spreadsheet or Insert/Replace as needed.
• Set Separator type: detect automatically, or force comma/semicolon/tab.
• Convert text to numbers/dates carefully—disable if IDs must stay text.
• Review ID and date columns immediately after import.
• If detection fails, clean the file first in the Online CSV Editor.

Step-by-Step: Export CSV from Google Sheets

File → Download → Comma-separated values (.csv). Remember only the current sheet downloads—not the whole workbook.

• Put import-ready data on one sheet.
• Remove filter views that hide rows you still need—or verify what downloads.
• Check date display formats before download if downstream tools parse display values.
• Re-open the downloaded CSV to verify IDs and encoding.

Protecting IDs and Leading Zeros

Prefix with an apostrophe for text, format the column as Plain text before pasting, or keep a leading tab trick only as a last resort. Best approach: ensure the source CSV quotes text IDs and import without converting text to numbers.

Sheets vs Excel for CSV Work

Sheets shines for collaboration and lighter locale surprises for some teams. Excel still dominates complex validation and Power Query. Many workflows edit in Sheets, download CSV, then validate in Convert CSV Online before a system import.

Real-World Examples

Everyday Sheets + CSV.

Common Mistakes

Easy to miss in a browser grid.

• Downloading the wrong sheet from a multi-sheet workbook.
• Assuming Drive preview equals a correct import.
• Locale date swaps on shared international Sheets.
• Hidden rows still exporting (or vice versa with filters—verify).
• Editing downloaded CSV in Excel and re-uploading corruption.

Best Practices

Keep collaborative editing from breaking imports.

• One sheet = one import file.
• Freeze a “export” tab that is always import-clean.
• Document separator and date expectations.
• Verify CSV after every download.
• Use Convert CSV Online when delimiters or encoding are unclear.

Why Use Convert CSV Online?

Convert CSV Online is free, browser-based, and requires no account for everyday conversions. When Sheets’ auto-detect gets delimiter or encoding wrong, preview and normalize in the Online CSV Editor, then re-import. Client-side workflows work on Windows, macOS, and Linux browsers.

Conclusion

Google Sheets and CSV work well with explicit import separators, careful type conversion, and single-sheet downloads. Verify IDs and dates every time you cross the Sheets ↔ CSV boundary.