Different applications and systems generate reports in different formats. Considering the huge volume of data it can handle, CSV is a popular format for such reports. In this tutorial, you will learn how to import CSV files to Google Sheets.
This way, you can work on a wide range of data from different applications. By using the methods given below, you’ll never have to worry about compatibility issues.
2 Methods of importing CSV files to Google Sheets:
- Use the Open option under the File menu
- Use a keyboard shortcut
Let us begin by looking at these methods one by one.
Method #1: Use the Open Option under the File Menu
This is a useful method if you are new to Google Sheets.
Step #1: Open a blank spreadsheet
On the Google Sheets site, click on the big plus sign in the box above Blank to open a new blank spreadsheet.
If you already have an existing spreadsheet, open that.
Step #2: Go to the File menu and click on Open
In the top left corner of the spreadsheet, you will see the File menu.
Click on it for a submenu to appear.
Click on Open.
Step #3: Select the upload option
Depending on where the CSV file is located, you can either select:
– My Drive (Google Drive) or
– Upload (from Computer).
If the CSV file is saved on your computer hard drive, you would select Upload (from Computer).
For this tutorial, we’ve used the Upload option. Once you click on the Upload tab, you can either:
- Drag and drop your CSV file onto the white space.
- Click on the Select a file from your device button to browse and upload files.
If you use the My Drive option, you can directly select the files displayed under the My Drive option.
Step #4: Select the file and upload
In the File Upload window, select the CSV file and click on the Open button.
Step #5: Start editing/working on the file
After opening the desired CSV file in Google Sheets, you can start editing/working on it.
Method #2: Use a Keyboard Shortcut
This method is helpful for individuals who have used Google Sheets before. If you are well versed with keyboard shortcuts, this should be your go-to method.
Step #1: Open a blank spreadsheet
On the Google Sheets site, click on the big plus sign in the box above Blank to open a new blank spreadsheet.
If you already have an existing spreadsheet, open that.
Step #2: Apply the keyboard shortcut
Press Ctrl + O on your keyboard to launch the Open a file window.
Depending on where the CSV file is located, you can either select:
– My Drive (Google Drive) or
– Upload (from Computer).
If the CSV file is saved on your computer hard drive, you would select Upload (from Computer).
For this tutorial, we’ve used the Upload option. Once you click on the Upload tab, you can either:
- Drag and drop your CSV file onto the white space.
- Click on the Select a file from your device button to browse and upload files.
If you use the My Drive option, you can directly select the files displayed under the My Drive option..
Step #3: Select the file and upload
In the File Upload window, select the CSV file and click on the Open button.
Step #4: Start editing/working on the file
After opening the desired CSV file in Google Sheets, you can start editing/working on it.
Conclusion
Stuck with a CSV file from your ERP or any other application system? Use any of the methods given above and let Google Sheets handle the compatibility issues. Later, you can work on the data like any other spreadsheet. Happy learning!