A email field is intended to store a single valid email address in each cell.
The email field will store the entered emails as links, so clicking on one of the email addresses will open up your computer's native email client with the To: field addressed to the email you just clicked on.
