Is there any way to have the email, first name, last name, etc field appear in individual columns (when using the web interface report found at ‘List Management’/‘Subscriber Report’ to download the report in CSV format)? 

Currently that information comes out in a single cell such as “userid@host.com Their Name” which is not usable in Excel without manually splitting each cell.

If the list has fewer than 1000 subscribers, then the email address and name will be in the same column; otherwise, for lists >1000 subscribers, they are displayed in separate columns.

Unfortunately, there isn’t a way to change this, but it’s possible to use Excel formula to add the email address and names in separate columns if desired.

To get the email addresses by themselves:

  1. Open the file in Excel.  The data should all be in a single column, since there is no comma.
  2. Highlight columns A, B, and C.  You can either select just the cells that contain data, or select the entire set of columns, doesn't matter for our purpose.
  3. Format the selected cells/columns as a table (there’s a button in the ribbon in the “Styles” section that will do this).  Any style you choose is fine, you just have to format the selection as a table.  You’ll end up with generic column headers in Row 1, but that’s OK.
  4. In cell B2, enter the formula =LEFT(A2,(FIND(" ",A2,1)-1))
  5. In cell C2, enter the formula =MID(A2,FIND(" ",A2)+1,256)

Column B contains the email address, Column C contains the name field.

Note that if you have highlighted the whole set of cells in columns A-C, any row of the table where column A is empty will have “#VALUE!” errors in columns B and C.  This is not a problem, it just means there’s no data in column A so Excel can’t calculate a value for B and C. 

You can also create a standard worksheet containing this table (in blank) ahead of time, save it, and use it to paste the single-column data into column A (starting in cell A2).  The data should automagically convert on the fly.  Again, columns B and C will contain the #VALUE! error until you put data into column A.  (One caveat, you have to create the table and THEN enter the formulas in cells B2 and C2.  Otherwise the columns won’t fill properly.)