Convert CSV to Google Sheets: The Simple Guide
Converting a CSV to a Google Sheet means turning a plain-text file into a real spreadsheet you can edit, share, and reference from formulas. There are two practical ways to do it.
Manual conversion
- Upload the CSV to Google Drive.
- Right-click it and pick Open with → Google Sheets.
- Drive creates a new Google Sheet from the CSV. The original CSV stays in Drive.
You can delete the original CSV afterward if you don't need it.
One-click conversion with the Chrome extension
Install CSV to Google Sheets, open the popup, and pick a CSV. A real Google Sheet is created in your Drive in one step. The extension only creates the Sheet — it doesn't read or modify your other Drive files.
Gotchas worth knowing
- Some CSVs use semicolons; Sheets usually auto-detects, but the manual import dialog lets you override.
- Re-save the source CSV as UTF-8 to keep accented characters and emoji intact.
- Format destination columns as plain text before importing to preserve leading zeros.
- Very large CSVs (millions of rows) may hit the 10-million-cell limit. Filter or split first.
Frequently asked questions
Open CSV files in Google Sheets faster
Skip the upload-and-import dance. Install the Chrome extension and turn any CSV into a Google Sheet in one click.
Related articles
How to Open a CSV File in Google Sheets
Two reliable ways to open a CSV in Google Sheets — the standard manual import flow, and a faster Chrome extension that does it in one or two clicks.
How to Import a CSV File into Google Sheets: The Complete Manual Guide
The complete manual guide to importing a CSV into Google Sheets — every screen in the built-in importer, every setting explained, and the fixes for the eight things that usually go wrong.
Automate Recurring CSV Imports to Google Sheets: Schedules, Triggers, and Workflows
This guide is not about manual CSV imports — it is about removing them from your week. Scheduled triggers, incremental loads, email-attachment pipelines, and hands-off workflows for teams that live in Google Sheets.
How to Import CSV into Google Sheets Without Formatting Errors
Google Sheets often misreads CSVs: it drops leading zeros, mangles special characters, and converts dates into the wrong format. This guide shows how to import CSVs cleanly every time.