Are Google Spreadsheet Formulas Backed Up?

Yes, Spanning backs up all of the formulas used within Google Sheets and when you restore backed up Google Sheets, the restored documents will contain all of the same formulas and values as the original document.  However, if you want to export your backed up Sheets data through Spanning Backup, there are a few things to note:

When using Google Sheets, there are several formulas that are specific to the Google Sheet platform that doesn't export to other spreadsheet programs (such as Microsoft Excel).  When spreadsheets are exported with these Google-specific formulas, the value that the formula produced will be exported, but, the formula itself will not be.

But, please note that even though the exported Google Sheet does not have the Google-specific formulas active within the spreadsheet, if you were to import that exported .xlsx file back into Google using the native Google import tools, the original formula would then be restored (not just the formula result/value).

Below is a list of many of the Google Sheet specific formulas that do not convert over to Microsoft Excel, when the data is exported:
 

  • ADD
  • ARRAYFORMULA
  • CONCAT
  • CONTINUE
  • COUNTUNIQUE
  • DETECTLANGUAGE
  • DIVIDE
  • EQ
  • FILTER
  • GOOGLEFINANCE
  • GOOGLETOURNAMENT
  • GOOGLETRANSLATE
  • GT
  • GTE
  • IMAGE
  • IMPORTDATA
  • IMPORTFEED
  • IMPORTHTML
  • IMPORTRANGE
  • IMPORTXML
  • JOIN
  • LT
  • LTE
  • MINUS
  • MULTIPLY
  • POW
  • QUERY
  • SORT
  • SPARKLINE
  • SPLIT
  • UMINUS
  • UNARY_PERCENT
  • UNIQUE
  • UPLUS


Please contact support if you have any questions.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us
Provide feedback for the Documentation team!