How to open a CSV in Google Sheets
There are two reliable ways. The manual flow works for occasional files. The Chrome extension makes sense if you open CSVs more than once a week.
Manual way to import CSV into Google Sheets
- Open Google Drive in your browser.
- Click New → File upload and select your CSV.
- Wait for the upload to complete.
- Right-click the CSV file in Drive and choose Open with → Google Sheets.
- A new Google Sheet is created from the CSV in your Drive.
Alternative: open a Sheet first, then use File → Import → Upload, drop the CSV, and choose how to insert it.
Faster way using the Chrome extension
CSV to Sheets reduces the workflow to two clicks. Install the extension, click the toolbar icon, and pick the CSV.
Install the Chrome extension
Add CSV to Google Sheets from the Chrome Web Store. Works in Chrome, Edge, Brave, and Arc.
Open the popup and pick a CSV
Drag a file in, click Choose CSV, or pick a recent download.
Edit in Google Sheets
A real Google Sheet opens in a new tab, already in your Drive.
When to use each method
- Occasional, one-off file: the manual flow is fine.
- Weekly or daily exports: the extension removes the upload and import dialog entirely.
- Files received from teammates: open from recent downloads in one click.
Common CSV issues (and quick fixes)
Some files use semicolons or tabs. Sheets usually auto-detects; override in the import dialog if columns merge.
If you see ? or �, re-export the CSV as UTF-8 from the source tool.
Sheets supports 10M cells per Sheet. Split or filter very large CSVs first.
Dates from some platforms come in as text. Convert the column to Date format before sorting.
Format the destination column as plain text before importing to keep zip codes and SKUs intact.
Fields with commas should be wrapped in double quotes in the source CSV. Re-export if columns get split.
Try it on your next CSV
Install the extension and the next CSV you download opens in Google Sheets in one click.