Cloud-to-Cloud Backup: Google Apps, Salesforce and Office 365

Knowledge Base

Are Google Spreadsheet Formulas Backed Up?


Last Updated: Aug 07, 2015 09:32PM CDT

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 don'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.

http://assets2.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found