How to Copy from Excel to Google Sheets (4 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

How to Copy from Excel to Google Sheets


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.

Steps:

  • Select the dataset from your Excel worksheet.
  • Then press Ctrl + C to copy.

Using Shortcut Keys to Copy from Excel to Google Sheets

  • Later, open Google Sheets and select a cell where you want to paste.
  • Finally, just press Ctrl + V to paste.

Read More: How to Convert Excel Sheet to Google Sheets (3 Easy Ways)


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.

Steps:

  • Open a Google sheet first.
  • Then click File > Import.

Using Import Command to Transfer Excel File to Google Sheets

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.

Select a File to Transfer Excel File to Google Sheets

  • 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.

Read More: How to Import Data from Excel to Google Sheets (2 Easy Ways)


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

Steps:

  • 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.

Copying from Excel to Google Sheets with Formulas

Now see, all the data from the CSV file is copied properly.

Read More: How to Copy from Excel and Paste to Google Sheets with Formulas


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.

Open with Google Sheets from Drive to Copy from Excel

Steps:

  • Right-click your mouse on the Excel file.
  • After that, from the context menu, click as follows: Open with > Google Sheets.

Select Google Sheets from the Context Menu to Copy from Excel

Now look, Google Sheets has copied the data from the XLSX file by opening it.

Read More: How to Sync Excel to Google Sheets (with Simple Steps)


Remarks

  • 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.

Conclusion

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.


Related Articles

Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Hello! I am Md. Sourov Hossain Mithun. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is an amazing software to learn or work. Here, I will post Excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo