Later I will show you how to convert files from CSV to Google Sheets in Google Drive, and I will also show you how to simply copy and paste an entire CSV, but for now let's go over the importing CSVs directly into a Google spreadsheet, in more detail. Join the full the Google Sheets Dashboards Course The video below will first show you how to import a CSV into Google Sheets, and then if you would like, you can follow the rest of the video to learn how to build a dashboard in Google Sheets.ĭownload the 'Revenue Report' CSV to follow along with the video below.

I have found this option to be the most valuable in my work, as it allows you to specify exactly where to import. Then after selecting your file, in the 'Import file' options, under the 'Import location' section, select ' Replace data at selected cell'. the cell where you want the top left of the imported data set to be). If you want to import data starting at an exact cell, before clicking 'File' / 'Import', select the cell where you want the data to begin (i.e. Click here to learn how to export CSV files from your Google spreadsheets. Now that you know how to import a CSV file, you may also be interested in learning how to export a CSV file from Google Sheets. Select your preferences / settings in the 'Import File' menu, such as 'Replace data at selected cell'.Select / double click the CSV file that you want to import.Choose the folder on your computer that contains the CSV file that you want to import.Click 'Upload' (Alternatively, you can choose to select a file from your Google Drive).Open a new or existing Google spreadsheet that you want to import the CSV data into.

To import a CSV into Google Sheets, follow these steps: Additionally, I will show you how to convert CSV files into Google Sheets format through Google Drive. Sometimes copying and pasting can be very effective, and so I'll teach you this method as well, but for the most part it is way faster to use the 'Import' feature that is built into Google Sheets. Several years ago, I didn't know that there was a super easy way to import CSV files into Google Sheets… and so I spent lots of time copying and pasting entire CSV files into my Google spreadsheets.

Open csv in google sheets