Export and Import Users and Customers Premium

Export and Import Users and Customers Premium handles WordPress user and WooCommerce customer records for website transfers, backups, and bulk updates. It works with CSV, XML, XLS, and XLSX documents, with batch processing for larger data sets.

Prepare and import user data

Start with a structured file whose column headers and values match the expected WordPress user fields. For CSV files, you can work in Microsoft Excel, OpenOffice, LibreOffice, or Google Sheets and save the file in UTF-8 encoding. During import setup, map each column to its corresponding user field and transform values as needed. Evaluation fields can apply dynamic updates to user data.

Choose whether to update or skip existing customers. The password retention option lets users keep their existing passwords after a transfer. Imports can also send email notifications to users. Batch import is available for larger data sets.

Choose export records and fields

Map and transform export fields to control the output, including custom and hidden user meta. Filter records by one or more user roles, email address, or the date users were added. You can set an offset and limit, choose ascending or descending order, and include WooCommerce guest clients who purchased without creating an account.

Search for users by username or email, with suggestions for names and email addresses in the export fields. Multisite exports can include users from each sub-website. Export files can be used for a site transfer, backup, spreadsheet editing, or a later import.

Other transfer options

Along with local files, Premium can import data from a URL or Google Sheets. Scheduled FTP imports and exports can execute at intervals using Cron. WooCommerce customer order CSV export is handled by a separate order import and export plugin.

Run the transfer

For an import, prepare the file, map its headers to WordPress user fields, review the transformations and existing-user setting, then run the import. For an export, choose the records and fields, set the desired filters and transformations, and generate the file in the required format.