Creating and Saving a Spreadsheet

Creating and Saving a Spreadsheet

Create a New Spreadsheet

Spreadsheets can be accessed from Zoho Docs.

To create a new spreadsheet:

Method 1:

1. To create a new spreadsheet directly from Zoho Docs main menu, click

Create> Spreadsheet.

Method 2:

1.From the main menu, click File > New. A spreadsheet can then be created either of the following ways:
i) Click New Spreadsheet to create a new spreadsheet.

ii) Click New Spreadsheet from Templates to create a spreadsheet from existing templates that you have saved already.

iii) Click New Template to create a new template that can be stored for further uses to create spreadsheets.

Method 3:

1. Choose to import from spreadsheets that you're working on currently.

Import a Spreadsheet

To import a spreadsheet:

1. Click File > Import.

2. You can import a file in two ways - by choosing a local file from your system or from the web by using the link (URL).

3. You can also name the spreadsheet you are uploading.

  • The formats that can be imported into Zoho Sheet are as follows: 
  • MS Excel Workbook (.xlsx) 
  • MS Excel 97 - 2003 Workbook (.xls) 
  • OpenDocument Spreadsheet (.ods) 
  • Comma Separated Values (.csv) 
  • Tab Separated Values (.tsv) 
  • Star Office(.sxc)

Save a Spreadsheet

Zoho Sheet automatically saves any changes made in the sheet, avoiding the need to save the sheet manually.The time in which it was saved last is indicated in the top right corner.

Use "Save As"

Save As is an option included under File menu that can be used to create a copy of the current spreadsheet you are working with. If you wish to save your spreadsheet under a separate name, then use the following methods :

1. Click File and then choose Save As from the drop-down menu. Enter the new name under which you wish to save the spreadsheet in the pop-up menu that appears.

2. If you would like to save the spreadsheet as a template from which new spreadsheets can be created later, then choose Save as Template option under a template name. It will be available to use as a template in the future.

Rename a Spreadsheet

By default, a new spreadsheet created will be named "Untitled Spreadsheet". It can be renamed by the following ways.

To rename a spreadsheet:

  1. Double click the title of the spreadsheet. It prompts you to change the name of the sheet and you can change the name of the spreadsheet.

  2. You can also choose Rename from File menu to change the name of the sheet,
    or you can right click the spreadsheet from Zoho Docs and choose Rename from the context menu.

Delete a Spreadsheet

If you wish to delete a spreadsheet, you can follow these steps to delete it from your Zoho Docs menu.

To delete a spreadsheet:

1. Select the checkbox next to the file name in your Zoho Docs homepage.

2. Click Trash/Remove  icon. The selected file is deleted. Or, you can also right click the file to be deleted and click Move to Trash from the menu that appears.

When a spreadsheet is deleted, it is moved to Trash. Note that the sheet is permanently deleted only when it is removed from Trash. You can choose to restore a spreadsheet by clicking Restore  

icon from Trash menu. A file that has been removed from Trash cannot be restored again.

Export a Spreadsheet

To convert spreadsheets to other file formats and to work across multiple platforms, you can export your spreadsheets .  Exporting spreadsheets also enables you work offline. 

To export a spreadsheet:

  1. Click File > Export As.

  2. Click the format in which you want the spreadsheet to be exported.

  3. The file will be exported to the required format. 

  • The formats that can be exported into Zoho Sheet are as follows: 
  • MS Excel Workbook (.xlsx) 
  • MS Excel 97 - 2003 Workbook (.xls) 
  • OpenDocument Spreadsheet (.ods) 
  • Comma Separated Values (.csv) 
  • Tab Separated Values (.tsv) 
  • Star Office(.sxc)
  • PDF Document
  • HTML Document

Share this post : FacebookTwitter

Still can't find what you're looking for?

Write to us: