Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In CSV format, in an Excel spreadsheet or in a Word document, both having multiple email addresses with each address being in its own row and in a single column, is a comma REQUIRED after each address?

share|improve this question

Well, the answer to that is entirely dependent on what you are going to do with those email addresses. Email addresses in a word document, or in excel, or in whatever, can be separated by whatever you feel like - whatever is most pleasing to the eye. :) :)

is just one example of email addresses separated by smilies.

The only one you mentioned that has any strict formatting is the CSV file, where fields are separated by a column. If the email addresses are grouped into one column then if I were you I'd separate them with anything except commas.

So until we know what you are going to do with the email addresses we can't tell you what is required to delimit them.

share|improve this answer
Do frowns make Excel sad? – Mateen Ulhaq Mar 21 '11 at 23:06
No, they make it crash :P – Majenko Mar 21 '11 at 23:22

Assuming you are going to use the e-mail addresses as the recipient list for your e-mails, you should be able to separate them with semi-colons. If you separate them with commas they'll be treated as separate columns by what ever reads the CSV file.

Though I'd double check that your e-mail client accepts that format first.

share|improve this answer

Quotes should work within a CSV to keep a cell intact if you want to put commas in it.


Cell 1, Cell 2, "Cell 3, Still Cell 3", Cell 4
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .