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.
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.
- First and foremost, go to your Google Sheet window.
- Subsequently, go to the File tab >> Import tool.
- As a result, the Import file window will appear.
- Following, click on the Upload button >> Select a file from your device button.
- As a result, the Open window will appear.
- Subsequently, click on your desired Excel file and click on the Open button.
- 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.
As a result, the Excel will be copied to your Google Sheets in new sheets. And, the Google Sheet would look like this.
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.
- 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.
- 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.
- Afterward, go to your Google Sheet file.
- Now, right-click on any cell and choose the Paste option from the context menu.
- At this time, select the dataset where you replaced the equal sign with backslash >> go to Edit tab >> Find and Replace tool.
- 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.
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.
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.
- 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.
- 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.
Thus, you will find the formulas working in your Google Sheets properly.
💬 Things to Remember
If you randomly copy data from an Excel file to Google Sheets, it would only copy the values, not the formulas.
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!