Import Users From Any CSV/Excel/XML with WP All Import Pro
WP All Import Pro can import WordPress users, WooCommerce products, ACF, custom post types, custom fields, taxonomies, and everything else:
Drag & Drop to Import Any File: Give any CSV or XML to WP All Import, then drag and drop to map data from your file into WordPress.
Any Custom Post Type, Every Data Type: Import data to custom post types, with support for WooCommerce, ACF, custom fields, taxonomies, and everything else.
Import Images & Galleries: Images can be uploaded, downloaded, or matched to media already in WordPress. Full support for WooCommerce product images and variation galleries.
Import Files from URL: Download and import files from external websites, even if they are password protected. URL imports are can be re-run to add, edit, and delete posts.
Scheduled Imports: WP All Import Pro can check periodically check a file for updates and then add, update, or delete to the imported posts accordingly.
Developer Friendly: Pass data through custom PHP functions. For example, use something like [my_function( {user_email[1]} )] in your template, to pass the value of {user_email[1]} to my_function and display whatever it returns.
Priority Support: Personal support from our team of expert developers with over a decade of experience importing and exporting WordPress data.
90 Day Money Back Guarantee: Not 100% happy? Let us know, and we’ll promptly send you a refund. No questions asked.
How to export WordPress users? Drag & drop to export WordPress users (and everything else) to a custom CSV, Excel, or XML with WP All Export Pro.
Installation
For an automatic installation through WordPress:
Go to the ‘Add New’ plugins screen in your WordPress admin area
Search for ‘Import Users from CSV’
Click ‘Install Now’ and activate the plugin
Upload your CSV file in the ‘Users’ menu, under ‘Import From CSV’
For a manual installation via FTP:
Upload the import-users-from-csv directory to the /wp-content/plugins/ directory
Activate the plugin through the ‘Plugins’ screen in your WordPress admin area
Upload your CSV file in the ‘Users’ menu, under ‘Import From CSV’
To upload the plugin through WordPress, instead of FTP:
Upload the downloaded zip file on the ‘Add New’ plugins screen (see the ‘Upload’ tab) in your WordPress admin area and activate.
Upload your CSV file in the ‘Users’ menu, under ‘Import From CSV’
Screenshots
User import screen
FAQ
How to use?
Click on the ‘Import From CSV’ link in the ‘Users’ menu, choose your CSV file, choose if you want to send a notification email to new users and if you want the password nag to be displayed when they login, then click ‘Import’.
Each row in your CSV file should represent a user; each column identifies user data or meta data.
If a column name matches a field in the user table, data from this column is imported in that field; if not, data is imported in a user meta field with the name of the column.
Look at the example.csv file in the plugin directory to have a better understanding of how the your CSV file should be organized.
You can try importing that file and look at the result.
BUG FIX: Ensure user running import has the ability to add users
Update tested to
minor UI update
1.1
ENHANCEMENT: Added support for WPCLI (@mircobabini)
ENHANCEMENT: Added support for multiple roles during import, use comma-separated value for multiple roles (@mircobabini)
ENHANCEMENT: Removed password nag option as this is no longer supported.
ENHANCEMENT: New filter added ‘is_iu_errors_filter’ for throwing error messages. Helpful for third party developers extending onto IUCSV functionality.
1.0.1
Fixed timeout bug on import.
Improved settings area layout.
General code refactor and improved security.
Screenshot update.
1.0.0
Fixed bug where importing fields with “0” value doesn’t work
Added option to update existing users by username or email
0.5.1
Removed example plugin file to avoid invalid header error on installation
0.5
Changed code to allow running import from another plugin
0.4
Switched to RFC 4180 compliant library for CSV parsing
Introduced IS_IU_CSV_DELIMITER constant to allow changing the CSV delimiter
Improved memory usage by reading the CSV file line by line
Fixed bug where any serialized CSV column content is serialized again on import
0.3.2
Fixed php notice when importing
0.3.1
Don’t process empty columns in the csv file
0.3
Fixed bug where password field was overwritten for existing users
Use fgetcsv instead of str_getcsv
Don’t run insert or update user function when only user ID was provided (performance improvement)
Internationalization
Added display name to example csv file
0.2.2
Added role to example file
Fixed bug with users not imported when no user meta is set