CSV files can be uploaded to Zoom so that users can be added or updated. It is also possible to add users one by one with the user management tool.

Furthermore, this feature lets you import a group of users by uploading a CSV file. During the editing process, you will be able to add, edit, update, or delete information about the user group when you upload a CSV file.

The user can also be temporarily deactivated, unlinked, or deleted at one time.

Prerequisites for importing or updating users

• With a credit card, you can open an account for free
• Pro, Business, Education, or Enterprise
• And get admin or owner privileges for free

How to import new users

Create a CSV file for users

1. Sign in to the Zoom website.
2. Click on User Management in the navigation bar and then click Users.
3. After that, you will see a tab called Users.
4. If you click Import on the right side of the page, you will see the imported users.
5. If you wish to download a sample CSV file that you can fill out, you can click Download CSV Sample.
6. A sample CSV file that is blank can also be downloaded for the purpose of importing users.
7. Simply open the file with a spreadsheet program, such as Microsoft Excel.
8. Then, enter the users’ information according to the CSV format.
   All the information should be placed in separate columns.
9. At least the first three columns must be included. After importing users, you can change the information in the other columns.
   • Email (required)
   • First Name (required)
   • Last Name (required)
   • Department
   • Manager
   • User Group
   • Job Title
   • Location
10. Prepare the spreadsheet as a comma-separated values (CSV) file.

Upload the CSV file to Zoom

1. Access the Zoom web portal by signing in.
2. Then, select User Management from the navigation menu and then Users from the drop-down list.
3. Once you have selected Users, you will be taken to the Users page.
4. There, you will see a link that says Import Users.
   Note:
5. You may also be able to see other columns depending on what features are available with your account. When you click Import, you will be taken to a page that shows all the columns that can be defined in your account.
6. Choose the type of user and the set of features that should apply to all users within the CSV file.
7. Once the CSV file has been uploaded, click on it.
8. After clicking the CSV file that you created, you will be able to open it.
   From now, you will see your users listed under the Pending tab. Upon accepting the invitation, the user will receive an email activating their account, and they will appear in the user list.

How to update existing users

Using the CSV export feature, you can export a list of existing subscribers, edit the CSV, then upload it to the web portal as a batch update.

Bulk update user type, licenses, and other information

1. Sign into the Zoom web portal using your email address and password.
2. Next, click on the User Management option from the navigation menu.
3. Then click All users in the table on the right side of the page.
   A CSV file with all existing users will be exported.
   Note:
4. When this option is selected, all currently displayed users will be exported. Use the search box and filters to display only some users if you do not wish to export all users, then click Export to bring them up.
5. It is possible to make sure that the exported CSV file matches the required format by editing the CSV file using a spreadsheet application such as Microsoft Excel.
   Note:
6. A blank CSV file can be downloaded in order to update users.
7. To do this, return to the Zoom website.
8. Click on User Management, then click on Users from the left hand navigation menu.
9. Select Import.
10. Select Update Users.
11. Choose Update users’ information from the options listed below the drop-down menu (user type, licenses, etc.) in the Select an action drop-down menu.
12. Browse to the CSV file and upload it.
13. Once the file is uploaded, click on it to open it.
    Note:
14. In order to update a user’s phone number, you must access their profile and manually update it.

Bulk update users’ emails

Zoom must enable this feature in order for it to work. Users can be updated by updating their email account login details or adding SSO login details. The bulk email address update permission in Role Management must be enabled if you wish to update users’ mail addresses in bulk. Click here for more information on role management.

1. If you are an admin in the Zoom web portal with the permission to update email addresses in bulk, you should log in as an admin.
2. Click on User Management, then click Users to open the User Management page.
3. To export the users in the table, click the Export button on the right side of the page.
   The users in the table will be exported as a CSV file.
4. The data that is currently displayed will be exported. You may only want to export some users, then click Export, if you do not want to export all users.
5. Excel can be used to edit the CSV file so that it conforms to the CSV format required.
6. If you wish to update users from a blank CSV file, you can download it here.
7. To return to the Zoom Website, select Users from the drop-down menu.
8. You can then click User Management from the navigation bar.
9. Then click Import.
10. On the Update Users tab, click the Update button.
11. Choose the option to update the email address of the users from the drop-down menu written below the Select an action link.
12. The verification code sent to your email needs to be entered before you can proceed if you do not have two-factor authentication.
13. Select the CSV file to upload.
14. When you have selected the CSV file to upload, you will need to click Open.
    The request will then be processed. For information about why the users’ emails couldn’t be updated, click the View Detail link in the banner for details about why there were errors during the update process. A notification email will be sent to the user with instructions on how to approve the email change request once the change request has been processed.

Required CSV format

• Only the following columns should be in the CSV:
• I have added the data email address, first name, last name, phone number, department, manager, group user type, large meeting, webinar, Zoom Events, job title, and location. Before importing, make sure that any extra columns not within this list are removed, as well as any user profiles created by Zoom Rooms. The export of the list of users is particularly important if the user information will be uploaded using CSV.
  Note:
• Only one group can be assigned to each user using CSV.
• These are some valid examples:
  • User Type: Free, Licensed, On-Premise
  • Large Meeting: 100 people, 500 people, etc.
  • Webinar: 500 people, 1000 people, etc.
  • Zoom Events: A Zoom Event for 500, etc.
• Contains the external phone number of the user in their profile which is in the Phone Number field of their profile. In the Zoom Phone web portal, there is a Phone System Management section where you can assign phone numbers batch-wise through the direct and extension numbers.
• It is important that you put the phone number in the following format:
  The label should include the following information: + [Country Code] [Phone Number]
  • You can add up to 3 numbers.
  • Each phone number should be separated by a comma. For example:
    Mobile: +1 8887999666, +1 8888999666
    • It is important that the phone number you send this email consists of the following (don’t use dashes or spaces):
      1. Plus sign (+)
      2. Country code
      3. Area code
      4. Phone number
    • Depending on the spreadsheet software you are using, you might not be able to start a cell with a plus sign. In order to include the plus sign (+) in the CSV file, you will need to save the file and then open it in a text editor. You may or may not find the phone number in quotation marks when viewing the CSV file in a text editor (either format will import correctly). You will not need to create a formula when you enter the plus sign (‘+) in Microsoft Excel.
  • Choosing a label can be as simple as Mobile, Home, Office, or Fax
  • Each phone number can only have one label
• Leaving a field blank will not change the user’s experience. Zoom will not update or clear its values if you leave a blank entry. The user will not have the ability to create a new department or change their existing department if you leave a department blank and the user already has one.

---

Read it also –

September 2020 Zoom Schedule Updating

Updating Dial In Countries On Audio Conferencing Plan In Zoom App

Updating Your Zoom Rooms To Version 5 0 5

Bulk Importing Or Updating Emergency Locations In Zoom

---

Frequently Asked Questions

What is CSV in zoom?

---

Related Articles

Batch Importing And Updating Users In Zoom App

Bulk Importing Contacts To An Address Book In Zoom App

Importing Keys And Positions Using A Csv File In Zoom

Batch Importing Or Exporting Phones And Devices In Zoom

Batch Importing Exporting Or Updating Phone Users In Zoom App

Importing Personal Contacts In Zoom App

Importing Webinar Registrants By Csv Upload In Zoom