The fastest way to open a CSV file in Google Sheets

Go to Google Sheets (sheets.google.com), click the blank spreadsheet icon, then use File > Open > Upload to select your CSV file from your computer. Google Sheets will convert it automatically and open it as a new spreadsheet. The whole process takes under a minute.

If you already have the CSV file open in another program or sitting in your email, you can also drag it directly into a Google Sheets tab in your browser — Google will recognize it and ask whether to create a new spreadsheet. Either way, your data lands in cells with the same structure it had in the original file.

The reason this works is that CSV stands for comma-separated values, a plain-text format that lists data in rows and columns separated by commas. Google Sheets reads those commas and automatically places each value into its own cell, so you do not have to reformat anything by hand.

Key Takeaways

  • Open Google Sheets, click File > Open > Upload, and select your CSV file to convert it to a Google Sheets spreadsheet in seconds.
  • You can also drag a CSV file directly into your browser tab, and Google Sheets will offer to create a new spreadsheet from it.
  • Google Sheets automatically splits CSV data at the commas, placing each value into the correct cell without manual work.
  • If your CSV uses semicolons or tabs instead of commas, Google Sheets usually detects this and adjusts automatically when you open the file.
  • Once open, you can edit, format, and save the spreadsheet as a Google Sheets file or read it back as CSV whenever you need.

Opening a CSV file using the File menu

Start at sheets.google.com and sign in with your Google account. Click the blank spreadsheet icon (a grid with a plus sign) to create a new spreadsheet. You will land on an empty sheet.

Click File in the top left corner. A menu will drop down. Select Open. A dialog box will appear with tabs at the top: "My Drive", "Shared with me", "Recent", and "Upload". Click the Upload tab.

Click Select a file from your computer or drag your CSV file into the box. Your file browser will open. Find your CSV file (it will have a .csv extension), click it once to select it, then click Open. Google Sheets will upload the file and ask you to confirm the import settings.

A dialog titled "Import file" will appear. You can usually leave the default settings as they are — Google Sheets detects that your file uses commas to separate values and will split the data correctly. Click Import data at the bottom right. Your spreadsheet will open with all your data in place.

Dragging a CSV file directly into Google Sheets

If you have your CSV file visible on your desktop or in a file manager window, you can skip the menu entirely. Open Google Sheets in your browser and have your file manager window open at the same time, or position them side by side.

Click and hold your CSV file, then drag it over your Google Sheets tab in the browser. You will see the tab highlight. Release the mouse button. Google Sheets will recognize the file and display an "Import file" dialog with the same settings as the menu method.

This method is faster if you are moving between your computer and Google Sheets repeatedly. It also works if you have multiple CSV files — you can drag them in one at a time, and each will open as a separate spreadsheet.

What happens if your CSV uses different separators

Most CSV files use commas, but some use semicolons, tabs, or pipes (|) to separate values instead. This is common in countries where the comma is used as a decimal point in numbers. When you import, Google Sheets will usually detect the separator automatically and split your data correctly.

If the data does not split into columns the way you expected — for example, if an entire row appears in a single cell — go back to the import dialog. Before clicking "Import data", look for a Separator dropdown menu. Click it and select the character your file actually uses: Tab, Semicolon, or Period. Then click "Import data" again.

If you are not sure which separator your file uses, open it in a text editor (like Notepad on Windows or TextEdit on Mac) and look at the first row. You will see the values separated by whatever character the file uses. Close the text editor without saving, then return to Google Sheets and adjust the separator setting.

Editing and saving your spreadsheet after import

Once your CSV is open in Google Sheets, you can edit it the same way you would edit any spreadsheet. Click a cell to change its contents, add rows or columns, explore formatting, or create formulas. All changes save automatically to your Google Drive.

If you need to send the spreadsheet back as a CSV file, click File > read > Comma-separated values (.csv). Google Sheets will read the file to your computer in CSV format, ready to use in another program or share with someone else.

You can also keep the file in Google Sheets format and share it with others by clicking the Share button in the top right. They can view or edit it directly in their browser without downloading anything.

Troubleshooting common import problems

If your data appears jumbled or in the wrong cells after import, the most common cause is an incorrect separator setting. Return to the import dialog (you can re-upload the same file and start over) and try a different separator option. Semicolon and Tab are the most common alternatives to comma.

If your CSV file contains special characters — like accented letters, symbols, or text in another language — and they appear as question marks or garbled text after import, the file may use a different character encoding. This is rare with modern files, but if it happens, try opening the CSV in a text editor, saving it as UTF-8 encoding, and then uploading it to Google Sheets again.

If Google Sheets will not let you upload the file at all, check that the file extension is actually .csv. Some programs save files with a .txt extension even if they contain CSV data. Rename the file to end in .csv and try again. You can do this by right-clicking the file, selecting "Rename", and changing the extension.

Frequently Asked Questions

Can I open a CSV file directly from my email in Google Sheets?

Yes. Open the email, find the CSV attachment, and click it. Gmail will usually offer to open it in Google Sheets. Click that option and Google Sheets will import the file automatically. If that option does not appear, read the attachment to your computer first, then upload it using the method described above.

What if my CSV file is very large?

Google Sheets can handle files up to 10 million cells. Most CSV files are much smaller. If your file is extremely large (over 100,000 rows), Google Sheets may slow down when you try to edit it. In that case, consider splitting the file into smaller pieces or using a desktop spreadsheet program like Excel for editing, then converting back to CSV when you are done.

Will Google Sheets change my data when I import a CSV?

Google Sheets will not alter your data, but it may change how numbers and dates are displayed. For example, a date written as "01/02/2024" might display as "1/2/24" depending on your location settings. The underlying data is unchanged. If you read the file back as CSV, it will match the original format.

Can I import multiple CSV files at once?

No, Google Sheets imports one file per spreadsheet. If you have multiple CSV files, upload them one at a time. Each will create a new spreadsheet. You can then copy data between them or combine them manually if needed.

Do I need to convert my CSV to Google Sheets format, or can I keep it as CSV?

You do not have to convert it. Google Sheets opens and edits CSV files directly. The file remains a CSV file unless you explicitly read it as a different format. If you want to keep it in Google Sheets format for easier collaboration, use File > read > Google Sheets to save a copy in that format.