How to Copy and Paste from Google Sheet to Excel with Formulas

2
735
copy paste formula - Excel and Google Sheets

In this post we will check two aspects of the copy and paste formulas between two popular spreadsheet applications – Excel and Google Sheets. First thing is copy and paste from Google Sheet to Excel with formulas and the next the opposite to it. That means copy formulas from Excel to Google Sheets.

What Happens Normally When You Copy and Paste from Two Different Spreadsheet Applications?

When you copy and paste from Google Sheet to Excel Spreadsheet, you may lose your formulas. The same will be happen with the copied data from Excel to Google Spreadsheets. Is there any solution? Yes. Here is the solution to copy and paste from Google Sheet to Excel with Formulas and vice a versa.

Copy and Paste from Google Sheet to Excel with Formulas

You will normally copy some ranges or an entire Google Sheet and then open a Microsoft Excel spreadsheet and paste it. The copied data will be get pasted but only text and numbers. Your formulas in Google Sheets are missing! You will see the results of the formulas. There is no paste special option to paste the content as it is.

Solution:

In Google Sheets before copying do as follows. First go to View Menu and enable Show Formula. Then copy the content and paste to Excel. Your Google Spreadsheet data will be copied to Excel retaining the text, numbers and Formulas.

Some times it may not work due to software update or some other reason which is not in our hand. In this case you may first paste the copied content in the Office 365 Excel spreadsheet on your browser. Now copy that content as it is, when you copy using Ctrl+C, give few seconds to Excel to properly copy the content, and then paste on Excel offline application.

Copy and Paste from Google Sheet to Excel with Formulas

Copy Data from Excel to Google Sheets with Formulas

To copy data from Excel to Google Sheets with Formulas, use the keyboard shortcut Ctrl+~ in Excel. This will enable the formula view in Excel. Now copy the data and paste it directly in Google Sheets. It will work.

Hope you liked this hidden Google Sheet and Excel tips. You can send us similar tips with us in comments or mail to us using the contact form above navigation menu.

2 COMMENTS

  1. Unfortunately it doesn’t work anymore (Google Sheets as of 11/3/2017, Excel 2016). Just copies a 0 into any place where a formula was that references any other cell. (Purely mathematical formulae that don’t reference other cells do seem to copy in OK)

    • Hi Peter,

      I’ve also noticed that. It’s now working like this. But only possible if you have access to Excel Online.

      1. On Google Sheets, use the short cut Ctrl+~ (Show formula)
      2. Copy the formula, then paste it into Excel Online.
      3. Copy from Excel Online and open Excel Offline.
      4. There also use the keyboard short cut Ctrl+~ (Show formula)
      5. Paste the content copied from Excel Online.
      6. Again apply keyboard short cut Ctrl+~ (Show formula)

      Thanks.

LEAVE A REPLY

Please enter your comment!
Please enter your name here