How do I format an excel spreadsheet for email addresses?

Make sure that you put all of your data in separate columns. For example, for email addresses, put them in one column, and add additional columns for any additional fields you may have. The very first row of your file should be a descriptive header (It should say things like "Email, First name" etc. The order does not matter when you import the list.