Feature Summary

Batch import or update organization member information via Excel templates, suitable for batch onboarding, organizational structure adjustments, or initial Contacts setup.

Feature Description

Feature Dimension Description
Plan Restrictions No plan restrictions
Version Restrictions No version restrictions

Steps

Batch Import New Members

Feature Entry
Office Document → Contacts → Organizational Structure → Batch Import/Update

  1. Open the WPS365 client and click Office Document in the lower-left corner of the client homepage.
  2. Click Contacts in the left-side list.
  3. Click Organizational Structure, then click Batch Import/Update under the "Users" tab
  4. Click Download Template to obtain the standard Excel template file.
  5. Open the template and fill in member information according to the format:
  • Red headers are required fields (Name, Email, etc.)
  • Optionally fill in Department, Position, Mobile Number, Employee ID, and other information.

6.Save the Excel file.

7.Return to the batch import window and click Upload File.

8.Check "Create corresponding department teamspace when importing departments" (optional).

9.Click Start Import. The system will automatically validate the data and import.

imageimage

Batch Update Existing Members

Feature Entry
Office Document → Contacts → Organizational Structure → Batch Import/Update

  1. In the batch import window, select the Batch Update mode.
  2. Export the template containing existing member information.
  3. Modify the member information that needs to be updated.
  4. Upload the file. The system will automatically identify changes and update.
  5. Click Start Update to complete the update.

image

FAQ

Q1: What should I do if duplicate data appears during batch import?

  • Solution: The system uses email as the unique identifier for deduplication. If the imported email already exists in the organization, it will skip or update the existing record and will not add duplicates.

Q2: What should I do if some members do not appear in the expected department after import?

  • Solution: Please check whether the department name filled in Excel is exactly the same as the department name in Office Document. If the department does not exist, a new department will be automatically created during import.

Q3: Are there any time or quantity limits for batch import?

  • Solution: A single import supports a maximum of 5,000 records. It is recommended to import in batches if exceeding this limit. After the import is complete, the system will display the number of successes and the reasons for failures. You can correct the data based on the prompts and re-import.

Notes

  • Use the most recently downloaded template and do not modify the header structure.
  • Red headers are required fields and cannot be left blank.
  • Checking "Create corresponding department teamspace" during import will automatically generate a document collaboration space.
  • After the import is complete, it is recommended to check whether the Contacts data is complete and accurate.