With this WordPress plugin you can do Users Import and Export with Excel instantly – xlsx file
Data mapping – Drag and drop Excel Columns to User Fields easily. No More Hassle with CSV’s!
Users Export for WorPress in Excel by the hit of a button
Ajax driven plugin, very easy to use. All your data will be implemented on the spot, without any delay or inaccuracy.
The PRO Version of this wp plugin allows you to do Users & Customer Import Export for WooCommerce with their additional fields plus custom fields defined.
- If you are doing a website migration from another site to WordPress or the opposite, you can use this easy via excel import and export functionality.
- Navigate to Users -> Users Import/Export link or press ‘Settings’ link of the plugin on Plugins WP page.
- Create an excel or use the sample from plugin setting’s page with the data – 1st row is the heading eg. Name, 2nd row will have the user name. Use 1 row for each user. Each Column represents a field to import along with your user.
- Upload the excel file on Users Import Export with Excel for WordPress settings page.
- Once you upload, map the data from the excel to the user fields of WordPress.
Supported User Fields
- First Name
- Last Name
- Username – user_login
- Display Name
- User URL
- Roles – you can add multiple roles separated by comma
* Easily migrate your WooCommerce Store by exporting Customers to Excel and Easily Importing to your new website.
* Option to Send Email Notification on User Import
* Automap excel columns to User fields for ease of use
* Customers Import: Import WooCommerce Customers with Excel – supports their specific fields eg, addresses + custom fields defined
* Customers Export: Export WooCommerce Customers in Excel – supports their specific fields eg, addresses + custom fields defined
* Filter Users to Export by Creation Date
* Choose what addition User fields to Export
* Import / Export Users with roles defined customly or from other plugins
* Additional WooCommerce User Meta & other custom fields defined Supported
- Upload the plugin files to the
/wp-content/pluginsdirectory and unzip, or install the plugin through the WordPress plugins screen directly.
- Activate the plugin through the ‘Plugins’ screen in WordPress
- Use the Users Import/Export submenu link under Users or Settings link on plugins page to use the plugin.
- Upload your excel file (there is a link for a sample excel file) and proceed to data mapping and creating your users.
In which format do I import and Export Users?
You can easily create a .xlsx file or use the example file on plugin settings page. Export is made in xlsx as well.
Can I import or export WooCommerce Customers with Excel?
Yes, this feature is available in the PRO Version.
Contributors & Developers
“Users Import Export with Excel for WordPress” is open source software. The following people have contributed to this plugin.Contributors
Interested in development?
Compatibility with wp5.5