Fix Excel Formulas Returning #VALUE! After Importing to Google Sheets
Question details
The user needs to troubleshoot Excel formulas that return #VALUE! after the workbook is imported into Google Sheets.

- Product
- Microsoft Excel and Google Sheets
- Device & OS
- not provided
- Scenario
- An Excel workbook contains formulas that work in Microsoft Excel but show errors after being opened or converted in Google Sheets.
- Observed behavior
- Some imported formula cells return the #VALUE! error in Google Sheets.
Make sure the workbook or Google Sheets file can be opened with the required sharing permission, and note the exact sheet names and cell addresses showing #VALUE!. Compare each affected formula with its original formula in Excel before making replacements.
Identify the failing formulas and check Google Sheets compatibility
Use this method first when only certain cells show #VALUE! after an Excel-to-Google-Sheets import.
Excel and Google Sheets support many common formulas, but Excel-specific functions, reference styles, external links, and advanced workbook features may not convert correctly. Reviewing the exact formula in each affected cell reveals what needs to be changed.
In Google Sheets, select a cell displaying #VALUE! and review the formula in the formula bar.
Copy the formula and note its sheet name and cell address, such as Sheet1!D12, so the problem can be compared with the original Excel workbook.
Look for Excel-only functions, structured table references such as Table1[Amount], external workbook links, unsupported add-in functions, or references to features that did not import.
Edit the formula directly in the Google Sheets formula bar and replace the unsupported function or reference with a Google Sheets-compatible formula or a standard cell range.
Press Enter, then copy the corrected formula to similar cells only after confirming that it returns the expected result.

Provide accessible file details for formula-specific troubleshooting
Use this option when another person needs to inspect the imported workbook and identify the exact cause of the errors.
Keep Excel Formula Workbooks in a Compatible WPS Spreadsheet Environment
If a workbook is designed for Microsoft Excel formulas and features, WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface and strong workbook compatibility. Open, review, and edit Excel files in WPS Spreadsheets without relying on a Google Sheets conversion workflow.

Frequently Asked Questions
Why do Excel formulas return #VALUE! after importing to Google Sheets?
The imported formula may use an Excel-only function, an unsupported reference type, an external workbook link, or a feature that Google Sheets cannot convert. Select the error cell and inspect its formula in the Google Sheets formula bar.
How do I find all #VALUE! cells in an imported Google Sheets file?
Use Edit > Find and search for #VALUE! to locate visible error values. Then select each result and review the related formula in the formula bar.
Do Google Sheets and Excel use the same formula syntax?
Many basic formulas use similar syntax, but compatibility is not complete. Functions, table references, named ranges, array behavior, external references, and advanced Excel features can require changes after import.
What should I share when asking someone to fix imported formula errors?
Provide a shareable link that opens without an Unauthorized message, plus the sheet names, error-cell addresses, copied formulas, and the results those formulas produce in Excel.
Can I avoid Google Sheets conversion issues for an Excel workbook?
Yes. Open and edit the original .xlsx, .xls, or .xlsm workbook in a compatible spreadsheet application such as WPS Spreadsheets, especially when the file relies on Excel-specific formulas or features.




