Spreadsheet Formulas in Google Sheets vs Excel: Key Syntax Differences, Missing Functions, and How to Translate Your Skills

Posted on July 11, 2026 by

Last updated: July 11, 2026

Quick Answer: Google Sheets and Excel share the same core formula language, functions like SUM, IF, and VLOOKUP work identically in both. But about 20-30% of formulas have subtle syntax differences, missing equivalents, or behavioral quirks that will silently break your work if you’re not watching for them. This guide maps the key differences so you can migrate formulas in either direction with confidence.

Key Takeaways

  • Most everyday functions (SUM, AVERAGE, IF, VLOOKUP, COUNTIF) work the same in both platforms with no changes needed.
  • ARRAYFORMULA is required in Google Sheets for array behavior; Excel 365 handles this natively through dynamic arrays (spill ranges).
  • Excel’s XLOOKUP is available in Google Sheets as of 2024, but STOCKHISTORY, FIELDVALUE, and WEBSERVICE have no direct Google Sheets equivalents.
  • The FILTER, SORT, and UNIQUE functions share names but have different argument behavior between platforms, a common source of silent errors.
  • Google Sheets uses IMPORTRANGE, GOOGLEFINANCE, and QUERY functions that have no Excel equivalent.
  • VBA macros do not run in Google Sheets; Google Apps Script (JavaScript-based) is the alternative.
  • Date serial numbers are offset by one day between the two platforms (Excel’s base date is January 1, 1900; Google Sheets uses December 30, 1899).
  • Formula case sensitivity is identical: both platforms treat function names as case-insensitive.
  • Locale settings in Google Sheets can change argument separators from commas to semicolons, which breaks imported Excel formulas.

What Are the Main Syntax Differences Between Google Sheets and Excel Formulas?

Most formula syntax is identical across both platforms. The differences that matter are concentrated in a handful of modern functions and regional settings.

Argument separators: In most regions, both platforms use commas. But Google Sheets respects locale settings, users in European regions may see semicolons as argument separators instead of commas [4]. This is the single most common reason an Excel formula pastes into Google Sheets and immediately shows a parse error.

SORT function direction parameters: Excel uses 1 for ascending and -1 for descending. Google Sheets uses TRUE for ascending and FALSE for descending [1]. Using Excel’s numeric values in Google Sheets won’t throw an error, it’ll just sort in the wrong direction.

FILTER function third argument: In Excel, FILTER‘s third argument is the value to display when no results are found. In Google Sheets, that third argument acts as an additional filter condition [1]. This is a silent behavior difference, no error, just wrong row counts.

UNIQUE and case sensitivity: Excel’s UNIQUE function is case-insensitive, so “Apple” and “apple” collapse into one result. Google Sheets’ UNIQUE is case-sensitive and keeps them separate [1].

Function Excel Behavior Google Sheets Behavior
SORT -1 = descending FALSE = descending
FILTER 3rd arg = if-empty value 3rd arg = extra condition
UNIQUE Case-insensitive Case-sensitive
ARRAYFORMULA Not needed (spill native) Required for array output

Which Excel Functions Don’t Work in Google Sheets?

Several Excel functions have no direct Google Sheets equivalent and require workarounds.

Functions missing from Google Sheets [2]:

  • STOCKHISTORY, retrieves historical stock prices. Use GOOGLEFINANCE instead.
  • FIELDVALUE, pulls data from linked data types (stocks, geography). No equivalent.
  • WEBSERVICE / FILTERXML, fetches and parses web data. Use IMPORTDATA or IMPORTXML in Google Sheets.
  • LET, available in Excel 365 for naming intermediate values. Not available in Google Sheets as of mid-2026.
  • LAMBDA, available in Excel 365 for custom reusable functions. Google Sheets added LAMBDA support in 2022, so this one now works in both.

Choose a workaround if: you’re moving a financial model that uses STOCKHISTORY, replace it with GOOGLEFINANCE("GOOG","price",DATE(2024,1,1),DATE(2024,12,31),7) to pull weekly historical data.

What Functions Does Google Sheets Have That Excel Doesn’t?

Google Sheets has several powerful built-in functions that Excel users will need to replicate with workarounds or add-ins.

  • IMPORTRANGE, pulls live data from another Google Sheets file by URL. Excel requires Power Query or manual links for cross-workbook data.
  • GOOGLEFINANCE, pulls live and historical stock, currency, and crypto data directly into cells.
  • QUERY, runs SQL-like queries on a data range using Google Visualization API syntax. Excel’s closest equivalent is Power Query, which is a separate interface rather than a cell formula.
  • SPARKLINE, creates a mini chart inside a single cell. Excel has Sparklines too, but they’re inserted as chart objects, not formula-driven.
  • DETECTLANGUAGE / GOOGLETRANSLATE, no Excel equivalent.

For Excel users who rely heavily on cross-workbook formulas, see this guide on how to insert a formula in Excel for an entire column to understand how Excel handles column-wide formula patterns before migrating them to Sheets.

How Do Array Formulas Work Differently in Google Sheets vs Excel?

How Do Array Formulas Work Differently in Google Sheets vs Excel?

In Excel 365, dynamic arrays are native, type =A1:A10*2 and it automatically spills results into adjacent cells without any special syntax. In Google Sheets, you must wrap the formula in ARRAYFORMULA() to get the same behavior [3].

Excel (dynamic array, no wrapper needed):

<code>=A1:A10*2
</code>

Google Sheets equivalent:

<code>=ARRAYFORMULA(A1:A10*2)
</code>

Common mistake: Excel users who paste a spill formula into Google Sheets get only the first cell’s result. The fix is always to wrap in ARRAYFORMULA.

Functions like FILTER, SORT, UNIQUE, and SEQUENCE behave as dynamic arrays natively in both platforms, but as noted above, their argument syntax differs.

Does Google Sheets Support VLOOKUP and XLOOKUP the Same Way Excel Does?

VLOOKUP works identically in both platforms, same syntax, same behavior, same quirks. XLOOKUP was added to Google Sheets in 2024 and works the same way as in Excel 365, including its default exact-match behavior and the ability to return arrays.

VLOOKUP (identical in both):

<code>=VLOOKUP(A2, D:F, 2, FALSE)
</code>

XLOOKUP (same in both, as of 2024):

<code>=XLOOKUP(A2, D:D, E:E, "Not found")
</code>

If you’re still using VLOOKUP in Excel and want to understand why XLOOKUP is worth switching to, the Excel IF Statements Made Simple guide covers related logical formula patterns that pair well with lookup functions.

QUERY vs Power Query: For users who use Power Query in Excel to reshape data, Google Sheets’ QUERY function is the formula-native equivalent. Example:

<code>=QUERY(A:C, "SELECT A, SUM(C) WHERE B='Sales' GROUP BY A", 1)
</code>

Power Query is a GUI tool; QUERY is a cell formula, the mental model is different but the output is similar.

Can I Use VBA Macros in Google Sheets, or Do I Need Apps Script?

VBA macros do not run in Google Sheets at all. Google Sheets uses Google Apps Script, which is JavaScript-based, to automate tasks.

Key differences:

  • VBA uses Range("A1").Value = "Hello", Apps Script uses sheet.getRange("A1").setValue("Hello")
  • VBA runs locally on your machine. Apps Script runs on Google’s servers.
  • Apps Script can trigger on form submissions, time intervals, or spreadsheet edits, some of which VBA can’t do natively.

Migration tip: Don’t try to translate VBA line-by-line. Identify what the macro does, then write fresh Apps Script to accomplish the same outcome. Google’s Apps Script documentation and AI tools make this much faster in 2026 than it was even two years ago.

Why Is My Excel Formula Giving an Error in Google Sheets?

The most common causes of formula errors when moving from Excel to Google Sheets are:

  1. Locale-based separator mismatch, semicolons vs commas in argument lists [4]. Fix: check your Google Sheets locale under File > Settings.
  2. Missing ARRAYFORMULA wrapper, spill formulas return only one cell. Fix: wrap in ARRAYFORMULA().
  3. FILTER third-argument misuse, passing an if-empty string as the third argument adds an unintended filter condition [1]. Fix: remove the third argument or restructure the logic.
  4. SORT direction parameter, -1 in Google Sheets is treated as a truthy value (ascending), not descending [1]. Fix: replace -1 with FALSE.
  5. Excel-only functions, STOCKHISTORY, WEBSERVICE, etc. show #NAME? errors. Fix: replace with Google Sheets alternatives.

How Do I Handle Date Formats and Calculations Across Excel and Google Sheets?

Date calculations mostly work the same, but there’s a known one-day offset between platforms. Excel’s date serial number system starts from January 1, 1900 as day 1. Google Sheets uses December 30, 1899 as day 0. In practice, dates after 1900 display identically, the offset cancels out for most calculations.

