In this article:

Import CSV to Google Sheets (The Easy Way in 2024!)

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 will appear. Drop the file and it will be uploaded to Google Drive. 

how to import csv file into google sheets, drag file to upload 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.

how to import csv file into google sheets, opening file in google sheets 

Alternatively, you can right-click the CSV file, select Preview.

how to import csv file into google sheets, right-click the file in google drive, 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.

how to import csv file into google sheets, preview shown, with open with google sheets as main option on top

A new tab will load, opening the file in Google Sheets.

how to import csv file into google sheets, opening file in google sheets in new tab

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.

how to import csv file into google sheets, file, save as google sheets highlighted

A new tab will load, showing the csv file finally converted to Google Sheets format.

how to import csv file into google sheets, csv imported and converted to google sheets.

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 and select Import.

The File option is located in the File Menu in the top left corner of Google Sheets.

google sheets import csv, click file, select import

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.

google sheets csv import file box

A space for uploading the CSV file appears. 

google sheets csv import file box, upload option, space for uploading files


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.

google sheets csv import file box, drag csv file screencap

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. 

google sheets import csv, specify import file settings

For the Import location, you can do one of the following:

google sheets import csv, specify import file settings, select where to insert data

  • 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. 

google sheets import csv, specify import file settings, create new spreadsheet option selected, link to new spreadsheet appears

  • 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. 

google sheets import csv, specify import file settings, replace spreadsheet option selected, warning about all existing data removed shown

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.

google sheets import csv, specify import file settings, text box for defining custom separator shown

To show how good Google Sheets’ ability to detect the separator in the file, we will select Detect automatically

google sheets import csv, specify import file settings, replace data at selected cell and automatically detect separator type

4. Click Import data

You have successfully imported CSV to Google Sheets. 

how to import csv file into google sheets, data from csv file imported to the sheet

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started