Skip to main content Skip to navigation

Create External Users in bulk

You can create External Users in bulk by uploading a spreadsheet in .csv format to the External Users system.
  1. Download the .csv template .
  2. Open the .csv file in your preferred spreadsheet program.
  3. 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.
  4. Go to the External Users system at https://ext-users.warwick.ac.uk.
  5. Under Actions, select Upload users in bulk.
  6. Select the Browse/Choose file button and attach your .csv file.
  7. In the Department box, enter the default department name. Any External Users in the .csv file with no department specified use the default name.
  8. Specify the expiry date for the External User codes.
  9. 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

    Upload External Users via spreadsheet

  10. Once you have finished entering the options, select Upload.
  11. 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.

    Preview External Users before import

Support

Telephone 73737
Email webteam at warwick dot ac dot uk