Sometimes we need to create Google Sheets by copying data from an Excel file. Because Google Sheets give us security from losing data, and we can share it easily with others. There are many ways to copy from Excel to google sheets but in this article, we’ll show 4 easy ways with simple steps and illustrations.
Download Practice Workbook
You can download the free Excel workbook from here and practice independently.
4 Easy Ways to Copy from Excel to Google Sheets
Here’s our sample dataset in a worksheet containing some students’ obtained marks in three subjects.
1. Using Shortcut Keys to Copy from Excel to Google Sheets
Firstly, we’ll learn the easiest ways to copy from excel to google sheets and that is using the basic copying shortcut keys- Ctrl + C and Ctrl + V. the benefit of using this method is you will be able to copy any specific range from your sheet.
- Select the dataset from your Excel worksheet.
- Then press Ctrl + C to copy.
- Later, open Google Sheets and select a cell where you want to paste.
- Finally, just press Ctrl + V to paste.
2. Using Import Command to Transfer Excel File to Google Sheets
When you want to copy or transfer all data from your worksheet then the best way is to import data from the Excel file. You can import from any source like File explorer or drive.
- Open a Google sheet first.
- Then click File > Import.
After that, a dialog box will open up to choose a file.
- Select My Drive to open a file from your drive and select Upload to open from the file on your computer. We’ll upload from file explorer so chose ‘Select a file from your device’. Also, you can drag a file to upload.
- Choose the Excel file from your device and press Open.
- Next, choose the import location, and we selected Create new spreadsheet.
- Finally, just press Import data.
Now you see, the data is imported and it automatically picked the same file name.
3. Copying from Excel to Google Sheets with Formulas
If an Excel file is saved in CSV format then we can use a function to load data from the file. For that, we’ll need the IMPORTDATA function. And we’ll need the direct download link of the file otherwise it won’t work. So, in this method, we’ll learn how to copy from excel to google sheets with formulas.
We used this download link for the sample CSV file: https://www2.census.gov/programs-surveys/popest/datasets/2010-2019/national/totals/nst-est2019-alldata.csv
- Activate any cell in your google sheet. We activated Cell A1.
- Then insert the following formula there-
- Hit the Enter button and then it will take some to load data.
Now see, all the data from the CSV file is copied properly.
4. Open with Google Sheets from Drive to Copy from Excel
If your Excel file is in your Google Drive then you can easily copy data from the Excel file just by opening it in Google Sheets. To show this method, we uploaded our file to Google Drive.
- Right-click your mouse on the Excel file.
- After that, from the context menu, click as follows: Open with > Google Sheets.
Now look, Google Sheets has copied the data from the XLSX file by opening it.
- Some Excel formula doesn’t work in Google Sheets.
- Macro doesn’t work in Google Sheets.
- The formats may vary a little bit from the original Excel file.
That’s all for the article. I hope the procedures described above will be good enough to copy from Excel to Google Sheets. Feel free to ask any question in the comment section and please give me feedback. Visit ExcelDemy to explore more.