8

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?

10

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

4

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

Screenshot

enter image description here

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

Formulas

ADD
ARRAY_CONSTRAIN
ARRAYFORMULA
CONCAT
CONTINUE
COUNTUNIQUE
DETECTLANGUAGE
DIVIDE
EQ
EXPAND
F.DIST
F.DIST.RT
FILTER
FINDB
GOOGLECLOCK
GOOGLEFINANCE
GOOGLETOURNAMENT
GOOGLETRANSLATE
GT
GTE
IMAGE
IMPORTDATA
IMPORTFEED
IMPORTHTML
IMPORTRANGE
IMPORTXML
ISEMAIL
ISURL
JOIN
LT
LTE
MINUS
MULTIPLY
NE
NETWORKDAYS.INTL
NOEXPAND
PERCENTRANK.EXC
PERCENTRANK.INC
POW
QUERY
RANK.AVG
RANK.EQ
REGEXEXTRACT
REGEXMATCH
REGEXREPLACE
SEARCHB
SORT
SPARKLINE
SPLIT
T.INV
T.INV.2T
TO_DATE
TO_DOLLARS
TO_PERCENT
TO_PURE_NUMBER
TO_TEXT
UMINUS
UNARY_PERCENT
UNIQUE
UPLUS
WORKDAY.INTL

Reference

  • I'm sure you meant to edit your other answer rather than duplicate it here. – ale Jan 28 '16 at 22:14
  • Excel 2016 includes functions like WORDAY.INTL and it's very likely that others too. – Rubén Dec 5 '16 at 1:14
0

If you're only worried about formulas, it shouldn't be a big problem, as Google Spreadsheets is now mature enough to support all the typical spreadsheet functions. It might be that the names are not exactly the same, or that some of them have to be done in a different way. So unless you're using some obscure stuff, you should be okay. I suggest you get a list of all the functions being used on your Excel Spreadsheets and then try them in Google Docs.

Also, if you're using any VB macros, you can forget about Google Docs.

  • 1
    The OP asked about converting his Google Sheets work TO Excel, not the other way around. He asked for a summary of the matching formulas not a "go try them and see if they work" non-answer. – Warren K May 9 '17 at 12:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.