How to Open a CSV File in Google Sheets

If you work with CSV exports from ad platforms, analytics tools, CRMs, or e-commerce backends, you probably open the same file in Google Sheets several times a week. The manual import flow works, but it adds five or six clicks every time. This guide covers both methods so you can pick the right one for your workflow.

Method 1: Open a CSV in Google Sheets manually

This is the built-in flow Google provides. It's reliable, free, and works for occasional use.

1. Open Google Drive in your browser at drive.google.com.
2. Click New → File upload and choose your CSV file.
3. Once uploaded, right-click the file and choose Open with → Google Sheets.
4. Google Sheets creates a new spreadsheet from the CSV in your Drive.

Alternative: open Sheets first, then use File → Import → Upload, drop the CSV, and pick how it should be inserted (replace spreadsheet, new sheet, etc.).

Method 2: Open a CSV in Google Sheets with a Chrome extension

If you open CSVs often, install the CSV to Google Sheets Chrome extension. It removes the upload and import dialog entirely.

1. Install the extension from the Chrome Web Store.
2. Click the toolbar icon to open the popup.
3. Choose a CSV file (or pick from your recent downloads), and it becomes a real Google Sheet in your Drive.

Common problems

Wrong delimiter

Some exports use semicolons (;) or tabs instead of commas. In the manual flow, Sheets usually auto-detects this, but you can override the separator type in the import dialog if columns end up merged.

Wrong character encoding

If special characters render as ? or �, the file is likely in a non-UTF-8 encoding. Re-save it as UTF-8 from the source tool, or open it in a text editor and export to UTF-8 first.

Leading zeros lost

Sheets parses numeric-looking columns as numbers, which drops leading zeros from product codes or zip codes. After import, select the affected column and set Format → Number → Plain text, then re-paste from the original.

Large files

Google Sheets supports up to 10 million cells per spreadsheet. Very large CSVs (hundreds of MB) may time out — split the file or filter it before importing.