Import and Export WordPress User Metadata

WordPress user metadata can be imported and exported along with user data using the WordPress Users & WooCommerce Customers Import Export plugin. The plugin processes both standard user fields and additional metadata (stored in the wp_user and wp_usermeta tables), ensuring complete user data migration between sites.

This is especially useful when migrating or syncing users across multiple sites, as it preserves all associated custom and hidden metadata.

Know more about how the user data are stored in the database.

Let us have a look into how this plugin imports and exports  user metadata.

1. Navigate to WebToffee Import Export (Pro), after installing and activating the plugin via Plugin Setup .
2. Click on Import and follow the steps in How to import users to get your site’s user data.
3. On reaching step 3, the following window will appear from where you can:
   • Select the required custom meta fields you want to import
   • change values of the column name
     
4. Proceed to step 4 and import.

This will import the users in a CSV/ XML file to your website. The exported CSV/XML/TSV/XLS/XLSX file will contain all the users and their related metadata.

1. Navigate to WebToffee Import Export (Pro) after installing and activating the plugin via Plugin Setup.
2. Click on Export and follow the steps in How to export users to export your site’s user data.
3. On reaching step 4, the following window will appear from where you can:
   • select the required custom meta fields you want to export
   • change values of the column name
   • re-arrange their order

4. Proceed to step 5 and export.

This will export the users in a file that will be downloaded locally on your computer. The exported file will contain all the users and their related metadata.

The plugin efficiently handles the user data and meta data  with utmost security during both export and import.

Know more about Import and Export.