What CSV format is required for the user import?

The CSV file must have columns for 'Email', 'First Name', 'Last Name', and 'Group'. Other optional columns include 'Department' and 'Job Title'. Refer to the Zoom help center for a full list of supported columns and their formatting requirements.

What happens if the email address in the CSV already exists in Zoom?

If the email address already exists as a Zoom user, the import process will typically skip that user and not create a duplicate. You can configure the import process to update existing user profiles with new information from the CSV file, if desired.

Are there any limitations on the number of users I can import at once?

Zoom has limits on the maximum number of users you can import via CSV in a single operation. Review the Zoom documentation for specific limits based on your account type to avoid import failures and potential errors.

How do I troubleshoot errors during the CSV import process?

Common errors during CSV import include incorrect CSV formatting, invalid email addresses, or exceeding account limitations. Check the Zoom import log for detailed error messages, and ensure your CSV file meets all specified requirements before attempting the import again.

How to bulk import users from CSV in Zoom

Bulk importing users in Zoom allows administrators to quickly add multiple users to their account using a CSV file. This process requires creating a properly formatted CSV file containing user information, then uploading that file through the Zoom web portal. This guide details the steps involved in bulk importing users.

Prerequisites

A Zoom account with admin privileges.
A CSV file containing the required user information (email, first name, last name).
Ensure you have sufficient user licenses available on your Zoom account.
Confirm the CSV file is properly formatted according to Zoom’s specifications.

Prepare Your CSV File

Open a spreadsheet program such as Microsoft Excel, Google Sheets, or Numbers.
Create the following column headers:
- email (required)
- first_name (required)
- last_name (required)
- group_name (optional): Enter group names to add users to specific groups during import.
- department (optional)
- job_title (optional)
- location (optional)
- phone_number (optional)
- cost_center (optional)
Enter user data in the corresponding columns. Ensure each row represents a unique user.
Save the file as a CSV (Comma Separated Values) file. In most spreadsheet programs, you can select “File” > “Save As” and then choose CSV from the file format dropdown menu.

Access the User Management Page in Zoom

Sign in to the Zoom web portal as an administrator.
Navigate to User Management: In the left-hand navigation menu, click on “User Management” and then “Users.”

Initiate the Bulk Import Process

Click “Add Users”: On the Users page, locate and click the “Add Users” button.
Select “Import”: From the “Add Users” dropdown menu, choose the “Import” option. This will open the bulk import page.

Upload Your CSV File

Locate the Upload Area: On the Import Users page, you will find a designated area to upload your CSV file.
Upload your CSV file: Click the “Upload” button and select the CSV file you prepared earlier. You may also be able to drag and drop the file into the designated area.

Review and Confirm the Import

Preview the Import: After uploading, Zoom will process the CSV file and display a preview of the users to be imported. Review this information carefully to ensure the data is correct.
Correct any Errors: If Zoom detects any errors in the CSV file (e.g., invalid email addresses, missing required fields), it will highlight them. Correct these errors in your original CSV file and re-upload. You can also edit user information directly within the Zoom web portal on this page, although doing so negates the benefit of bulk import.
Initiate the Import: Once you are satisfied with the preview and have corrected any errors, click the “Import” button to begin the user import process.

Monitor the Import Progress

Check the Status: After initiating the import, Zoom will display a progress bar indicating the status of the import.
Review the Results: Once the import is complete, Zoom will display a summary of the results, including the number of users successfully imported and any users that failed to import.
Download Error Report (If Applicable): If some users failed to import, Zoom may provide an option to download an error report. This report will contain detailed information about why the users failed to import, allowing you to correct the issues and re-import the corrected user data.

Assign Licenses and Settings

Assign licenses: After the users are added to the account, you’ll need to assign them a license so they can use a paid account.
Configure user settings: Go to User Management > Users > Select a user > Profile to set up other user options.

Common Issues

CSV File Format Errors: Ensure the CSV file is properly formatted with the correct column headers and values. Verify that the file is saved as a true CSV file and not a different file type with a .csv extension. Open the CSV file in a text editor to visually confirm the formatting.
Invalid Email Addresses: Verify that all email addresses in the CSV file are valid and properly formatted. Zoom will reject users with invalid email addresses.
Missing Required Fields: The email, first_name, and last_name fields are required. Ensure that all users in the CSV file have values for these fields.
Duplicate Email Addresses: Zoom will reject users with email addresses that already exist in your account or another Zoom account. Deactivate, unlink, or delete the existing account or use a unique email address.
License Limitations: If you do not have enough licenses available on your Zoom account, the import may fail to add all users. Check your account’s license usage and purchase additional licenses if needed.