The fastest way to open a CSV file in Google Sheets

Go to Google Sheets (sheets.google.com), click the + New button on the left side, then select File upload. Choose your CSV file from your computer. Google Sheets will open a dialog asking how you want to import the data — select Replace spreadsheet to use the whole sheet, or Insert new sheet if you want to add it to an existing file. Click Import data and your CSV will open as a new spreadsheet.

If you already have the CSV file open in another program or your file manager, you can also drag it directly into a Google Sheets tab in your browser. The import dialog will appear automatically.

Key Takeaways

  • CSV files open in Google Sheets through the File upload button, not by opening them directly from your computer.
  • Google Sheets will ask whether to replace the current spreadsheet or create a new sheet — choose based on whether you want to keep existing data.
  • Commas, tabs, and semicolons are the most common delimiters Google Sheets recognizes, and it usually detects the right one automatically.
  • If your data looks jumbled after import, the delimiter detection was wrong — you can fix it by re-importing and choosing the correct delimiter manually.

What happens during the import process

When you select a CSV file, Google Sheets reads the first few rows to guess how your data is separated. Most CSV files use commas as the separator, but some use tabs, semicolons, or other characters. Google Sheets shows you a preview of how it will split the data into columns before you confirm the import.

Look at the preview carefully. If your data is splitting into the right columns, click Import data. If everything is crammed into one column or split in the wrong places, click the dropdown next to Separator type and choose a different option — Tab, Semicolon, or Custom if you need something else. The preview updates as you change it.

Opening a CSV file that's already on your computer

If the CSV file is sitting in your Downloads folder or on your desktop, you have two routes. The first is to go to Google Sheets and use the File upload button described above. The second is to open the file in Google Sheets directly from your file manager.

Right-click the CSV file on your computer, select Open with, and choose Google Chrome (or your default browser). The file will open in your browser, and you can then save it to Google Sheets by going to File > Save to Drive. This route is slower than uploading directly, but it works if you want to preview the file first.

Fixing data that looks wrong after import

Sometimes your data arrives in Google Sheets with everything in one column, or with numbers and text split incorrectly. This almost always means Google Sheets guessed the wrong delimiter. The fix is to re-import the file with the correct separator.

Delete the imported sheet (right-click the sheet tab at the bottom and select Delete sheet), then upload the CSV file again. When the import preview appears, click the Separator type dropdown and try Tab, Semicolon, or Custom depending on how your file is actually separated. The preview will update instantly, so you can see which one is correct before you import.

Converting other file types to CSV first

If you have data in Excel (.xlsx), Numbers, or another spreadsheet program, you need to save it as a CSV file before Google Sheets can import it. Open the file in its original program, go to File > Save As (or Export), and choose CSV from the file type list. Save it to your computer, then upload it to Google Sheets using the steps above.

Be aware that some formatting — colors, fonts, merged cells — will not survive the conversion to CSV. CSV files store only the raw data and basic structure, not appearance. If you need to keep formatting, consider uploading an Excel file directly to Google Sheets instead, which preserves more of the original layout.

Handling special characters and encoding issues

If your CSV file contains accented letters, symbols, or text in another language and it shows up as garbled characters after import, the file may be using a different character encoding than Google Sheets expects. This is rare with modern files, but it happens with older CSVs or files created on different operating systems.

The simplest fix is to open the CSV file in a text editor like Notepad (Windows) or TextEdit (Mac), go to File > Save As, and make sure the encoding is set to UTF-8 before saving. Then upload the corrected file to Google Sheets. If you are not sure how to change encoding in your text editor, contact the person who created the file and ask them to re-save it as UTF-8.

Working with large CSV files

Google Sheets can handle CSV files with hundreds of thousands of rows, but very large files may take a minute or two to import. If your file is over 10 MB, Google Sheets will still import it, but it may run slowly. For extremely large files, consider splitting them into smaller pieces before uploading, or using Google Sheets' built-in tools to filter and delete rows you do not need.

If an import fails or times out, try uploading the file again. If it fails repeatedly, the file may be corrupted. Open it in Excel or another spreadsheet program, check that the data looks correct, and save it as a fresh CSV file before trying Google Sheets again.

Frequently Asked Questions

Can I open a CSV file directly from Google Drive without uploading it again?

Yes. Right-click the CSV file in Google Drive, select Open with, and choose Google Sheets. It will import using the same process as uploading, and you will see the delimiter preview before the data loads.

What if my CSV file has headers in the first row and I do not want them treated as data?

Google Sheets does not automatically recognize headers during import — it treats the first row as data. After the file opens, you can freeze the first row by going to View > Freeze > 1 row so it stays visible when you scroll. This does not change the data itself, just how it displays.

Why does my date column show as numbers after import?

CSV files store dates as numbers or text strings, not as formatted dates. After import, select the column, go to Format > Number, and choose Date or Date time from the list. Google Sheets will reformat the numbers to show as actual dates.

Can I import a CSV file from a URL or email attachment?

For a URL, download the file to your computer first, then upload it to Google Sheets. For an email attachment, save it to your computer or Google Drive, then open it in Google Sheets. Google Sheets does not import directly from URLs or email.