Open topic with navigation

CSV file formatting

Tips for formatting CSV files for importing class lists

The following is the general format you should use for CSV files:

ID Number,First Name,Last Name
12345,David,Jones
67890,Jane,Doe
56789,John,Swartz
34567,Mary,Smith

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 as 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.