The Email data type is for email addresses. In Spreadsheet.com, 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 Spreadsheet.com, but the Email data type facilitates communication via email. For instance, 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.
Note: Spreadsheet.com does not check the veracity of entered email addresses. You may want to check all email addresses to ensure they are correct.
Entering Email Addresses
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.
Spreadsheet.com, 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.
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.
Spreadsheet.com also has a URL data type, to open web addresses in a new tab in your browser.