Keeping track of the changes made to the spreadsheet | Zoho Sheet Help Guide

Keeping track of the changes made to the spreadsheet

What is version history?

Zoho Sheet automatically saves all previous versions of your spreadsheet. You can visit, revert or download any previous versions of the spreadsheet at any given point of time. 

View all the previous versions of a sheet

To view previous versions:
  1. Click File > View Version History.
  2. A menu opens up and it lists the older versions of the spreadsheet.     
  3. Click the checkbox near Highlight Changes to observe the modifications between two different versions of the spreadsheet. 
  4. Find versions faster by filtering them out. Click on the settings icon on the top of the version panel and select the desired list of versions..
  5. Simply click on a version to preview it on the spreadsheet at left. 
  6. Click Changelog to view the changes done in that particular version.  


Restore a previous version of a sheet

To restore previous versions:
  1. Go to File > Version History
  2. In the Version History panel, select a version and click Revert  in the toolbar. 
The version that you wanted to work will be restored.


To create a new version of a spreadsheet

  1. Click File. In the drop-down menu select Create version.
  2. Name the version for future reference on the window that appears and click Create.


Name a version

To name a version:
Go to File > Version History. In the Version History panel, select an unnamed version and click Mark this Version on the toolbar.


Download a version

To download a version
  1. From the Version history panel, select the version you want to download.
  2. In the toolbar, click on the download option 


What is audit trail?

Audit trail allows you have a look at all the changes made to the spreadsheet. You can further use audit trail to filter these changes and single out edits based on the user that made the change, the date on which the change was done, and the sheet or range to which the change was done.

View the changes made to the sheet

To view changes made to the sheet:
    1. Click File > Audit Trail in the menu bar.
    2. Audit Trail can be filtered based on different parameters. Use the radio buttons on the top of the panel displayed in Audit Trail in order to sort the cell edit history based on user, date, sheet or even a specific range.


Manage email notifications for edits made to spreadsheets

To change the notification settings:
  1. Go to Tools > Email notification settings.
  2. From the dialog that appears, toggle the button to enable or disable notifications for edits.
  3. From the dropdown, select whether you wish to receive notifications for all the changes made by the collaborators on the spreadsheet or specific sheet or range.



You can choose to look at the data according to the selected option. 
  • User— filters the edits performed by a specific collaborator 
  • Date— filters the edits performed on a specified date/period
  • Sheet —filters the edits performed on a specific sheet. 
  • Range—filters the edits performed on a specific range selected.