How to Copy and Paste from Excel to Google Sheets (4 Ways)

Get FREE Advanced Excel Exercises with Solutions!

Undoubtedly, Excel is a popular and useful tool for analyzing and manipulating large sets of data. Sometimes, you may need to copy and paste your data from Excel into Google Sheets Therefore, knowing a couple of handy methods can save a lot of time and effort. Granted this, in this article, we’ll explore 4 ways how to copy and paste from Excel to Google Sheets. In addition, we’ll also discuss how to copy-paste formulas, preserve formatting, and troubleshoot copy-paste when it is malfunctioning.

Let’s assume the Fruit Sales Data shown in the B4:E13 cells contains the Item, Unit Price, Quantity, and Cost of each Item respectively. Here, we want to copy and paste from Excel to Google Sheets. Therefore, let’s glance at the methods shown below with easy and simple illustrations.

how to copy and paste from excel to google sheets

Here, we have used the Microsoft Excel 365 version, you may use any other version according to your convenience.


1. Using the Keyboard Shortcut to Copy and Paste from Excel to Google Sheets

First of all, let’s start with the most obvious to copy and paste data from Excel to Google Sheets, simply put, we’ll use the CTRL + C and CTRL + V keyboard shortcuts, hence, let’s see the process in detail.

📌 Steps:

  • Initially, select the B2:E15 cells >> press the CTRL + C keys to copy the data from the Excel worksheet.

Using Keyboard Shortcut

  • Next, open a spreadsheet in Google Sheets >> hit the CTRL + V keys to paste the data.

Pasting data

Voila! Just like that you’ve copied and pasted the data from Excel to Google Sheets. It’s that simple.

how to copy and paste from excel to google sheets with keyboard shortcut


2. Applying Paste Special

Alternatively, you can use the Paste Special option to specify whether you want to paste only values, formatting, or both. In this case, we’ll paste the values first, then we’ll apply the formatting to the dataset. Therefore, let’s start.

📌 Steps:

  • First and foremost, choose the B2:E15 cells >> hit the CTRL + C keys to copy the data.

Applying Paste Special

  • Then, open a new spreadsheet >> Right-click in any cell >> move to Paste Special >> choose the Values only option.

Using Paste Special

Now, this pastes only the values from the Excel file.

  • Afterward, press the CTRL + ALT + V keys to apply the formatting to the cells.

Applying Formatting

Lastly, the results should look like the image shown below.

how to copy and paste from excel to google sheets with Paste Special


3. Utilizing the Import Option

Conversely, you can also apply the Import option to copy and paste from Excel to Google Sheets. So, let’s see it in action.

📌 Steps:

  • At the very beginning, click the File tab >> select the Import option.

Utilizing the Import Option

In an instant, the Import file wizard appears.

  • Now, press Upload >> click the Select a file from your device option.

Uploading Excel file

  • Not long after, select the Excel file, here it is Copying and Pasting from Excel to Google Sheets.xlsx >> press the Open button.

Choosing file

  • Following this, select the Insert new sheets option >> insert a check mark for Import Theme >> hit the Import Data button.

Importing data

Finally, the output should look like the picture given below.

how to copy and paste from excel to google sheets with Import Option

Read More: How to Import Data from Excel to Google Sheets


4. Employing IMPORTRANGE Function to Copy and Paste from Excel to GoogleSheets

If you’re one of those people who enjoy using functions, then our next method has you covered. Here, we’ll employ the IMPORTRANGE function to bring in the data from a range of cells in the provided spreadsheet. Now, allow us to demonstrate the process in the steps below.

📌 Steps:

  • First, upload the Excel file into Google Drive >> open the spreadsheet.

Employing IMPORTRANGE Function

  • Second, navigate to the File tab >> click the Save as Google Sheets option.

Saving as Google Sheets

  • Next, copy the URL of the spreadsheet by pressing the CTRL + C keys.

Copying URL

  • Third, jump to the B4 cell >> enter the expression given below >> click the Allow access option.

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1GeFnbAIaDFcWEy_3mL9G_X2k2AzZIPo_7NPhR2PPw-Q/edit#gid=1168615131","Sheet1!B4:E15")

