In recent years, Google Sheets has become a strong alternative to Excel. As more and more people are using Google Sheets and the number of Excel users is also showing no sign of stopping, the interchange between the two data storage software is becoming more frequent. However, there are some formulas in Google Sheets that are not compatible with Excel. This creates problems while converting Google Sheets to Excel. Thus, this article will show how to convert Google Sheets to Excel with formulas.
In this article, we will show 5 examples of how to convert google sheets to Excel with formulas. The examples include 5 basic operations of mathematics, namely: addition, subtraction, multiplying, dividing, and raising a number to a certain power.
1. Adding Two Values
In this example, we will perform addition both in Google Sheets and Excel and show how the formula changes while we convert Google Sheets to Excel. We will basically add two numbers by using the ADD and SUM functions in Google Sheets and Excel respectively.
Steps:
- Firstly, select the C7 cell in the Google Sheets and enter the following formula,
=ADD(C5,C6)- Then, hit Enter.
- As a result, the addition will be done.
- After that, go to the File tab.
- From the available option, select Download.
- Finally, download the sheet in Microsoft Excel (.xlsx) form.
- Then, open the downloaded Excel file.
- We will see that the formula in the Google Sheet is not compatible with Excel.
- To do the right calculation, select the C7 cell in the Excel file and cut the previous formula.
- After that, enter the following,
=SUM(C5:C6)- Then, press Enter.
- As a result, we will get the summation of the two numbers in Excel.
Read More: How to Download Google Sheets to Excel
2. Subtracting Two Values
Google Sheets has a function called the Minus function to subtract one number from another. However, Excel does not have this function. So, when we convert a Google Sheets to having this function, the conversion does not work as the function is incompatible with Excel. In this example, we will sort this problem out.
Steps:
- To begin with, choose the C7 cell in the Google Sheets and type the following formula,
=MINUS(C5,C6)- Then, press Enter.
- Consequently, the subtraction will be performed.
- After that, select the File tab.
- From the available options, choose Download.
- Download the sheet in the form of Microsoft Excel (.xlsx).
- After that, open the downloaded Excel file.
- We will find that the formula in the Google Sheets is not compatible with Excel.
- To perform calculations in Excel, select the C7 cell in the Excel file and remove the previous formula.
- Then, enter the following,
=C5-C6- Hit Enter.
- As a result, we will get the difference between the two numbers in Excel.
3. Dividing Two Values
Google Sheets has the DIVIDE function to perform division. But Excel does not have that function. This creates a problem while converting the Google Sheets containing that function into Excel. In this example, we will address that problem.
Steps:
- Firstly, click on the C7 cell in the Google Sheets and enter the formula below,
=DIVIDE(C5,C6)- Then, hit the Enter button.
- Consequently, the division will be completed.
- Afterward, go to the File tab.
- Select Download.
- Finally, download the sheet in the form of Microsoft Excel (.xlsx).
- Then, open the Excel file.
- We will see that the formula in the C7 cell in Excel is returning an error.
- To resolve the error, click on the C7 cell in the Excel file and remove the formula from the Google Sheets.
- After that, enter the formula below into that cell,
=C5/C6- Then, press the Enter button.
- As a result, we will get the division of the two numbers in Excel.
4. Multiplying Two Values
In order to multiply two numbers Google Sheets uses the MULTIPLY function. This function is not present in Excel. So, while converting the Google Sheets into Excel, this function will show an error. In this instance, we will resolve the error after converting the Google Sheets into Excel.
Steps:
- To start with, click on the C7 cell in the Google Sheets and enter,
=MULTIPLY(C5,C6)- Hit Enter.
- As a result, Google Sheets will perform the multiplication.
- Go to the File tab.
- From the list of options, choose Download.
- Finally, download the sheet as Microsoft Excel (.xlsx).
- Open the downloaded Excel file.
- We will see that the formula in the Google Sheets is returning an error in Excel.
- To perform the calculation properly, click on the C7 cell in the Excel file and erase the previous formula.
- After that, type,
=C5*C6- Press Enter.
- Consequently, we will get the multiplication of the two numbers in Excel.
5. Finding Power to Number
Raising a number to a particular power is a basic mathematical operation. Google Sheets uses the POW function to do that. But this does not work in Excel. Excel uses the POWER function to perform the same task. This creates an incompatibility between the Google Sheets file containing the POW function and the Excel file. In this instance, we will solve the incompatibility issue.
Steps:
- Firstly, select the C6 cell in the Google Sheets and type the following formula below,
=POW(C4,C5)- Then, hit Enter.
- Consequently, the number in the C4 cell will be raised to the power of the number in the C5 cell.
- After that, select the File tab.
- From the prevailing options, select Download.
- Then, download the sheet in Microsoft Excel (.xlsx) form.
- Afterward, open the Excel file.
- We notice that the formula in the Google Sheets is showing an error in Excel.
- To make it right, select the C6 cell in the Excel file and erase the formula.
- Then, enter the following formula into that cell,
=POWER(C4,C5)- Press Enter.
- As a result, we will get the desired result in Excel.
Read More: [Fixed!]: Google Sheet Downloaded as Excel Is Not Working
Download Practice Workbook
You can download the practice workbook here.
Conclusion
In this article, we have shown 5 instances of converting Google Sheets to Excel with formulas. There are plenty more. However, these 5 basic operations are the most frequently used. So, after going through this article, the users will be able to convert Google Sheets to Excel properly.
Related Articles
- How to Import Data from Google Sheets to Excel
- How to Edit Google Sheets in Excel
- How to Transform Google Sheets to Excel Automatically
- How Can I Link Google Sheets to Excel in Real Time?
- Unlocking Potential of Google Sheets QUERY Function in Excel
- How to Import Data from Google Sheets to Excel Using VBA
