How to extract data from Excel or CSV file into Google Sheets
Note: Google Data Studio is now known as Looker Studio.
In order to pull data from Excel or CSV file into Google Sheets, follow the steps below:
Step-1: Navigate to your Google Drive account: https://drive.google.com/drive/my-drive
Step-2: Click on the ‘+New’ button on the left-hand side:
Step-3: Click on the ‘File Upload’ option and then upload the CSV/Excel file you want to use in Google Sheets:
Step-4: Once the upload is complete, double click on the uploaded file:
This action would open the file.
Step-5: Click on the ‘Try it now’ button:
Note: If you don’t see this green circle then click on the option ‘Open with Google Sheets‘. Sometimes you may not see the option ‘Open with Google Sheets’. You may instead see the ‘Open with‘ drop-down menu. If that’s the case then click on the ‘Open with‘ drop-down menu and then click on ‘Google Sheets’:
You may now see the following dialog box like the one below:
At this point, you can take a tour of the office editing feature by clicking on the ‘take a tour’ button or simply close the dialog box.
Let’s take the tour.
Google will now automatically open your CSV/Excel file with Google Sheets:
Step-6: Click on ‘Save as Google Sheets’ from the ‘File’ menu:
Google will now save your CSV/Excel file as Google Sheets and automatically open it in a new tab:
That’s how you can pull data from Excel or CSV file into Google Sheets.
Other Articles on Google Sheets
- How to use Looker Studio with Google Sheets
- How to extract data from Google Ads to Google Sheets
- How to use Supermetrics for Google Sheets Add-on
- Connect and transfer data from Google Sheets to BigQuery
- Sending data from Google Search Console to Google Sheets
- Supermetrics Queries for Google Sheets – Tutorial
- Google Sheets & Looker Studio Timezone Conversion
- How to extract data from Google Analytics into Google Sheets
- Looker Studio Date Format for Google Sheets – Tutorial
- Learn to export Facebook ads data to Google Sheets
- Understanding Aggregation in Google Sheets
Note: Google Data Studio is now known as Looker Studio.
In order to pull data from Excel or CSV file into Google Sheets, follow the steps below:
Step-1: Navigate to your Google Drive account: https://drive.google.com/drive/my-drive
Step-2: Click on the ‘+New’ button on the left-hand side:
Step-3: Click on the ‘File Upload’ option and then upload the CSV/Excel file you want to use in Google Sheets:
Step-4: Once the upload is complete, double click on the uploaded file:
This action would open the file.
Step-5: Click on the ‘Try it now’ button:
Note: If you don’t see this green circle then click on the option ‘Open with Google Sheets‘. Sometimes you may not see the option ‘Open with Google Sheets’. You may instead see the ‘Open with‘ drop-down menu. If that’s the case then click on the ‘Open with‘ drop-down menu and then click on ‘Google Sheets’:
You may now see the following dialog box like the one below:
At this point, you can take a tour of the office editing feature by clicking on the ‘take a tour’ button or simply close the dialog box.
Let’s take the tour.
Google will now automatically open your CSV/Excel file with Google Sheets:
Step-6: Click on ‘Save as Google Sheets’ from the ‘File’ menu:
Google will now save your CSV/Excel file as Google Sheets and automatically open it in a new tab:
That’s how you can pull data from Excel or CSV file into Google Sheets.
Other Articles on Google Sheets
- How to use Looker Studio with Google Sheets
- How to extract data from Google Ads to Google Sheets
- How to use Supermetrics for Google Sheets Add-on
- Connect and transfer data from Google Sheets to BigQuery
- Sending data from Google Search Console to Google Sheets
- Supermetrics Queries for Google Sheets – Tutorial
- Google Sheets & Looker Studio Timezone Conversion
- How to extract data from Google Analytics into Google Sheets
- Looker Studio Date Format for Google Sheets – Tutorial
- Learn to export Facebook ads data to Google Sheets
- Understanding Aggregation in Google Sheets
My best selling books on Digital Analytics and Conversion Optimization
Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.
Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.
Attribution Modelling in Google Analytics and BeyondSECOND EDITION OUT NOW!
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.
Attribution Modelling in Google Ads and Facebook
This book has been written to help you implement attribution modelling in Google Ads (Google AdWords) and Facebook. It will teach you, how to leverage the knowledge of attribution modelling in order to understand the customer purchasing journey and determine the most effective marketing channels for investment.
About the Author
Himanshu Sharma
