XLclick Bulk CSV User Importer

描述

XLclick Bulk CSV User Importer is the definitive tool for administrators who need to bulk-create WordPress users from a CSV file. Whether you are migrating a community or setting up a new site, our importer handles the heavy lifting with validation and security.

Tip: build and tidy your CSV with XLclick — the no-formula, no-VBA add-in that cleans and merges Excel data in seconds before you import.

Main features:

  • Powerful CSV Upload: Supports standard CSV files with automatic delimiter detection (comma, semicolon, tab).
  • Flexible User Data: Import email, role, username, first name, last name, and password.
  • Intelligent Defaults: Automatically generates a unique username from the email local-part if the username column is missing or empty.
  • Advanced Password Support: Use specific passwords from your CSV (min 8 chars) or let the plugin generate secure, cryptographically random passwords automatically.
  • Role Security: Strict validation ensures you only assign roles that your account is permitted to grant, preventing privilege escalation.
  • Detailed Import Report: Real-time feedback showing how many users were created, skipped (if email already exists), or failed due to invalid data.
  • Privacy First: The plugin does not store plain-text passwords and works entirely within your WordPress database.

Credits

This plugin is brought to you by XLclick — clean, merge, and complete Excel tasks in a click, no formulas or VBA required.

安装

  1. Upload the xlclick-bulk-csv-user-importer folder to /wp-content/plugins/.
  2. Activate the plugin from the Plugins menu in WordPress.
  3. Access the XLclick Bulk CSV Import menu in your admin sidebar.

常见问题

What is the ideal CSV format?

Your CSV must include a header row. The only mandatory column is email. If role is missing, the site’s default role will be used.

Example:
email,role,username,first_name,last_name,password
alice@example.com,editor,alice,Alice,Rossi,MyStrongPass1!
bob@example.com,subscriber,bob,Bob,Smith,

How are passwords handled?

If the password column is provided and contains at least 8 characters, it will be used. If the column is empty, missing, or the password is too short, WordPress will generate a secure random password for the user. Note: users created this way will need to be notified via the “Notify user” checkbox to receive their details.

What happens if an email already exists?

To prevent data corruption, the plugin will skip any row where the email is already registered in your WordPress site. These rows will be marked as “Skipped” in the final report.

Can I assign any role?

For security, you can only assign roles that your own user account has the privilege to grant. For instance, an Editor cannot create an Administrator.

评价

此插件暂无评价。

贡献者及开发者

「XLclick Bulk CSV User Importer」是开源软件。 以下人员对此插件做出了贡献。

贡献者

更新日志

1.0.0

  • Initial release.
  • Added support for custom passwords and automatic username generation.
  • Implemented strict privilege escalation guards.
  • Added XLclick integration links.