Title here
Summary here
User Exporter
Export your WordPress users to CSV files for backups, migrations, or external analysis. Choose which roles to export and which fields to include, then download a clean CSV file ready for spreadsheets or import into other systems.
Use Cases
- Create backups of your user database before major changes
- Migrate users to a new WordPress installation or platform
- Export email lists for newsletter or marketing campaigns
- Analyze user demographics and registration patterns
- Generate reports for stakeholders or compliance audits
- Sync users with CRM or external membership systems
How It Works
- Open the User Exporter module settings
- Select which user role to export (or all users)
- Choose which fields to include in the export
- Click “Export to CSV”
- A CSV file downloads automatically to your computer
Where to Find It
Go to Switchboard → User Management and find the User Exporter module. Click the settings icon to access the export interface.
Export Options
User Role Filter
Choose which users to export:
| Option | Description |
|---|---|
| All Roles | Export every user on your site |
| Administrator | Only users with admin role |
| Editor | Only users with editor role |
| Author | Only users with author role |
| Contributor | Only users with contributor role |
| Subscriber | Only users with subscriber role |
| (Custom roles) | Any other roles appear here too |
Each option shows the user count in parentheses, e.g., “Subscriber (150)” so you know how many records will be exported.
Include Fields
Toggle which fields to include in your export:
| Field | Default | Description |
|---|---|---|
| Email Address | ✓ On | User’s email address |
| Registration Date | ✓ On | When the account was created |
| Display Name | ✓ On | User’s display name |
| First & Last Name | Off | Separate first name and last name columns |
| Website URL | Off | User’s website from profile |
Username and Role are always included as the first two columns.
CSV Output Format
The exported CSV file includes:
ID,Username,Role,Email,Display Name,Registered
1,admin,administrator,admin@example.com,Site Admin,2023-01-15 10:30:00
2,johndoe,subscriber,john@example.com,John Doe,2024-02-20 14:45:00
3,janesmith,editor,jane@example.com,Jane Smith,2024-03-10 09:15:00File Naming
Files are automatically named with the export date and time:
users-export-2024-03-15-143052.csvThis format (YYYY-MM-DD-HHMMSS) ensures each export has a unique filename and you can easily identify when it was created.
Using the Export
Opening in Excel
- Download the CSV file
- Open Excel
- Go to File → Open
- Select the CSV file
- Excel will parse the columns automatically
Opening in Google Sheets
- Download the CSV file
- Open Google Sheets
- Go to File → Import
- Upload the CSV file
- Choose “Replace current sheet” or “Insert new sheet”
Importing to Another WordPress Site
For user migration, you’ll need a CSV import plugin since WordPress doesn’t have built-in user import. Popular options include:
- WP All Import
- Import Users from CSV
Settings
This module doesn’t have persistent settings. Each time you export, you choose the role and fields fresh. This gives you flexibility to create different exports for different purposes.
Security Notes
- Only Administrators can access the export feature
- Exports are generated on-demand and not stored on the server
- The CSV file downloads directly to your browser
- Exported data includes email addresses - handle according to your privacy policy
FAQ
Does this export passwords?
No. Passwords are never included in exports for security reasons. WordPress stores passwords as hashed values that wouldn’t be useful anyway.Can I export custom user meta fields?
The built-in export includes standard WordPress user fields. Custom meta fields from other plugins aren’t included. For comprehensive user meta export, consider using a database export tool.Is there a limit on how many users I can export?
No hard limit, but very large exports (tens of thousands of users) may take longer to generate. The export processes all matching users in a single request.Can I schedule automatic exports?
Not with this module. Exports are manual, on-demand operations. For automated backups, consider a full WordPress backup solution.Why are some users showing multiple roles?
If you use the Multiple User Roles module, users can have more than one role. The export shows all roles separated by commas (e.g., “editor, shop_manager”).Can I export to other formats like JSON or XML?
Currently only CSV format is supported. CSV is widely compatible with spreadsheets, databases, and import tools. For JSON export, you’d need a custom solution.Before major site changes (like switching themes or updating WordPress), export your users as a backup. It’s quick insurance that takes seconds.
The export uses your site’s timezone for registration dates. If importing to another system, verify that timestamps are interpreted correctly.
PRO
Upgrade to Pro
Get access to all 147 modules with a single license