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

To illustrate, let’s assume the Fruit Sales Data shown in the B4:E13 is what we want to copy and paste from Excel to Google Sheets.

how to copy and paste from excel to google sheets


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

Steps:

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

Using Keyboard Shortcut

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

Pasting data

You’ve copied and pasted the data from Excel to Google Sheets.

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


Method 2 – Applying Paste Special

Steps:

  • Choose the B2:E15 cells >> hit the CTRL + C keys to copy the data.

Applying Paste Special

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

Using Paste Special

This pastes only the values from the Excel file.

  • Press the CTRL + ALT + V keys to apply the formatting to the cells.

Applying Formatting

The results should look like the image shown below.

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


Method 3 – Utilizing the Import Option

Steps:

  • Click the File tab >> select the Import option.

Utilizing the Import Option

  • In the Import file wizard, press Upload >> click the Select a file from your device option.

Uploading Excel file

  • Select the required Excel file, e.g. Copying and Pasting from Excel to Google Sheets.xlsx >> press the Open button.

Choosing file

  • Select the Insert new sheets option >> insert a check mark for Import Theme >> hit the Import Data button.

Importing data

The output should look like the image below.

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


Method 4 – Employing IMPORTRANGE Function to Copy and Paste from Excel to GoogleSheets

Steps:

  • Upload the Excel file into Google Drive >> open the spreadsheet.

Employing IMPORTRANGE Function

  • Navigate to the File tab >> click the Save as Google Sheets option.

Saving as Google Sheets

  • Copy the URL of the spreadsheet by pressing the CTRL + C keys.

Copying URL

  • Go to the B4 cell >> enter the formula 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 formula, the B4:E15 range refers to the Item, Unit Price, Quantity, and Cost columns.

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

  • Apply the formatting to the cells according to your preference.

Formatting Cells

The final output should look like the image 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?

Steps:

  • 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

  • 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

Steps:

  • 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

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

Choosing Format only option

This inserts the cell formatting as shown in the image below.

  • Hit the CTRL + SHIFT + V keys to paste the values.

Pasting Values

The final output should look like in the image 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

When trying to paste data into Google Sheets with the Edit menu, you may see a message pop up, telling you to use the CTRL + C keys instead.

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

For security concerns, websites cannot access your computer’s clipboard, so Google Sheets cannot paste the data from the clipboard. There is a simple fix for this. Just install the Google Docs Offline extension for your browser and you are good to go.

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

 


Download Practice Workbook


Related Articles

<< Go Back to Export Data from Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Eshrak Kader
Eshrak Kader

Eshrak Kader is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He boasts a rich background in Microsoft Office Suite, and over the past year, he has authored over 120 insightful articles for the ExcelDemy. Currently, Eshrak leads a team of 5 in the ExcelDemy Video project and enjoys problem-solving and making videos on Excel. Eshrak’s passion for continuous learning underscores his commitment to excellence in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo