Getting Started with Sheet

Overview of Sheet's features:

• Create spreadsheets: Create a new spreadsheet or import from your devices or URL.
• Calculation and analysis: Perform calculations on your data set with 400+ predefined functions. You can also create custom functions for your unique use cases.
• Data visualization: Summarize and visualize data with charts and pivot tables.
• Sharing and collaboration: Co-author spreadsheets, add comments, and track changes. Share spreadsheets with collaborators with view, edit, or share permissions.
• Templates: Create planners, reports, trackers, and more with pre-built and customizable templates.
• AI data analyst: Get AI-powered insights, data refining, and formatting suggestions.

Listing age Overview

As soon as you log in, you'll be redirected to the Sheet's listing page. From the listing page, you can:

• Create new spreadsheets or upload spreadsheets from devices or URLs.
• View and access all the spreadsheets created by you, shared with you, and deleted by you.
• View and access all the available spreadsheet templates.

Create a New Spreadsheet

1. Log in to https://mail.gov.in
2. Select Sheet from the top menu.
3. Click the New Spreadsheet button at the top-right corner of Sheet's listing page.
4. Double-click Untitled Spreadsheet located on the top-left and enter the desired file name.

Upload / Import Spreadsheets

1. Log in to https://mail.gov.in.
2. Select Sheet from the top menu.
3. Click Upload at the top-right corner of Sheet's listing page.
4. From the drop-down, select Upload Spreadsheet to upload spreadsheets from your device or import from URLs.

Supported file formats:

The following file formats are supported in Sheet to import spreadsheets:
.xls, .xlsx, .xlsm, .ods, .csv, .tsv, .pdf, .txt, .xltx, and .sxc

The following file formats in are supported in Sheet to export or download spreadsheets.
.xlsx, .ods, .csv, .tsv, .pdf, .zip 

Spreadsheet editing and formatting options

• Cut, copy, and paste
• Fonts, font sizes, font colors, and fill color.
• Bold, italics, strikethrough, and underline
• Alignment: Left, right, center, and automatic
• Bulleted and number lists
• Borders
• Merge and center
• Wrap text
• Text rotation
• Number formats
• Conditional formats

Sharing and Collaboration

Sheet allows you to work together with your team in real-time with options to collaborate, share, and publish spreadsheets.
To share spreadsheets:

1. Click Share at the top-right corner of your spreadsheet.
2. From the drop-down, select Share.
3. In the dialog that appears, enter the email address of the persons with whom you'd like to share and select the desired access level.
4. Click Share.

To Publish Spreadsheets

1. Click Publish at the top-right corner of your spreadsheet.
2. From the drop-down, select Publish.
3. In the dialog that appears, select the publish mode and the desired sheet, then click Publish.

Track Changes

Sheet allows you to track changes made to your spreadsheets with version history and audit trail. To view version history:

1. Go to File > View Version History.
2. From the Version History dialog, you can view all the previous versions, including who made the edit. You can also restore, revert, or download any previous versions.

To view the audit trail

1. Go to File > Audit Trail.
2. From the Audit Trail dialog, you can view all the edits made to the spreadsheet, including who, where, what, and when.

Visualize Data

Sheet allows you to visualize data through 35+ chart types. You can choose and customize the right chart type for your data set. In addition to charts, you can also use sparklines to visualize data as small in-cell graphs.To insert a chart:

1. Select the cell range for which you wish to add a chart.
2. Click on the Insert Chart icon from the tool bar and select the appropriate chart for your data.
3. You can edit the chart from the options in the side pane.

To insert a sparkline:

1. Select the cell range for which you wish to add a sparkline.
2. Navigate to Insert > Sparkline > Create Sparkline.
3. From the side pane that appears, you can edit or change the type of sparklines.

Summarize Data

Sheet allows you to summarize data sets for easy analysis with pivot tables. To insert a pivot table:

1. Select the data range for which you wish to insert the pivot table.
2. Navigate to Data > Pivot Table > Create Pivot Table from the toolbar.
3. From the side pane that appears, you can drag and drop the required fields and start customizing.

Slicers

Slicers help you quickly filter data in one or more pivot tables simultaneously.To insert a slicer:

1. Right-click on the pivot table and select Add Slicer.
2. From the slicer dialog, choose the desired fields and click OK.
3. From the individual slicers, you can choose the values based on which the pivot table should be filtered.

Images

Sheet allows you to insert images in the cell and over the cells. To insert an image:

1. Click on the Insert Image icon the toolbar and select Image in cell or Image over cells.
2. From the Image dialog that appears, select where you'd like to upload the image from.

Filter and Sort

Sheet allows you to filter a range of data based on the criteria you choose. To apply a filter:

1. Select the data range for which you wish to apply the filter.
2. Click on the filter icon from the toolbar and select Create Filter.
3. From the drop-down, you can choose the desired criteria and click Filter.

To name a filter:

1. Select a filtered range for which you wish to name.
2. Click on the filter icon and select Name this filter.
3. From the dialog that appears, enter the desired filter name.

To remove a filter:

1. Select the filtered range and select Remove filter.

Data Validation

Data validation allows you to restrict entries to your spreadsheet. You can create, edit, and manage data validations. To create a data validation:

1. Select the cell in which you wish to insert data validation.
2. Navigate to Data > Data Validation > Create Validation from the toolbar.
3. From the Data Validation dialog that appears, select the criteria, enter the values, and click OK.

To manage data validations:

1. Go to Data > Data Validation > Manage Validation.
2. From the Data Validation-Manage Rules dialog, you can copy, edit, or delete the validations. 

Data Cleaning

Data cleaning in Sheet allows you to find missing values, duplicate values, inconsistent data, and fix them. To clean your data:

1. Go to Data > Data Cleaning and select the desired data cleaning action from the list of options.