The file must not have any additional columns or blank rows.If you don't want to do that and want the job done by yourself, here's the easy steps:.It must have the 'family name' header, but entering the names in the columns is optional The third column is the family names for the users.It must have the 'given name' header, but entering the names in the column is optional All addresses must be in the format For example, The second column of the file is for the given names of the users. The first column of the file must contain the user email addresses.

The header row of the file must contain three columns with the exact names: email, given name, family name (if using Excel, remove the commas and put one phrase in each cell).Click here for more information on creating a CSV file Note there are some rules for files that can be used for student import:

Students can be invited via email or imported using a. Where K1 contains the initial string, such as 401.50,0.027 ** 0+ before the formulas converts the extracted substrings to numerical data. To get the values to the right of the comma: =0+RIGHT(K1,LEN(K1)-FIND(',',K1)) To get the values to the left of the comma: =0+LEFT(K1,FIND(',',K1)-1) Two formulas in two separate columns can also be used as follows.

Leave Destination as is, or choose another column.

Choose General or Text, whichever you prefer.

Highlight the column that contains your list.

Use the Convert Text to Columns Wizard in Microsoft Excel to separate simple cell content, such as first names and last names, into different columns.įollow the steps below will convert coma separated list into cells in a column. The instructions below can be found on the Microsoft Website.

How to paste list into excel cells