How to Convert Google Sheets to Excel with Formulas

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.


Download Practice Workbook

You can download the practice workbook here.


5 Examples 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.

inserting formula in google sheets to convert google sheets to excel with formulas

  • 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.

downloading google sheets as excel to convert google sheets to excel with formulas

  • Then, open the downloaded Excel file.
  • We will see that the formula in the Google Sheet is not compatible in 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.

inserting formula in excel to convert google sheets to excel with formulas

  • As a result, we will get the summation of the two numbers in Excel.

Read More: How to Download Google Sheets to Excel (2 Easy Ways)


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.

typing minus function in google sheets to convert google sheets to excel with formulas

  • Consequently, the subtraction will be performed.

  • After that, select the File tab.
  • From the available options, choose Download.
  • Download the sheet in form of Microsoft Excel (.xlsx).

downloading file as excel to convert google sheets to excel with formulas

  • 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.

subtracting in excel to convert google sheets to excel with formulas

  • As a result, we will get the difference between the two numbers in Excel.

Read More: How to Use QUERY Function of Google Sheets in Excel (3 Common Ways)


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.

inserting divide function to convert google sheets to excel with formulas

  • 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).

downloading google sheets as excel file to convert google sheets to excel with formulas

  • 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.

dividing in excel to convert google sheets to excel with formulas

  • As a result, we will get the division of the two numbers in Excel.

Read More: How to Transform Google Sheets to Excel Automatically


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.

entering multiply function to convert google sheets to excel with formulas

  • 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).

downloading google sheets file as an excel file to convert google sheets to excel with formulas

  • 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.

performing multiplication in excel to convert google sheets to excel with formulas

  • Consequently, we will get the multiplication of the two numbers in Excel.

Read More: [Fixed!]: Google Sheet Downloaded as Excel Is Not Working


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.

using pow function to convert google sheets to excel with formulas

  • 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.

downloading google sheets as excel to convert google sheets to excel with formulas

  • Afterward, open the Excel file.
  • We notice see 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.

applying power function to convert google sheets to excel with formulas

  • As a result, we will get the desired result in Excel.


Conclusion

In this article, we have shown 5 instances to convert 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

Adnan Masruf

Adnan Masruf

I am an engineering graduate. I graduated from Bangladesh University of Engineering and Technology(BUET), one of the top universities in Bangladesh from department of Naval Architecture & Marine Engineering with a major in structure. I am an avid reader of fiction especially fantasy. I also keep myself abreast of the recent developments in science and technology. I believe diligence will eventually pay off and luck tends to favor those who work hard.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo