Modify users with CSV template
You can update service assignments for up to 20,000 people in Control Hub, including Hybrid Services and Webex Meetings.
Before you begin
-
If you've more than one CSV file for your organization, then upload one file at a time. Once the task is complete, you can upload the next file.
-
You can’t delete any users and locations with the CSV template.
-
You can't change the location assigned to a Webex Calling user with the CSV template.
-
For Webex Calling users, the following fields in the CSV file are mandatory:
User ID/Email
- Webex Calling license column,
Webex Calling VAR Basic [sub-site name]
orWebex Calling VAR Professional[sub-site name]
, with the valueTRUE
. Phone Number
and/orExtension
Location
If you've not included these mandatory fields, the changes made to the other columns may not be reflected.
- For non-Webex Calling users, the
User ID/Email
column is the only mandatory field. - For Webex Customer Experience Essentials users, the following fields in the CSV file are mandatory:
User ID/Email
- Customer Experience Essentials license column,
Customer Experience Essentials[sub-site name]
, with the valueTRUE
. Phone Number
and/orExtension
Location
Some spreadsheet editors remove the + sign from cells when they open the .csv file. We suggest you use a text editor to make .csv updates. If you use a spreadsheet editor make sure to set the cell format to text, and add back any + signs that were removed.
Export a new CSV to capture the latest fields and avoid errors in the import of changes.
1 |
From the customer view in https://admin.webex.com, go to . |
2 |
Click Export and Download CSV. The export begins.
|
3 |
Click Download to download the file. |
4 |
Edit the required columns in the downloaded file.
|
5 |
After you save the CSV file, click Import, select the file that you modified, and then click Open. |
6 |
Choose either Add services only or Add and remove services, and click Submit. A user can't have two Calling licenses. If your organization has multiple subscriptions, and you want to move users to a new subscription, choose the Add and remove services option. To add services, set the cells to TRUE and remove services by setting those cells to FALSE. The user CSV no longer includes the columns for UC Manager Profile, Calling Behavior, and Calling Behavior UC Manager Profile. Instead, the Call Behavior and UCM Profile can be managed in bulk using the calling template. For more information, see: Set up calling behavior. The CSV file uploads and creates your task. You can close the browser or this window and your task continues to run. To review the progress of your task, see Manage Tasks in Cisco Webex Control Hub. If you don't suppress admin invite emails, new users receive activation emails. |