In this tutorial, you will learn how to import a CSV into Google Sheets.
How To Import CSV Into Google Sheets
Quick Navigation
If you’ve been given a CSV file that you need to open in Google Sheets, you might be wondering how to get it done. CSV files are a great way to transfer data between different programs.
They’re also easy to create since they are simply files with a list of values separated by commas or some other delimiter. In this guide, we’ll show you how to import CSV files into Google Sheets.
How To Add Data from a CSV Into Google Sheets
Here’s how to add data from a CSV to Google Sheets
Step 1
First, open the Google Sheets document where you want to import your CSV data into.
Step 2
Next, go to File > Import to access Google Sheets’ various import options.
Step 3
If you want to upload a local CSV file, head to the Upload tab in the Import file dialog box.
You can choose to either select your CSV by dragging the file into Google Sheets or by selecting the file using your device’s File Selector program.
Step 4
If you choose the Select a file from your device option, navigate to the folder that contains your file. Once you’ve located your file, select it and click Open.
Step 5
If you choose to add your CSV data into the current file, you can choose to insert the data in a new sheet, replace the current spreadsheet, replace the current sheet, append to current sheet, or replace the data at the selected cell.
Step 6
Click on the Import data option to apply the indicated import option.
In this example, we’ve decided to import our CSV data with the Append to current sheet option.
Step 7
If your file has already been uploaded to Google Sheets, you can select your CSV file through the My Drive tab in the Import file dialog box.
Search for your file using the provided search box. Click on the CSV file and hit the Select button.Step 8
Similar to the previous method, you will be able to choose the import location of your CSV data.
Step 9
Step 10
The IMPORTDATA will automatically add the data from the link into the current sheet.
Summary
This guide should be everything you need to import a CSV into Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.