Import CSV to Google Sheets (The Easy Way in 2023!)
In this article we will show you how to import a CSV file into Google Sheets in just a few clicks. Simply follow the steps below.
How to Import a CSV into Google Sheets
Import a CSV Via Google Drive
This is the simplest method you can use. This is ideal if the CSV contains all the data you need.
1. Drag the CSV file into your Google Drive
Open Google Drive, then drag your file over the screen. A small box saying Drag files to upload them willappear. Drop the file and it will be uploaded to Google Drive.
2. Double-click the File in Google Sheets
The CSV will be listed with your other files after the upload process is complete. Double-click the CSV and it will start loading in Google Sheets.
Alternatively, you can right-click the CSV file, select Preview.
A preview will appear, with a button on top allowing you to choose the app to use for opening the file. Click Open with Google Sheets on top of the preview.
A new tab will load, opening the file in Google Sheets.
3. Save as Google Sheets
The file can now be opened in Google Sheets! However, to fully use the features of Google Sheets, you need to convert the file to Google Sheets format. Click File, then select Save as Google Sheets.
A new tab will load, showing the csv file finally converted to Google Sheets format.
Import a CSV Via Google Sheets
If you have existing Google Sheets spreadsheets and want to import data from a csv file to those sheets, follow the steps below.
1. Click File andselect Import.
The File option is located in the File Menu in the top left corner of Google Sheets.
2. Click Upload then Drag CSV File to Upload It
A box labeled Import file will load. It gives you options to:
Select a file from your Google Drive
From the files shared with you
Upload a file from your computer
For our example, we want to upload a csv file from our computer to Google Sheets. Click Upload.
A space for uploading the CSV file appears.
Click Browse and a window will open where you can find the file on your computer, or you can drag and drop the file into the upload area.
3. Set Import location and Separator type
Once the file is read by Google Sheets, you will be given options to set where to insert the data from the CSV and the separator used by the file.
For the Import location, you can do one of the following:
Create new spreadsheet - a new spreadsheet will be created containing the data from the CSV file. After clicking Import data, a message will appear in the box saying File imported successfully. Open now. You can click the link to access the spreadsheet.
Insert new sheet(s) - a new sheet will be inserted into the current sheet containing the data from the CSV file. The new sheet will be named the same as the filename of the CSV file.
Replace spreadsheet - the current spreadsheet will be replaced by the data from the imported CSV file. The data stored in the current spreadsheet will be destroyed in the process.
The new spreadsheet with the data from the CSV file will be automatically loaded after being created.
Replace current sheet - the active sheet will be replaced with a new one with the data from the CSV file. The data in the current sheet will be destroyed in the process.
Append to current sheet - the data from the CSV file will be inserted at the end of the active sheet.
Replace data at selected cell - the data from CSV file will be inserted to the active sheet starting from the selected cell. It will replace all data within the range that the data from the CSV file will cover.
For our example, we will select Replace data at selected cell.
For the separator type, you can choose from the following options:
Detect automatically - Google Sheets will analyze the file and determine what the separator is (Usually the easiest option)
Tab - best for files that use tabs to separate columns (TSV files)
Comma - best for CSV files
Custom - if you use an uncommon character as a separator, you need to specify it by selecting this option. A text box will appear where you can define the specific separator.
To show how good Google Sheets’ ability to detect the separator in the file, we will select Detect automatically.
4. Click Import data
You have successfully imported CSV to Google Sheets.