There are three main criteria when assessing WordPress plugins to import users from Excel:
Of these three criteria, only the third needs elaboration, as there are four typical variations:
In this article, we rank the plugins from our The 5 Best WordPress User Import Plugins article against these criteria for Excel files.
WP All Import is the one plugin in this list that can do it all.
First, it can import from either Excel file format (.xls or .xlsx).
Second, it has an advanced filter system so that you can limit incoming users to those that you truly want to import into your WordPress database.
Third, it gives you complete control over the layout and format of incoming Excel data. For example, to create a unified address field, you can combine literal values with multiple incoming data elements:
You can use simple inline PHP formulas to control the format of individual user fields. For instance, this function deletes any instances of commas inside an incoming data element:
If that's not sufficient, you can use WP All Import's embedded function feature to apply far more sophisticated changes. Here, a custom function is used to round a dollar amount:
This function can then be applied to any relevant field in the import process.
With this toolset, you can convert any type of incoming Excel data into exactly the WordPress user field values that you require.
Beyond these layout and format capabilities, you can also:
For more information, see Import Users From CSV, Excel, and XML.
Like WP All Import, this plugin will import directly from either Excel format.
However, it doesn't let you filter incoming users.
In terms of modifying data during an import, it will let you merge incoming user fields:
And it will let you apply some operators to numeric fields:
But it won't let you use inline PHP functions or create custom functions, so your ability to correct layout or formatting problems in Excel is extremely limited.
You also can't selectively update specific fields, meaning you have to take an all-or-nothing approach for user updates.
Finally, while other Webtoffee plugins provide good coverage of WooCommerce data types, this is not true for other WordPress data types. So, after learning the Webtoffee, you may still have to learn completely different plugins for other import tasks.
All in all, this feels very much like a WP All Import Lite.
For additional information, see Export and Import Users and Customers.
This is the third and final plugin on this list that will import directly from either Excel file format.
It has a good data filter system very similar to that of WP All Import.
It will let you selectively update user fields, as well as choose how to match existing users on your site.
Unfortunately, it won't let you modify incoming data in any meaningful way, as it lacks the ability to use inline PHP functions when populating WordPress user fields, and it doesn't have any kind of embedded function editor.
This makes this plugin substantially less capable than WP All Import, though it is a bit more flexible than Webtoffee's Export and Import Users and Customers plugin. So, why isn't it ranked above Webtoffee's plugin? There are two main reasons:
For more information, see Woo Import Export.
This plugin cannot import users directly from Excel file formats.
To learn more, see Import and Export Users and Customers.
This plugin cannot import users directly from Excel file formats.
To learn more, see Import Users from CSV.
Unfortunately, there are not many plugins that will let you import WordPress users directly from Excel. In the case of this list, we're limited to just three plugins.
Of those three, there is a clear distinction between WP All Import and the other two. WP All Import will let you do everything you could possibly want with data from an Excel file. You can filter it, reorganize it, and modify it in every way imaginable, from small inline changes to drastic changes based on conditional logic — all during the import itself. You can dictate whether to just add new users, update existing users, or even delete existing users that are not found in the import file.
Put another way, there is no import action that you can't do with WP All Import.
The other two plugins that can import directly from Excel involve significant tradeoffs. With the Export and Import Users and Customers plugin by Webtoffee, you have no control over which users are imported from the incoming data or which fields get updated for existing users, though you can modify the incoming data at a field level in a few limited ways.
With Woo Import Export, you get good filtering capabilities but lose the ability to modify the incoming data.
This is not a great situation if you prefer to have a lot of plugin candidates for any given task, but it is what it is.
The 5 Best WordPress User Import Plugins
The 5 Best Plugins for WordPress User Import from CSV
The 5 Best WordPress CSV Import Plugins To Speed Up Your Workflow in 2024