Formula Errors

Fix Excel Formulas Not Working After Uploading to Google Drive

Jason MillerJason Miller Nov 4, 2026 868 views

Question details

The user is experiencing calculation errors with advanced formulas like SUMPRODUCT, COUNTIF, and INDIRECT after uploading an Excel file to Google Drive.

How to Fix Excel Formulas Not Working in Google Sheets After Upload
Product
Excel / Google Sheets
Device & OS
not provided
Scenario
Uploading an Excel workbook to Google Drive and opening it for editing in Google Sheets.
Observed behavior
Formulas containing array constants, specific functions, and semicolon separators fail to calculate properly or display errors.
Before you start

Before modifying your formulas, verify the regional settings in your Google Sheets account, as locale differences commonly cause syntax errors with commas and semicolons.

Solution 1Recommended

Adjust Formula Syntax and Locale Settings in Google Sheets

Fix formula errors caused by differences in regional settings and argument separators between Excel and Google Sheets.

Google Sheets and Excel may use different argument separators depending on the locale. If your Excel file used semicolons, Google Sheets might expect commas, or vice versa.

1
Check Google Sheets Locale

Open your uploaded file in Google Sheets. Navigate to 'File' > 'Settings' (or 'Spreadsheet settings') and check the 'Locale' tab to see the current region.

2
Match Argument Separators

Update your formula syntax based on your locale. If the locale uses a comma for decimals, use a semicolon (;) to separate formula arguments. If it uses a period for decimals, use a comma (,).

3
Verify Array Constants

Google Sheets handles inline arrays slightly differently. Ensure your array brackets {} use the correct row/column delimiters (commas vs. semicolons or backslashes) according to your region.

Adjust Formula Syntax and Locale Settings in Google Sheets
Syntax Compatibility: Not all complex array constructions from Excel will translate seamlessly to Google Sheets without manual syntax adjustments.
Free Microsoft Office alternative

Edit Excel Files Seamlessly with WPS Office

Avoid formula errors and syntax incompatibilities by using WPS Office. It provides robust, native compatibility with Microsoft Excel formats, ensuring your complex formulas work perfectly without the need to upload and convert them in Google Sheets.

Fully compatible with Microsoft Excel (.xls, .xlsx) ensuring complex formulas stay intact.No conversion required: edit your original files safely across Windows, Mac, Linux, and Mobile.Advanced formula support including SUMPRODUCT, INDIRECT, and array formulas without syntax changes.Familiar user interface makes transitioning from Microsoft Office effortless and completely free.
microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel formulas return an error in Google Sheets?

Google Sheets and Excel handle certain formula syntax and locale settings differently. Commas, semicolons, and array brackets may need to be adjusted based on your Google Sheets regional settings.

Does Google Sheets support the INDIRECT and SUMPRODUCT functions?

Yes, Google Sheets supports both INDIRECT and SUMPRODUCT. However, INDIRECT cannot reference external workbooks in Google Sheets, and SUMPRODUCT may require slight syntax adjustments if your region uses different argument separators.

How do I fix the semicolon vs. comma issue in imported formulas?

Go to 'File' > 'Settings' in Google Sheets to check your locale. If your locale uses commas for decimals (like many European countries), use semicolons to separate formula arguments. For US locales, use commas.

Is there a way to open Excel files online without breaking formulas?

Using a dedicated office suite like WPS Office retains native .xlsx formatting and formula syntax much better than converting files into a different spreadsheet ecosystem.