Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

When working with Excel files, sometimes we need to copy data to google sheets for more people’s access. But when copying from Excel by default, the formulas don’t get copied. In this article, I will show you 2 effective ways to copy from Excel to google sheets with formulas.


Download Practice Workbook

You can download our practice workbook from here for free!


2 Effective Ways to Copy from Excel and Paste to Google Sheets with Formulas

Say, you have a sample dataset and calculation for your Return on Investment. Now, you need to copy the dataset and calculations from Excel to google sheets with formulas. Follow any of the 3 given ways below to do this.

2 Effective Ways to Copy from Excel and Paste to Google Sheets with Formulas


1. Using the Import Tool of Google Sheets to Copy Excel Data with Formulas

The easiest way to copy from Excel to Google Sheets with formulas is to use the Import tool of Google Sheets. Follow the steps below to accomplish your result in this way.

📌 Steps:

  • First and foremost, go to your Google Sheet window.
  • Subsequently, go to the File tab >> Import tool.

Choose Import Tool to Copy from Excel to Google Sheets with Formulas

  • As a result, the Import file window will appear.
  • Following, click on the Upload button >> Select a file from your device button.

Upload File to Copy from Excel to Google Sheets with Formulas

  • As a result, the Open window will appear.
  • Subsequently, click on your desired Excel file and click on the Open button.

Choose your Excel File to Copy to Google Sheets with Formulas

  • Thus, the Import file window will appear again and the file will be loaded.
  • At this time, choose the Import location as the Insert new sheet(s) option and click on the Import Data button.

Click on Import Data Button to Copy from Excel to Google Sheets with Formulas

As a result, the Excel will be copied to your Google Sheets in new sheets. And, the Google Sheet would look like this.

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


2. Using Find & Replace Tool

Another effective way to copy from Excel to Google Sheets with formulas is to use the Find & Replace tool. Follow the steps below to do this.

📌 Steps:

  • At the very beginning, go to your Excel file.
  • Following, select the dataset that you want to copy >> go to Home tab >> Editing group >> Find & Select option >>> Replace… tool.

Access the Replace Tool to Copy from Excel to Google Sheets with Formulas

  • Consequently, the Find and Replace window will appear.
  • Subsequently, go to the Replace tab >> insert equal sign (=) in the Find what: text box >> insert backslash (\) in the Replace with: text box >> click on the Replace All button.

Excel Find and Replace Window

  • Afterward, go to your Google Sheet file.
  • Now, right-click on any cell and choose the Paste option from the context menu.

Choose the Paste Option

  • At this time, select the dataset where you replaced the equal sign with backslash >> go to Edit tab >> Find and Replace tool.

Access the Google Sheets Find and Replace Tool to Copy from Excel to Google Sheets with Formulas Properly

  • As a result, the Google Sheet’s Find and Replace window will appear.
  • Subsequently, put a backslash (\) inside the Find text box and insert the equal sign (=) in the Replace with text box.
  • Last but not least, click on the Replace All button.

Google Sheet Find and Replace Window

As a result, you will find all your dataset copied from Excel to Google Sheets with exact formulas. And, the output should look like this.

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


How to Resolve If Excel Formulas Are Not Working in Google Sheets

Sometimes it might happen that you have copied formulas in Google Sheets from Excel. But the formulas are not working properly. In this case, follow the steps below to work your formula.

📌 Steps:

  • First, press the F5 key on your keyboard to refresh the sheet.
  • If still the formula doesn’t work, go to the File tab.
  • Subsequently, choose the Settings option from the File menu.

Access the Settings Option

  • At this time, the Settings for this spreadsheet window will appear.
  • Following, go to the Calculation tab here >> choose the option Recalculation as On change and every minute >> click on the Save settings button.

Click on Save Settings Button

Thus, you will find the formulas working in your Google Sheets properly.

Read More: Differences Between Excel and Google Sheets Formulas


💬 Things to Remember

If you randomly copy data from an Excel file to Google Sheets, it would only copy the values, not the formulas.


Conclusion

So, in this article, I have shown you 2 effective ways to copy from Excel to Google Sheets with formulas. I suggest you read the full article carefully and practice accordingly. I hope you find this article helpful and informative. And, you are very welcome to comment here if you have any further questions or recommendations regarding this article.

Visit ExcelDemy to learn about many more Excel problem solutions, tips, and tricks. Thank you!


Related Articles

Tanjim Reza

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo