Google Sheets – Are Excel Formulas and Google Spreadsheet Formulas the Same?

google sheetsworksheet-function

I want to be sure all my Google Spreadsheet work can be converted OK to Excel. How many of the Excel formulas match the formulas of Google spreadsheets?

Best Answer

I bashed up a comparison sheet for the formulas between MS Excel 2010 and Google Spreadsheet. Comparison was based on the names only. See snapshot of the current situation:

comparison sheet screenshot

If you want to make sure that Google Spreadsheet files are properly converted and still work in MS Excel 2010, then don't use the following formulas:

ADD
ARRAYFORMULA
CONCAT
CONTINUE
COUNTUNIQUE
DetectLanguage
DIVIDE
EQ
EXPAND
FILTER
GoogleClock
GoogleFinance
GoogleLookup
GoogleTournament
GoogleTranslate
GREATER THAN
GTE
IMAGE
ImportData
ImportFeed
ImportHtml
ImportRange
ImportXML
JOIN
LT
LTE
MINUS
MULTIPLY
NE
NOEXPAND
POW
QUERY
REGEXEXTRACT
REGEXMATCH
REGEXREPLACE
SORT
Sparkline
SPLIT
TO_DATE
TO_DOLLARS
TO_PERCENT
TO_PURE_NUMBER
TO_TEXT
UMINUS
UNARY_PERCENT
UNIQUE
UPLUS

Reference: MS EXCEL vs. GOOGLE SPREADSHEET

Related Topic