Fix Excel Formulas Not Working After Uploading to Google Drive
Question details
The user is experiencing calculation errors with advanced formulas like SUMPRODUCT, COUNTIF, and INDIRECT after uploading an Excel file to Google Drive.

- 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 modifying your formulas, verify the regional settings in your Google Sheets account, as locale differences commonly cause syntax errors with commas and semicolons.
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.
Open your uploaded file in Google Sheets. Navigate to 'File' > 'Settings' (or 'Spreadsheet settings') and check the 'Locale' tab to see the current region.
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 (,).
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.

Replace Unsupported or Incompatible Functions
Modify advanced functions like INDIRECT or SUMPRODUCT that may not behave identically after the upload.
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.

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.




