Create External Users in bulk

You can create External Users in bulk by uploading a spreadsheet in .csv format to the External Users system.

Enter the External Users' details – for example:

Usercode	Password	Email	First Name	Last Name	Department	Group Name
xx_akurten	wordpass1	akurten@example.com	Anette	Kurten	IT Services	Green Festival Guest Speakers
xx_jdasilva	wordpass2	jdasilva@example.com	John	Da Silva	IT Services	Green Festival Guest Speakers
xx_abamagh	wordpass3	abamagh@example.com	Alfred	Abamagh	IT Services	Green Festival Guest Speakers

The naming convention for Usercode is your two-letter department code followed by an underscore, first initial and last name – for example, cu_akurten. To avoid clashes with student and staff University IDs, it must contain at least eight characters.
In the Department column, enter the name of the department the External User works for or, if applicable, the group or project they're involved in. This field helps you identify your External Users.
To add the External Users to an existing group, the Group Name in your .csv file must match the group name in the External Users system. Alternatively, if you want to create these External Users in a new group, leave the Group Name column blank; you can create a new group during the upload.

Go to the External Users system at https://ext-users.warwick.ac.uk.
Under Actions, select Upload users in bulk.
Select the Browse/Choose file button and attach your .csv file.
In the Department box, enter the default department name. Any External Users in the .csv file with no department specified use the default name.
Specify the expiry date for the External User codes.
Choose one of the following options to specify the group membership:
- Use an existing group – select the group from the Add to drop-down list
- Use groups in a CSV template – upload to the groups defined in your .csv file's Group Name column
- Create a new group – enter a name for the new group
Once you have finished entering the options, select Upload.
On the Import users screen, you see a preview of the .csv file's contents. If the data is accurate, select Import button. Otherwise, select Back, amend your .csv file and repeat steps 6-10.

Telephone 73737
Email webteam at warwick dot ac dot uk