Import Users & Customers with Meta | WP Ultimate CSV Importer Add-on vs Import and export users and customers

Migrating users to a new WordPress site, onboarding a customer database into WooCommerce, or managing members across a membership platform — all of it requires moving user data at scale, accurately and without duplicates. The Import Users & Customers with Meta Add-on makes this straightforward. This add-on extends WP Ultimate CSV Importer — the free parent plugin — to support bulk WordPress user import and WooCommerce customer import from CSV, XML, Excel, TSV, and Google Sheets files. It handles standard WordPress user fields, user meta, WooCommerce billing and shipping details, and profile data from popular membership plugins including WP-Members, MemberPress, BuddyPress, and the Listeo theme. It also includes a full user export system, so you can export WordPress users and WooCommerce customers to CSV, XML, XLS, XLSX, JSON, or TSV. This add-on requires the free WP Ultimate CSV Importer plugin. It is part of a complete data management ecosystem for WordPress and WooCommerce: WP Ultimate CSV Importer (Free, required) — Import posts, pages, custom post types, and more. Import Users & Customers with Meta (This plugin) — Bulk import and export WordPress users and WooCommerce customers with full meta support. Import WooCommerce Suite — Import WooCommerce products, orders, coupons, and reviews. WP Ultimate Exporter — Export any WordPress or WooCommerce data to CSV, XML, or other formats. Install just what you need, or use all four together for a complete import/export solution. Key Features Flexible Import Sources You can import user data from: – Your desktop – FTP/SFTP servers – External URLs (Google Sheet / Dropbox) Supports Multiple File Formats Import from a wide range of file formats including: – CSV – XML – Excel (XLS/XLSX) – TSV – Google Sheets – ZIP files containing structured data Import WordPress Users and WooCommerce Customers Bring in new users with: – Standard WordPress fields – User meta – WooCommerce billing and shipping information – Additional customer details like phone, address, notes, and more Membership Plugin Compatibility Seamlessly import profile data for: – WP-Members – MemberPress – BuddyPress Automatic Password Handling If your CSV (or other import file) doesn’t include a password, the plugin generates a secure one and automatically emails it to the user. Smart Field Mapping Use an intuitive drag-and-drop interface or dropdown suggestions to map all your fields correctly. If your file headers and WordPress field headers are same, the plugin will automatically maps them. This makes large and complex imports easier and faster. Conditional Filters for Imports Apply filters to import only the specific users you want based on conditions like role, status, or any metadata, helping you maintain clean and organized data imports. Duplicate Handling Prevent duplicate user creation by validating user email. Use update mode to modify existing users instead of creating new ones. (Pro feature) Iteration-Based Import Large files are split into smaller manageable chunks (iterations), ensuring that high-volume imports run smoothly without server timeouts. Monitor Import Progress Track import status in real time, view logs, and quickly resolve any issues. Errors are highlighted clearly for easy debugging. Export Capabilities The add-on is not only for importing, it also provides a full user export system. Export Users and WooCommerce Customers Export: – WordPress users – WooCommerce customers – All their meta fields Multiple Export Formats Export your user data into file formats like: – CSV – XML – XLS – XLSX – JSON – TSV Iteration Export and Date-Based Export Export users in batches or export only users created during a specific time period. Preview Before Export Review your user data before downloading to ensure accuracy. One-Click User Migration Move users between sites seamlessly with the one-click import & migrate feature. Use Cases Migrate users from another WordPress site — Export users from your old site and bulk import them into your new one, including all meta fields and roles. Import WooCommerce customers — Bring in a customer database with billing addresses, shipping addresses, phone numbers, and notes in one import run. Onboard members from a spreadsheet — Import a list of new members into WP-Members, MemberPress, or BuddyPress from a CSV or Excel file. Sync users from an external system — Import user data from a CRM, LMS, or HR system exported as CSV or Google Sheets. Import users after a platform switch — Moving from Shopify, Magento, or another CMS? Import your customer list directly into WooCommerce. Bulk update user roles or meta — Use update mode (PRO) to change roles, update profile fields, or assign membership levels across hundreds of users at once. Migrate membership site data — Import MemberPress or WP-Members subscriber data including subscription levels and profile fields. Export users for backup or audit — Export your full WordPress user database or WooCommerce customer list to CSV, Excel, or JSON at any time. How It Works Install WP Ultimate CSV Importer (Free). Install and activate this add-on. Upload your source file or choose an external source. Map fields using the drag-and-drop UI or dropdown mode. Apply filters if required. Run the import and track progress live. How to Import Users 1. Prepare Your File Create a CSV, Excel, XML, TSV, or Google Sheet containing user fields such as username, email, user meta, and WooCommerce billing/shipping data. 2. Go to Import Screen Navigate to Ultimate CSV Importer Free → Import/Update page. 3. Choose File Source Upload your file from desktop, FTP/SFTP, or external URL. Only fresh import is allowed. For update, you require pro version. 4. Map Fields Match your file columns to WordPress Users fields using drag-and-drop or dropdown mapping mode. 5. Apply Filters (Optional) Apply conditional filters to import only users matching specific roles, dates, or others. 6. Run Import Click Import to instantly run it. You can configure iterations and other settings before proceeding the import. The plugin can processes large files. It shows progress, errors, and completed entries after import. How to Export Users 1. Visit Export Screen Go to WP Ultimate CSV Importer → Export. 2. Choose What to Export Select Users or WooCommerce Customers from the modules list. 3. Select Export Format Provide a file name and select export file formats like CSV, XML, XLS, XLSX, TSV, or JSON. 4. Preview (Optional) Click Preview button to review selected users and fields before exporting. 5. Download Export File Click Export and the export file will be prepared. Then click Download to save the file to your device. WP Ultimate CSV Importer Pro Features WP Ultimate CSV Importer offers many advanced features in its pro version. Here are some listed below: Update Existing Users Modify existing WordPress users and WooCommerce customers without creating duplicates. Update roles, profile data, and meta fields while keeping user IDs intact. Scheduled Imports Run cron-based automatic schedule import from FTP/SFTP, and Google Sheets. Useful for sites that receive user data on a regular basis from external systems. Mapping Templates Save your field mapping once and reuse it for future imports, making repeated or scheduled tasks easier to manage. Import and Export All WordPress Data Pro supports full-site data handling, including posts, products, orders, taxonomies, custom fields, comments, and SEO fields, enabling complete migrations. Advanced Export Options Export users and other WordPress data with filters, date ranges, selected fields, user roles, or in iteration mode for large datasets, and much more. One-Click Rollback Revert an import instantly if needed, helping maintain clean and reliable user data. Visit WP Ultimate CSV Importer Pro plugin here Other Useful Plugins & Addons By Smackcoders The Leads Builder for WordPress to capture your webforms as leads to one of the top ranking open source CRM, install the WordPress Lead Form Data Collection to CRM Plugin. Install one of the CRM of your choice with the additional add-ons listed below and keep both parent plugin and CRM addon activated. * Zoho CRM & Zoho CRM Plus * Salesforce * SugarCRM * Freshsales * Vtiger CRM To know more about the premium bundled version, visit WordPress Lead Form Data Collection to CRM with unlimited features Helpful links Visit Smackcoders to explore more WordPress products. You can write to us your comments, feedback at [email protected]. Get to know about other WordPress addons and latest product update news at www.smackcoders.com/blogs.html.

