The Email data type is for email addresses.

In, clicking on an email address will open a new message in your default email client with that address in the To field.

You can comment and collaborate inside, but the Email data type facilitates communication via email. For example, you can use the Email data type to store contact information of job candidates, create a sheet to manage your sales leads, or collect registration information for that awesome spreadsheet conference you are planning.

If you want to collaborate with another user directly in a worksheet, you might prefer to use the User data type, which will add that person to your sheet. does not check the veracity of entered email addresses. You may want to check all email addresses in your workbook to ensure they are correct.



Like other data types, Email data types can have Strict enabled. Selecting the Strict checkbox for Email cells will restrict users to input only alphanumeric characters, and will turn all text entered into an email address. Also, columns that have Strict enabled cannot have cells of different data types.

How to Use the Email Data Type

Once you have set a column, cell, or range of cells to an Email data type, simply click into the cell and type or paste in the desired email. Clicking on this email address will open a new message in your email client, with that address in the To field., like other sites, defaults email addresses to a blue color. You can change this and other settings in the formatting toolbar at the top of your worksheet. also has a URL data type, to open web addresses in a new tab in your browser. Read on to learn more about the rest of's Data Types.