Sheets: Understanding Auto-Save and Version History

Sheets: Understanding Auto-Save and Version History

Understanding Auto-Save and Version History:

One of the key features of Google applications is that they consistently auto-save, while you’re doing your work! This means, no more losing spreadsheet data that you’ve worked on for hours once your battery dies or you have a power outage.

Any time that you are working in a Google Doc, Sheet, or Slide, you’ll see this text next to the dropdown menus. This text always states the last time the file was edited/saved. Pretty cool, right?!


The next neat feature about auto-save, is the Version History. If you click on the text that displayed the last edit/save time, it will open the Version History of the Google Sheet. You’ll see how it consistently saves at different times. If you click on one of the versions, it even highlights what is different on that version, than the previous saved version.


You also have the option to Restore an older version of the Sheet. Do do this, once you locate the version that you wish to restore, click the Restore this version option at the top of the page. Note, that this will remove any edits that occurred after that version history.


    • Related Articles

    • Sheets: Download Google Sheet as Excel File

      Another great feature Google Sheets offers is the ability to download a Google Sheet as an Excel, or .xlsx file.  Why would we do this?  We all know that some of our customers don’t accept Google Sheet files and require Excel files so let's walk ...
    • Move Excel file from Gmail into Google Sheets

      How to move an Excel file (.XLS, .XLSX, .CSV) into Google Sheets from an email: Another great feature of Google Workspace, is the ability to integrate their applications. You can also move Excel spreadsheets directly from your inbox, into Google ...
    • How to use Google Sheets Offline

      Google Drive is more than storage. It is a productivity suite that can open, edit and save in native Microsoft Office formats. In this tutorial we’ll show you how to configure your computer to be able to create Excel documents in Google Drive without ...
    • Sheets: Import from NetSuite to Google Drive

      How to export spreadsheets from Netsuite and save into Google Drive: In NetSuite, you can export any spreadsheet or PDF file and automatically save it into Google Drive, making it safe to store and easy to import into Google Docs or Google Sheets. To ...
    • Sheets: How to Import an Excel File

      How to import an Excel file (.XLS, .XLSX, .CSV) into Google Sheets the correct way, using a downloaded file: There are a few different ways to open Google Sheets. In your internet browser, you can type in sheets.google.com or you can access it within ...