WPS Bulk Import Updates on Windows FAQ

Last updated:July 17, 2026

Common questions about Bulk Import Updates usually involve duplicate data, department assignment, and import limits; this FAQ covers 3 frequent questions and practical solutions.

FAQ

What should I do if duplicate data appears during a bulk import?

  1. Check whether the email field is duplicated in the import file.
  2. The system uses email addresses as the main identifier for duplicate checks. If an email address already exists in the enterprise, the record is skipped or updated instead of being added again.
  3. If you want to keep the latest information, review the current member data first and then run a bulk update.

Why are some imported members not shown in the expected department?

  1. Check whether the department names in the Excel file exactly match the department names in the admin console.
  2. If the import file includes a department that does not yet exist, use the option to create corresponding department teams during import.
  3. After the import is complete, return to the Organization Structure page and confirm the final member assignment.

What is the bulk import limit in WPS Office on Windows?

  1. A single import supports up to 5,000 records. If you need more, split the data into batches.
  2. After the import is complete, the system shows the number of successful records and the reasons for failed records.
  3. Revise the template based on the failure messages, then upload the file again if needed.

Glossary

TermDefinition
Bulk ImportA method of adding many member records at one time by uploading a template file.
Bulk UpdateA method of revising information for multiple existing members by using an exported data template.
Organization StructureThe department and member hierarchy in the enterprise directory used to display and manage assignments.
Excel TemplateThe standard spreadsheet file used to enter member fields before import or update.