Try it out on your free dummy site: Click here => https://demo.tastewp.com/import-users-from-csv-with-meta Import, export and migrate WordPress users and WooCommerce customers from a CSV file. Bulk-create or update thousands of users in seconds, schedule automatic recurring imports from a local file or URL, and carry over roles, passwords and any custom meta field. Works with WooCommerce, BuddyPress, Advanced Custom Fields, Paid Membership Pro, WooCommerce Memberships, WooCommerce Subscriptions and many more. Import CSV file with users directly to your WordPress or customers into WooCommerce Import thousands of users or customers in only some seconds Export users or customers to a CSV file, filtering by role or registered date You can also import meta-data like data from WooCommerce customers You can assign roles while importing. Send a mail to every new user, this mails can be saved as templates and are fully customizable, before sending you can test it You can also update users if the user is already in your WordPress Create a cron task to import users periodically Edit the metadata (you will be able to edit the metadata imported using metakeys directly in the profile of each user) Extend the plugin using the hooks we provide Compatible with WPML read the documentation to see how you can translate the front-end import and export users page and send translated email notifications to users Moreover this plugin is compatible with many other plugins to be able to import and include them data, subscriptions, memberships, etc. Take a look: WooCommerce: to import the customer data WooCommerce Memberships: to import memberships WooCommerce Subscriptions: to create subscriptions associated with users while they are being imported BuddyPress: to import custom BuddyPress avatars, fields, groups and roles Advanced Custom Fields: to import data to the fields you define there Paid Membership Pro: to import memberships, included compatibility with PMPro version 3 Indeed Ultimate Membership Pro: to import memberships Paid Member Subscriptions: to import memberships Allow Multiple Accounts: plugin will allow the same rules importing than this plugin Groups: to assign users to groups while importing New User Approve: you can import users and approbe/wait for approve them Users Group: to assign users to groups while importing WP LMS Course: to enroll users in the courses while importing WP Members: to import memberships WP Users Group: to assign users to groups while importing WooCommerce Membership by RightPress: to create memberships while users are being imported WP Private Content Plus: To import and export the groups to which users are assigned If you have some problem or doubt: Read our documentation Ask anything in support forum, we try to give the best support Common use cases Migrate users from one WordPress site to another Bulk create or update WooCommerce customers from a spreadsheet Sync users automatically from an external CRM or ERP via CSV Onboard members to a membership site (Paid Membership Pro, WooCommerce Memberships) Periodically import subscribers or students from an external list Import users from the frontend using a shortcode Usage Once the plugin is installed you can use it. Go to Tools menu and there, there will be a section called Insert users from CSV. Just choose your CSV file and go! CSV generation You can generate CSV file with all users inside it, using a standar spreadsheet software like: Microsoft Excel, LibreOffice Calc, OpenOffice Calc or Gnumeric. You have to create the file filled with information (or take it from another database) and you will only have to choose CSV file when you “Save as…” the file. As example, a CSV file is included with the plugin. Some considerations Plugin will automatically detect: Charset and set it to UTF-8 to prevent problems with non-ASCII characters. It also will auto detect line-ending to prevent problems with different OS. Finally, it will detect the delimiter being used in CSV file Other plugins by Codection RedSys Gateway for WooCommerce Pro (premium) Ceca Gateway for WooCommerce Pro (premium) RedSys Gateway for Contact Form 7 (premium) Ceca Gateway for Contact Form 7 (premium) RedSys & Bizum Gateway for Gravity Forms (premium) RedSys & Bizum Gateway for WPForms (premium) RedSys & Bizum for GiveWP (premium) RedSys Link Generator (premium) RedSys & Bizum Gateway for EDD Pro (premium) RedSys Gateway for WP Booking Calendar Pro (premium) Clean Login (free) Products Restricted Users for WooCommerce (free) First payment date for WooCommerce Subscriptions (free) Payment Schedule for WooCommerce Subscriptions (premium)