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.

FAQ

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”(은)는 오픈 소스 소프트웨어입니다. 다음의 사람들이 이 플러그인에 기여하였습니다.

기여자

자국어로 “XLclick Bulk CSV User Importer”(을)를 번역하세요.

개발에 관심이 있으십니까?

코드 탐색하기는, SVN 저장소를 확인하시거나, 개발 기록RSS로 구독하세요.

변경이력

1.0.0

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