In this expression, the B4:E15 range refers to the Item, Unit Price, Quantity, and Cost columns respectively.

Formula Breakdown:

  • IMPORTRANGE(“https://docs.google.com/spreadsheets/d/1GeFnbAIaDFcWEy_3mL9G_X2k2AzZIPo_7NPhR2PPw-Q/edit#gid=1168615131″,”Sheet1!B4:E15”) → imports a range of cells from a specified spreadsheet. Here, “https://docs.google.com/spreadsheets/d/1GeFnbAIaDFcWEy_3mL9G_X2k2AzZIPo_7NPhR2PPw-Q/edit#gid=1168615131” represents the spreadsheet_url argument which refers to the uploaded Excel file while the “Sheet1!B4:E15” represents the range_string argument which returns the range of cells from the specified sheet.

📃 Note: Please make sure to grant access to the spreadsheet by clicking the Allow access button.

Using IMPORTRANGE function

  • Fourth, apply the formatting to the cells according to your preference.

Formatting Cells

Eventually, the final output should look like the screenshot shown below.

how to copy and paste from excel to google sheets with IMPORTRANGE function


How to Copy and Paste Formulas from Excel to Google Sheets

So far we’ve seen copying and pasting the values with formatting, what if you want to copy and paste formulas from Excel to Google Sheets? Well, you’re in luck because the following section answers this exact question. Hence, just follow along.

📌 Steps:

  • To begin with, select the B2:E15 cells >> press the CTRL + ~ (Tilde character) >> hit the CTRL + C.

How to Copy and Paste Formulas from Excel to Google Sheets

  • In turn, press the CTRL + V keys to paste the data into Google Sheets with the formulas.

how to copy and paste formulas from excel to google sheets


How to Copy and Paste from Excel to Google Sheets Without Changing Format

On the other hand, you can also copy and paste from Excel to Google Sheets while preserving the cell formatting. It’s simple & easy, just follow the steps shown below.

📌 Steps:

  • To begin with, choose the B2:E15 cells >> type in the CTRL + C keys to copy the data.

How to Copy and Paste from Excel to Google Sheets without Changing Format

  • Later, in a new spreadsheet, Right-click in one of the cells >> proceed to Paste Special >> select the Format only option.

Choosing Format only option

Now, this inserts the cell formatting as shown in the image below.

  • From this point, hit the CTRL + SHIFT + V keys to paste the values.

Pasting Values

Subsequently, the final output should appear in the picture given below.

how to copy and paste from excel to google sheets with formatting


What to Do If Copy and Paste from Excel to Google Sheets Is Not Working

Admittedly, when trying to paste data into the Google Sheets with the Edit menu, you may see a message pop up, telling you to use the CTRL + C keys instead. So, let’s understand this message (shown below) and learn about the workaround process regarding this issue.

Extension for Copy and Paste from Excel to Google Sheets Not Working

In a nutshell, for security concerns, websites cannot access your computer’s clipboard, so Google Sheets cannot paste the data from the clipboard. Nonetheless, there is a simple fix, just install the Google Docs Offline extension for your browser and you are good to go.

It really is that simple.

Read More: [Solved:] Copy Paste from Excel to Google Sheets Not Working


Practice Section

We have provided a Practice section on the right side of each sheet so you can practice yourself. Please make sure to do it by yourself.

Practice Section


Download Practice Workbook


Conclusion

In essence, this article shows 4 handy ways how to copy and paste from Excel to Google Sheets. So, read the full article carefully and download the free workbook to practice. Now, we hope you find this article helpful and if you have any further queries or recommendations, please feel free to comment here.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Eshrak Kader
Eshrak Kader

Hello! Welcome to my Profile. I completed my BSc. at Bangladesh University of Engineering & Technology from the Department of Naval Architecture & Marine Engineering. Currently, I am conducting research & posting articles related to Microsoft Excel. I am passionate about research & development and finding innovative solutions to problems.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo