The following is the general format you should use for CSV files:
The order of the columns isn’t important, but the first row must contain the column headings identifying what’s in each column.
You must have a column with the heading ID Number.
You must put a single space between ID and Number.
In place of ID Number, you can use ID, Student ID or Number.
If you don’t use a correct column name for the ID Number, the software is unable to import the list.
Specify student first and last names in separate columns.
For the student’s given name, use First Name for the column heading.
For the student’s family name, use Last Name for the column heading.
You must put a single space between First (or Last) and Name.
In place of First Name, you can use Given Name.
In place of Last Name you can use Last, Family Name or Surname.
You can also use the heading Full Name to import a single value that combines the first and last names.
You must put a single space between Full and Name.
In place of Full Name, you can use Full or Name.
If you use Full Name, the software checks to see whether the first and last names are separated by a comma (Last, First). If there isn’t a comma, it separates the names with a space (First Last).
If you put three or more names with spaces between them, the software uses the last word as the last name and joins all of the first words to form the first name. For example, "Michael John Smith" is split with the last name as Smith, and the first name as Michael John.
If your spreadsheet or database software automatically inserts quotation marks around the comma separated values, the software ignores them and the import works properly.