Where it matters: If you’re importing raw serial date numbers (integers) from Excel into Google Sheets, dates before March 1, 1900 may be off by one day. For modern business data, this is rarely an issue.

DATEDIF function: Works in both platforms but is undocumented in Excel (it’s a legacy Lotus 1-2-3 function). It works reliably in Google Sheets. For date difference calculations in Excel, see how to use Excel to find the difference between two dates in years.

Date format display: Google Sheets respects locale for date display (DD/MM/YYYY vs MM/DD/YYYY). Excel uses the system locale. When sharing files across regions, always check that date columns are stored as actual date values, not text strings.

Can I Import an Excel File and Have All Formulas Work Automatically in Google Sheets?

Most formulas in an imported .xlsx file will work automatically in Google Sheets, especially if they use core functions like SUM, IF, VLOOKUP, INDEX/MATCH, SUMIF, and COUNTIF [5]. These translate without any changes.

What breaks automatically:

  • Formulas using STOCKHISTORY, FIELDVALUE, or WEBSERVICE
  • VBA macros (stripped entirely on import)
  • Dynamic array spill formulas (may need ARRAYFORMULA wrapping)
  • SORT/FILTER formulas with Excel-specific argument values

Recommended import process:

  1. Upload the .xlsx file to Google Drive.
  2. Open it as a Google Sheet (File > Save as Google Sheets).
  3. Check for #NAME? errors, these flag unsupported functions.
  4. Check for #VALUE! or silent wrong results in SORT/FILTER formulas.
  5. Test date-heavy calculations on a sample of rows.

For a broader comparison of when to use each tool, see Excel vs Google Sheets: Which Spreadsheet Tool Is Better for Your Workflow?

Is Google Sheets Formula Language Case Sensitive Compared to Excel?

Neither platform is case-sensitive for function names. =sum(A1:A10), =SUM(A1:A10), and =Sum(A1:A10) all work identically in both Excel and Google Sheets. Both platforms auto-capitalize function names when a formula is confirmed.

Where case does matter: The UNIQUE function in Google Sheets treats text values as case-sensitive when identifying duplicates [1]. Excel’s UNIQUE does not. The EXACT function (which does a case-sensitive text comparison) works the same in both platforms.

What’s the Best Way to Learn Google Sheets If You’re Already Good at Excel?

If you know Excel well, you’re already 70-80% of the way to Google Sheets proficiency [5]. The core formula language is the same. Focus your learning time on the gaps.

Priority learning list for Excel-to-Sheets migrants:

  • IMPORTRANGE, cross-file data pulling
  • QUERY, SQL-style data manipulation in a formula
  • GOOGLEFINANCE, live financial data
  • ARRAYFORMULA, how and when to use it instead of spill ranges
  • Apps Script basics, replacing your most-used VBA macros
  • Google Sheets-specific FILTER/SORT argument syntax

For Sheets-to-Excel migrants, prioritize:

  • Dynamic arrays and the spill range concept
  • Power Query for data transformation
  • XLOOKUP and LET for cleaner formulas
  • STOCKHISTORY for financial data

If you’re starting from scratch or want to sharpen Excel fundamentals first, how to learn MS Excel in 24 hours is a solid starting point.

Are There Formulas That Work in Both Excel and Google Sheets Without Changes?

Yes, the majority of everyday formulas work identically in both platforms with zero modification needed [5].

Safe to copy between platforms without changes:

  • SUM, AVERAGE, MIN, MAX, COUNT, COUNTA
  • IF, IFS, AND, OR, NOT
  • VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP (Excel 365 / Sheets 2024+)
  • SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF
  • LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER
  • TEXT, VALUE, DATE, TODAY, NOW, YEAR, MONTH, DAY
  • IFERROR, IFNA, ISBLANK, ISNUMBER, ISTEXT
  • ROUND, ROUNDUP, ROUNDDOWN, INT, MOD
  • CONCATENATE, CONCAT, TEXTJOIN
  • LAMBDA (Excel 365 and Google Sheets, as of 2022)
Are There Formulas That Work in Both Excel and Google Sheets Without Changes?

What Common Mistakes Do Excel Users Make When Switching to Google Sheets?

Top five mistakes:

  1. Forgetting ARRAYFORMULA, pasting a column-wide formula and wondering why only one cell populates.
  2. Trusting FILTER and SORT to behave identically, they share names but differ in argument behavior [1].
  3. Ignoring locale settings, a spreadsheet that works fine for one collaborator breaks for another in a different region [4].
  4. Trying to run VBA, it simply won’t work. Budget time to rewrite automation in Apps Script.
  5. Assuming UNIQUE deduplication is case-insensitive, it’s not in Google Sheets, which can inflate unique counts unexpectedly [1].

For Excel-specific tips on protecting and structuring your workbooks before migration, see how to lock specific cells in Excel, the equivalent in Google Sheets uses Data > Protect Sheets and Ranges.

FAQ

Q: Do Google Sheets and Excel use the same function names? Yes, the vast majority of function names are identical. Exceptions include Google Sheets-exclusive functions like IMPORTRANGE, QUERY, and GOOGLEFINANCE, which have no Excel formula equivalent.

Q: Will my VLOOKUP formulas break when I open an Excel file in Google Sheets? No. VLOOKUP syntax is identical in both platforms and imports without any changes needed.

Q: Does Google Sheets have XLOOKUP? Yes. Google Sheets added XLOOKUP support in 2024. It works with the same syntax as Excel 365’s version.

Q: Why does my FILTER formula return wrong results in Google Sheets after copying from Excel? The third argument behaves differently. In Excel it’s an if-empty fallback value; in Google Sheets it’s an additional filter condition. Remove or restructure the third argument [1].

Q: Can I run Excel macros in Google Sheets? No. VBA macros are not supported in Google Sheets. You’ll need to rewrite automation using Google Apps Script (JavaScript-based).

Q: Is there a QUERY function in Excel? Not as a cell formula. Excel’s Power Query is the functional equivalent but operates as a separate data transformation tool, not a formula you type into a cell.

Q: Does Google Sheets support LET and LAMBDA? LAMBDA is supported in Google Sheets (added 2022). LET is not available in Google Sheets as of mid-2026.

Q: Are date calculations the same in both platforms? For dates after 1900, yes. There’s a theoretical one-day offset in the underlying serial number system, but it doesn’t affect modern date calculations in practice.

Q: Does Google Sheets have Power Query? No. The closest equivalent is the QUERY function for formula-based data manipulation, or Google’s Connected Sheets for BigQuery integration.

Q: Why do my formulas use semicolons in Google Sheets but commas in Excel? This is a locale setting. Google Sheets adapts argument separators based on your regional settings. Change it under File > Settings > Locale [4].

Q: Is conditional formatting formula syntax the same in both? Mostly yes. The formula logic is identical, but the interface for applying it differs slightly between platforms.

Q: Can I use IMPORTRANGE in Excel? No. IMPORTRANGE is Google Sheets-only. Excel uses external cell references or Power Query to pull data from other workbooks.

Conclusion

Understanding spreadsheet formulas in Google Sheets vs Excel, the key syntax differences, missing functions, and how to translate your skills, comes down to knowing which 20% of functions need attention. The core formula language is shared. The gaps are real but manageable.

Actionable next steps:

  1. Audit your formulas before migrating. Search for STOCKHISTORY, WEBSERVICE, SORT, and FILTER in your Excel files, these need manual fixes.
  2. Fix locale settings first. If collaborators are in different regions, set a consistent locale in Google Sheets before sharing.
  3. Learn ARRAYFORMULA and QUERY early. These two functions unlock most of what Google Sheets does differently and better.
  4. Don’t translate VBA, rewrite it. Use Apps Script’s built-in IDE and Google’s documentation to rebuild macros from scratch.
  5. Test date columns on import. Spot-check a few date values after importing .xlsx files to confirm they display correctly.

For a deeper look at which platform suits your workflow overall, the Excel vs Google Sheets comparison guide covers the full picture beyond just formulas.

References

[1] Excel Google Sheets Formula Compatibility – https://spreadsheetweb.com/excel-google-sheets-formula-compatibility/?utm_source=openai

[2] Excel Features Not In Google Sheets – https://smoothsheet.com/blog/tips/excel-features-not-in-google-sheets/?utm_source=openai

[3] Formula – https://sheets.wiki/concept/Formula?utm_source=openai

[4] Locale differences in Google Sheets – https://stackoverflow.com/questions/73767719/locale-differences-in-google-sheets-documentation-missing-pages/73767720?utm_source=openai

[5] Are Google Sheets Formulas The Same As Excel – https://formswrite.com/blog/are-google-sheets-formulas-the-same-as-excel?utm_source=openai

This entry was posted in Excel Tips Blog and tagged , , , , , , , , , , , . Bookmark the permalink.