The Zoom Community is here!
We welcome all Zoom customers to come together on the Zoom Community to ask questions, find solutions,
and collaborate with peers. Login with your Zoom account credentials and start collaborating!

Zoom Support Maintenance: 9/18/2021

Date and time: 9/18/2021 at 1PM PST for 10 hrs 30 min

We will be performing routine maintenance for Zoom Support. During this time, users may experience system delays or longer than expected wait times when contacting Zoom Support via phone, chat or web submission. All other request methods, based on your plan, will be available during this time. Please refer to https://support.zoom.us/hc/articles/201362003 for available contact options.

Affected components: Zoom Support Center

Batch importing and updating users Follow

You can add or update Zoom users by uploading a CSV file. You can also add users one at a time with user management.

You can also deactivate, unlink, or delete several users at once.

This article covers: 

Prerequisites for importing or updating users

  • Free with credit card, Pro, Business, Education, or Enterprise account
  • Account owner or admin privileges

How to import new users

Follow these two sections to batch import new Zoom users.

Create a CSV file

Notes:

  • You will need to create separate CSV files for each set of user types and features you would like to apply. For example, you need to create two CSV files if you want to add the following two sets of users: Licensed users with a Webinar add-on and Basic users with no add-ons. 
  • Batch importing will not import account owners of paid accounts or accounts with any free trial. These users must be individually invited to the account
  • The maximum number of users per CSV file is 9999.
  1. Sign in to the Zoom web portal.
  2. In the navigation panel, click User Management then Users.
  3. Click the Users tab.
  4. On the right side of the page, click Import.
  5. Click Download CSV Sample to download a sample you can fill out.
    Note: You can also download a blank CSV sample for importing users.
  6. Open the file using spreadsheet software like Microsoft Excel.
  7. Enter users' information following the CSV format. Each piece of information is a separate column. 
    Note: The first three columns are required. Information in the other columns can be changed after importing users. 
    • Email (required)
    • First Name (required)
    • Last Name (required)
    • Department
    • Manager
    • User Group
    • IM Group
    • Job Title
    • Location
  8. Save the spreadsheet as a CSV (comma-delimited) file.

Uploading the CSV file to Zoom

  1. Sign in to the Zoom web portal.
  2. In the navigation panel, click User Management then Users.
  3. Click the Users tab.
  4. On the right side of the page, click Import.
    Note: Depending on the features available on your account, you may have other columns available. Clicking Import will list the definable columns available for your account.
  5. Select the user type and features to apply to all users in the CSV file.
  6. Click Upload CSV file.
  7. Click the CSV file you created, then click Open.
    Users will now appear on the Pending tab of User Management. They will receive an account activation email and will appear in the users list after they accept the invitation.

How to update existing users

You can batch update existing users by exporting a CSV file of users, editing it, then uploading it to the web portal.

Note: The formatting for importing users and updating users through CSV are different. Please ensure you are using the correct CSV template. 

  1. Sign in to the Zoom web portal.
  2. In the navigation panel, click User Management then Users.
  3. On the right side of the page, click Export then All users in the table.
    This will export a CSV file of existing users.
    Note: This will export the users currently displayed. If you don't want to export all users, use the search box and filters to only display some users, then click Export.
  4. Edit the CSV file using spreadsheet software like Microsoft Excel so that the exported CSV matches the required CSV format.
    Note: You can also download a blank CSV file for updating users.
  5. Go back to the Zoom web portal.
  6. In the navigation panel, click User Management then Users.
  7. Click Import.
  8. Click the Update Users tab.
  9. In the Select an action from the options listed below drop-down menu, select Update users’ information (user type, licenses, and other information).
  10. Click Upload CSV File.
  11. Click the CSV file you created, then click Open.
    Note: If you're having issues updating a user's phone number, you have to manually update their number by accessing their profile.

Required CSV format

  • The CSV should only have these columns: Email, First Name, Last Name, Phone Number, Department, Manager, User Type, Large Meeting, Webinar, Zoom Events, Job Title, Location. Delete any extra columns not on this list, as well as any user profiles created by Zoom Rooms, before importing. This is particularly important when exporting the list of users and utilizing that CSV for uploading to update users. 
  • Examples of valid values: 
    • User Type: Basic, Licensed, On-Prem
    • Large Meeting: Large 100, Large 500, etc.
    • Webinar: Webinar 500, Webinar 1000, etc.
    • Zoom Events: Zoom Events 500, etc. 
  • The Phone Number field is for user's external phone number in their profile. For Zoom Phone direct and extension numbers, you can batch assign phone numbers using the Phone System Management section of the web portal.
  • The format of the Phone Number field must be:
    [Label (optional)]: + [Country Code] [Phone Number] 
    • You can add up to 3 numbers
    • Separate multiple phone numbers with a vertical bar (|). For example:
      Mobile: +1 8887999666 | +1 8888999666.
    • The label can be Mobile, Office, Home, or Fax
    • You can only apply one labels to each phone number
  • If you don't want to change a field for the user, leave it blank. Leaving a blank entry will not update or clear the values in Zoom. For example if you leave department blank and the user already has a department, their department will not be changed or cleared.