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 CSV to Google Sheets Without Repeating Manual Uploads
If you import CSVs into Google Sheets every week, the standard flow stops scaling. Here's a faster workflow that takes one or two clicks per file.