Codesters FAQ is the official FAQ site for codesters.com. We will continue to update this blog with the most common questions we receive form teachers using Codesters.

How do I format my roster CSV file with Excel?

Tips for formatting your .csv file

Step 1: Open a copy of your Excel Sheet and add the column headings. 
First Name, Last Name, Email, Password, Screen Name. These headings should be in the first row of the spreadsheet

NOTE: Student email is not not required. A Logon ID will be generated when the roster is uploaded. This Login ID is not used by the student  and just ensures that the account is

Step 2: Special Formatting

  • Full name is in one column and needs to be split into two:
    Insert a column to the right of the full name
    Select all the names to be split
    Click Data and then Text to Columns
    Click "Next"
    Check the box that matches the delimiter (most likely a "space")
    Click "Next" and then "Finish"</li>
    The name should now be split into 2 parts
    Ensure that column A contains First Name and column B Last Name
     
  • Auto generate Screen Names using a formula:
    Suggested format is First Name, Last Initial, and School Number
    Enter this formula in cell E2 and replace nnn with your school number =A2&left(B2,1)&"nnn"
    Copy E2, select the rest of column E and paste to generate   screen names

Step 3: Saving File as a .csv
     Click "File" at the very top of the desktop on the left
     Click "Save As" and select format "Comma Separated Values (.csv)
     You can optionally change the file name and save location
     Click "Save"