sandywp / plugins / import-users-from-csv-with-meta
Import and export users and customers
Bulk import and export WordPress users and WooCommerce customers from CSV, including roles, passwords and any custom meta.
Ready in seconds.
v3.2.2 70,000+ installs WP 5.5+

What you get inside
8 screens-
Step 1: choose a CSV from your computer, a URL, Google Sheets or a file on the server, or start from a template
-
Step 2: the columns of any file are matched with WordPress and WooCommerce fields, values can be transformed and fields with the same value for every user can…
-
Step 3: role of the new users, users who already exist and welcome email
-
Step 4: preview of the import, with the transformed values, the users that will be created or updated and the rows with errors
-
Result of the import
-
Export with filters, WooCommerce guest customers and the column picker
-
History of the imports and exports
-
Welcome email template
About this plugin
Try it on a free demo site: https://demo.tastewp.com/import-users-from-csv-with-meta
Import, export and migrate WordPress users and WooCommerce customers with a CSV file. A step by step assistant matches the columns of any file with WordPress and WooCommerce fields, shows you a preview of what will happen and imports thousands of users in batches, keeping their roles, passwords and custom fields.
✅ Tested with WordPress 7.1 and WooCommerce 11.3
✅ More than 70,000 active installations
✅ Free, with optional premium add-ons for special needs
🆕 New in 3.1
- Export WooCommerce guest customers: the customers who bought without creating an account, with the billing and shipping details of their last order. Import the file later to create an account for each of them
- Transform values while importing: replace a text (“United States” → “US”), add a prefix to phone numbers, change upper or lower case or fill empty cells, without editing the file
- Add a field with the same value for every user, for data that is not in the file
- Choose the columns of the export by checking them, drag them to change their order and rename them
- Export specific users, searching them by email, username or name, and sort or limit the export
- Export to Excel (XLSX), OpenDocument (ODS) or XML with the File Formats addon, also from the shortcode and the recurring exports
- History of the last 100 imports and exports, with who made them, the file and the result
📥 Import users and customers
- Any column names, any order. Columns like “E-mail”, “Correo electrónico”, “Prénom” or “Telefon” are recognised automatically in six languages, and the email column is detected by its content
- Preview before importing: how many users will be created, updated or skipped, every row with an error and why, and a warning before any user is deleted. Nothing is saved until you start the import
- Download the rows with errors as a CSV, fix them and import them again
- Update existing users matched by ID, username or email, or skip them
- Keep passwords when you migrate from another WordPress site, or generate new ones
- Roles: one or several roles per user from a column of the file, or a default role
- Welcome email with a customizable template, wildcards and a test button
- Large files are imported in batches, so they do not time out
- Files saved from Excel just work: the encoding (UTF-8 or Windows-1252) and the delimiter are detected for you
- Templates: download a CSV with example data for users or WooCommerce customers
- From your computer, a URL, Google Sheets or a file on the server
- Import from the front-end with the
[import-users]shortcode
📤 Export users and customers
- Filter by role, registration date or specific users
- Choose, order and rename the columns, or export all of them, custom fields included
- Include WooCommerce guest customers
- Export password hashes so users keep their passwords in another site
- Sort the users and split big exports into several files
- Export from the front-end with the
[export-users]shortcode
⏱️ Automation
- Recurring import from a file or a URL every hour, day or week, to keep your users in sync with a CRM, an ERP or any external list
- History of every import and export, and a log of each recurring run
- Hooks to extend everything: list of actions and filters
🔌 Works with your plugins
- WooCommerce: billing and shipping fields, and guest customers
- WooCommerce Subscriptions: create subscriptions while users are imported
- WooCommerce Memberships and WooCommerce Membership by RightPress: memberships
- Paid Memberships Pro (including version 3), Indeed Ultimate Membership Pro, Paid Member Subscriptions and WP Members: membership levels
- BuddyPress and BuddyBoss: avatars, fields, groups and roles (and much more with the add-on)
- Advanced Custom Fields: your own fields
- WPML: translated front-end pages and emails (documentation)
- Groups, Users Group, WP Users Group and WP Private Content Plus: groups
- New User Approve: approve imported users or leave them pending
- Clean Login: the login link of the welcome email takes your users to its login page
- WP LMS Course: enroll users in courses
- Allow Multiple Accounts: same rules while importing
💬 What users say
“The final import of all 900+ users was quick and precise. Everything smooth like oil.”
— Paolo Beccari“I imported 31,000 users successfully, thanks to this plugin.”
— tbhpshop“I needed to import users, send them login details, and add them to specific Paid Memberships Pro membership levels, all of which it did flawlessly.”
— David Robinson“It even managed to import the custom roles that I created using the Members plugin.”
— Arischvaran Puvanesvaran“I’ve used this for years, importing classlists and updating classlists each term with my courses.”
— wpnovice2“The next morning, I had my fix in a new version. Amazing, personalized support.”
— pierre1wp
⭐ Premium add-ons
- Allow No Email: import users who do not have an email address
- File Formats: import XLSX, XLS and ODS spreadsheets and XML files directly, without converting them to CSV, and export to XLSX, ODS and XML
- Recurring Import: unlimited scheduled import tasks, each with its own file, period, role and notification email, and the columns of each file mapped like in the import assistant
- Recurring Export: unlimited scheduled export tasks, each saved to a folder of your server or sent by FTP, with its own filters, sorting and columns, WooCommerce guest customers and the XLSX, ODS and XML formats of the File Formats add-on
- Dokan: import Dokan marketplace vendors
- LearnDash: move LearnDash students between sites with their groups, courses, lessons and topics completed, quiz results and completion dates
- BuddyPress & BuddyBoss: move whole communities between sites in one package: complete profiles with visibility, photos and cover images, groups with roles and dates, profile types, connections, followers, account status and forums. Also imports groups and fixes members who do not appear in the members directory
- Sync: keep users in sync between several WordPress sites in real time and in both directions (new users, emails, passwords, roles, WooCommerce addresses and any user meta), instead of exporting and importing files
- Ultimate Member: import and export complete Ultimate Member profiles: every field of your forms converted to its type, profile and cover photos with their thumbnails, image and file fields, account status with or without emails, privacy and members directory visibility
- Multisite: for WordPress Multisite networks: each column saved for one site or for the whole network, the same template on every site, a different role on each site, users removed from sites and every user of the network exported in one file, ready to be imported in another network
🧭 How it works
Go to Tools > Import and export users and customers and follow the five steps:
- File: choose a CSV from your computer, a URL, Google Sheets or a file in your uploads folder
- Columns: check how each column will be imported, and transform values if you need to
- Options: default role, existing users and welcome email
- Preview: see what will happen and fix the rows with errors
- Import: the users are imported in batches, and the result is saved in the history
🛟 Need help?
- Read the questions below and the Documentation tab of the plugin
- Ask in the support forum
- Premium support, migrations and custom development: [email protected]
More plugins by Codection
- Clean Login (free): front-end login, registration and profile forms
- Payment Schedule for WooCommerce Subscriptions (premium)
- First payment date for WooCommerce Subscriptions (free)
- Products Restricted Users for WooCommerce (free)
- RedSys, Bizum and Ceca payment gateways for WooCommerce, Contact Form 7, Gravity Forms, WPForms, GiveWP, Easy Digital Downloads and more (premium)
Questions
- What file formats can I import?
CSV files, in UTF-8 or in the Windows-1252 encoding used by Excel, with any delimiter (comma, semicolon, tab…). The encoding and the delimiter are detected automatically. To import XLSX, XLS or ODS spreadsheets or XML files directly, use the File Formats add-on.
- Can I export to Excel?
The export creates a CSV file that Excel, LibreOffice and Google Sheets open directly. With the File Formats add-on you can also choose Excel (XLSX), OpenDocument (ODS) or XML in the “File format” option of the export, in the shortcode (
[export-users format="xlsx"]) and in the recurring exports.- Do my columns need special names?
No. In the second step of the assistant you match each column with a WordPress field, a WooCommerce field or a custom field, and most columns are recognised automatically. Columns you do not need can be ignored. If you use the classic screen, the first two columns must be the username and the email.
- Can I import WooCommerce customers?
Yes. Use columns for the billing and shipping fields (billing_first_name, billing_phone, shipping_address_1…) or match your own columns with them in the assistant. You can download a WooCommerce template with example data from the first step.
- Can I export WooCommerce guest customers?
Yes, since version 3.1. Check “WooCommerce guest customers” in the Export tab: you get one row per billing email with the details of the last order. Emails that already belong to a registered user are skipped. If you import that file, an account is created for each guest with the email as username.
- Can I migrate users from another WordPress site and keep their passwords?
Yes. Export the users with “Export password hashes” checked, and import the file in the new site matching the user_pass column as “Password hash (from another WordPress)”. Users keep the password they already had.
- What happens with users who already exist?
Users are matched by ID, username or email. In the third step you choose whether to update them or skip them. Their passwords, roles and emails only change if you allow it in More options.
- How are passwords managed?
If the file has no password column, new users get a random password, which they can receive in the welcome email or change with “Lost your password?”. If a cell has a value, that will be the password. Existing users only get a new password if you allow it in More options.
sandywp / also on the shelf
Try another plugin
WP Taxonomy Manager – CSV Import, Export & Bulk Term Tools
5.0 · 1K+ installs
Manage taxonomies and terms with CSV import/export, bulk editing, safe delete with undo, history, quality audit, redirects, and…
2.5 · 40+ installs
Automatically detect and import external images to your WordPress media library. Bulk process existing posts and prevent broken…
EasySecure Bulk Product Importer for WooCommerce
10+ installs
A simple and powerful plugin to import products into your WooCommerce-compatible store using Excel or CSV files.
Spin up a real WordPress site in seconds.
Test plugins, build a demo, hand a client a link — then squash it and start again. No local setup, no Docker.