{"id":64965,"date":"2022-09-28T15:33:56","date_gmt":"2022-09-28T15:33:56","guid":{"rendered":"\/tutorials\/?p=64965"},"modified":"2025-12-02T15:20:15","modified_gmt":"2025-12-02T15:20:15","slug":"wordpress-export-users","status":"publish","type":"post","link":"\/ca\/tutorials\/wordpress-export-users\/","title":{"rendered":"WordPress export user: how to export to csv file + multisite export"},"content":{"rendered":"<p>When running a WordPress website, you might need to export your users&rsquo; data. Unfortunately, WordPress doesn&rsquo;t provide built-in functionality for exporting user data. The only way to do it is using an import and export user plugin.<\/p><p>With this in mind, we will cover the steps to exporting users from one WordPress site to another using a plugin. We will also suggest three excellent plugins for the job.<\/p><p>First, let&rsquo;s look at the reasons why user export is an important feature every administrator should know.<\/p><p class=\"has-text-align-center\"><a href=\"https:\/\/assets.hostinger.com\/content\/tutorials\/pdf\/Mega-WordPress-Cheat-EN.pdf\" target=\"_blank\" rel=\"noopener\">Download all-in-one WordPress cheat sheet<\/a><\/p><p>\n\n\n\n\n<\/p><h2 class=\"wp-block-heading\" id=\"h-why-export-users-in-wordpress\">Why Export Users in WordPress<\/h2><p>When exporting users in WordPress, you can achieve the following goals:<\/p><ul class=\"wp-block-list\">\n<li><a href=\"\/ca\/tutorials\/how-to-migrate-wordpress\/\">Migrate WordPress<\/a> to a new site.<\/li>\n\n\n\n<li>Merge multiple websites into a multisite network.<\/li>\n\n\n\n<li>Back up all of your users&rsquo; data.<\/li>\n\n\n\n<li>Have offline access to your customer or subscriber data.<\/li>\n\n\n\n<li>Import subscriber or customer data to an email list or CRM.<\/li>\n<\/ul><h2 class=\"wp-block-heading\" id=\"h-how-to-export-wordpress-users-using-a-plugin\">How to Export WordPress Users Using a Plugin<\/h2><p>You can download many WordPress export and import plugins in the official plugin directory. In this tutorial, you&rsquo;ll learn how to export WordPress users with the <a href=\"https:\/\/wordpress.org\/plugins\/import-users-from-csv-with-meta\/\" target=\"_blank\" rel=\"noopener\">Import and Export Users and Customers<\/a> plugin.<\/p><ol class=\"wp-block-list\">\n<li><a href=\"\/ca\/tutorials\/wordpress\/how-to-install-wordpress-plugins\/\">Install and activate the plugin<\/a>.<\/li>\n<\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><a href=\"\/ca\/tutorials\/wp-content\/uploads\/sites\/2\/2022\/09\/The-Import-and-Export-Users-and-Customers-plugin-banner.png\"><img loading=\"lazy\" decoding=\"async\" width=\"813\" height=\"329\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/09\/The-Import-and-Export-Users-and-Customers-plugin-banner.png\/public\" alt=\"The Import and Export Users and Customers plugin banner\" class=\"wp-image-64967\"  sizes=\"auto, (max-width: 813px) 100vw, 813px\" \/><\/a><\/figure><\/div><ol class=\"wp-block-list\" start=\"2\">\n<li>Navigate to <strong>Tools<\/strong> -&gt; <strong>Import and export users and customers<\/strong> from your WordPress admin area. Open the <strong>Export <\/strong>tab.<\/li>\n<\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"\/ca\/tutorials\/wp-content\/uploads\/sites\/2\/2022\/09\/The-Export-tab-of-the-Import-and-Export-Users-and-Customers-plugin-displaying-the-configurations-to-set-up-before-downloading-the-CSV-file.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1903\" height=\"858\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/09\/The-Export-tab-of-the-Import-and-Export-Users-and-Customers-plugin-displaying-the-configurations-to-set-up-before-downloading-the-CSV-file.png\/w=1024,h=1024,fit=scale-down\" alt=\"The Export tab of the Import and Export Users and Customers plugin, displaying the configurations to set up before downloading the CSV file\" class=\"wp-image-64968\"  sizes=\"auto, (max-width: 1903px) 100vw, 1903px\" \/><\/a><\/figure><\/div><ol class=\"wp-block-list\" start=\"3\">\n<li>Fill in the constraints to narrow down the number of WordPress users you want to export:<\/li>\n<\/ol><ul class=\"wp-block-list\">\n<li><strong>Role <\/strong>&#8210; export WordPress users based on their user role. Leave the <strong>All roles<\/strong> option to export all user roles.<\/li>\n\n\n\n<li><strong>Columns <\/strong>&#8210; determine which columns you want to export and in what order. Leave it empty to export all columns.<\/li>\n\n\n\n<li><strong>User created<\/strong> &#8210; filter WordPress user data based on their registration date.<\/li>\n<\/ul><ol class=\"wp-block-list\" start=\"4\">\n<li>Leave the rest of the settings to their default values and select <strong>Download <\/strong>to save the CSV file locally. You can open CSV files on Microsoft Excel and Google Sheets.<\/li>\n<\/ol><p>You can easily import users into another standalone site using the same plugin. After installing <strong>Import and Export Users and Customers <\/strong>on the other WordPress site, open the <strong>Import <\/strong>tab and upload the CSV file containing exported user data.<\/p><p>Navigate to the <strong>Documentation <\/strong>tab for a complete breakdown of the plugin settings.<\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"\/ca\/tutorials\/wp-content\/uploads\/sites\/2\/2022\/09\/The-Import-tab-of-the-Import-and-Export-Users-and-Customers-plugin-where-admin-can-import-user-data-using-a-CSV-file.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1904\" height=\"856\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/09\/The-Import-tab-of-the-Import-and-Export-Users-and-Customers-plugin-where-admin-can-import-user-data-using-a-CSV-file.png\/w=1024,h=1024,fit=scale-down\" alt=\"The Import tab of the Import and Export Users and Customers plugin, where admin can import user data using a CSV file\" class=\"wp-image-64970\"  sizes=\"auto, (max-width: 1904px) 100vw, 1904px\" \/><\/a><\/figure><\/div><p>        <div class=\"protip\">\n            <div class=\"protip__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path d=\"M1.49234 23.5024C1.23229 23.5024 0.972242 23.4024 0.782206 23.2123C0.562165 22.9923 0.452144 22.6822 0.502153 22.3722C0.562165 21.9221 1.14227 17.9113 3.00262 16.351C3.63274 15.8209 4.43289 15.5509 5.26305 15.5609C6.09321 15.5909 6.87335 15.9109 7.47347 16.4911C8.6937 17.6913 8.76371 19.6717 7.6435 20.9919C6.0832 22.8523 2.08245 23.4324 1.63237 23.4924C1.59236 23.4924 1.54235 23.4924 1.50234 23.4924L1.49234 23.5024ZM5.16303 17.5613C4.84297 17.5613 4.53291 17.6713 4.29287 17.8813C3.60274 18.4614 3.07264 19.9317 2.75258 21.242C4.06282 20.9219 5.5331 20.3918 6.11321 19.7017C6.55329 19.1716 6.54329 18.3814 6.0832 17.9213C5.85316 17.7013 5.5431 17.5713 5.20304 17.5613C5.19304 17.5613 5.17303 17.5613 5.16303 17.5613ZM11.7243 21.8821C11.4942 21.8821 11.2642 21.8021 11.0841 21.652C10.8541 21.462 10.7241 21.1819 10.7241 20.8819V15.9109L8.08358 13.2705H3.11264C2.81259 13.2705 2.53254 13.1404 2.3425 12.9104C2.15246 12.6803 2.07245 12.3803 2.12246 12.0902C2.19247 11.7102 2.84259 8.36953 4.70294 7.12929C6.33325 6.04909 8.96375 6.49918 10.244 6.80923C11.5442 4.96889 13.2546 3.4286 15.2349 2.33839C17.4553 1.11816 19.9858 0.518051 22.4963 0.498047C23.0464 0.498047 23.4865 0.948132 23.4865 1.49824C23.4865 5.0389 22.3763 9.97983 17.1753 13.7605C17.4853 15.0408 17.9354 17.6613 16.8552 19.2816C15.615 21.1419 12.2744 21.7921 11.8943 21.8621C11.8343 21.8721 11.7743 21.8821 11.7143 21.8821H11.7243ZM12.7245 16.181V19.6016C13.7146 19.2916 14.7948 18.7915 15.2049 18.1814C15.675 17.4812 15.605 16.091 15.385 14.9008C14.5248 15.3808 13.6346 15.8109 12.7245 16.181ZM9.66388 12.0302L11.9643 14.3307C13.1845 13.8306 14.3648 13.2204 15.485 12.5103C19.9358 9.51974 21.2361 5.60901 21.4561 2.53843C19.6157 2.67846 17.8254 3.20856 16.2051 4.09872C14.2847 5.14892 12.6544 6.68921 11.4942 8.54956C10.7841 9.65977 10.174 10.82 9.66388 12.0302ZM4.39289 11.2701H7.81353C8.1936 10.3599 8.63368 9.46974 9.11377 8.60957C7.92355 8.38953 6.51329 8.31952 5.81315 8.78961C5.19304 9.19968 4.70294 10.3099 4.39289 11.2701Z\" fill=\"#673DE6\"\/>\n                <\/svg>\n                <p class=\"protip__title\">\n                    Pro Tip                <\/p>\n            <\/div>\n            <p class=\"protip__content\"> To transfer WordPress subscribers accumulated using a mailing list plugin, you need to export the list through your plugin first and then import it to another WordPress website.<\/p>\n                    <\/div>\n        \n\n\n<figure class=\"wp-block-image size-large\"><a class=\"hgr-tutorials-cta hgr-tutorials-cta-wordpress-hosting\" href=\"\/ca\/wordpress-hosting\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"2048\" height=\"600\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2024\/06\/New-WP_in-text-banner.png\/w=1024,h=1024,fit=scale-down\" alt=\"\" class=\"wp-image-111781\"  sizes=\"auto, (max-width: 2048px) 100vw, 2048px\" \/><\/a><\/figure>\n\n\n\n<\/p><h2 class=\"wp-block-heading\" id=\"h-3-best-wordpress-user-export-plugins\">3 Best WordPress User Export Plugins<\/h2><p>One of the advantages of building a website in <a href=\"\/ca\/tutorials\/what-is-wordpress\/\">WordPress is<\/a> that you have plenty of plugin options to choose from. We have selected the three best plugins for exporting WordPress users based on their price and features.<\/p><h3 class=\"wp-block-heading\" id=\"h-1-import-and-export-users-and-customers\">1. Import and Export Users and Customers<\/h3><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><a href=\"\/ca\/tutorials\/wp-content\/uploads\/sites\/2\/2022\/09\/The-Import-and-Export-Users-and-Customers-plugin-banner-in-the-WordPress-plugin-directory.png\"><img loading=\"lazy\" decoding=\"async\" width=\"772\" height=\"250\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/09\/The-Import-and-Export-Users-and-Customers-plugin-banner-in-the-WordPress-plugin-directory.png\/public\" alt=\"The Import and Export Users and Customers plugin banner in the WordPress plugin directory\" class=\"wp-image-64971\"  sizes=\"auto, (max-width: 772px) 100vw, 772px\" \/><\/a><\/figure><\/div><p><strong>Plugin stats:<\/strong><\/p><ul class=\"wp-block-list\">\n<li><strong>Downloads:<\/strong> 70,000+<\/li>\n\n\n\n<li><strong>Rating:<\/strong> 4.8\/5<\/li>\n\n\n\n<li><strong>Price:<\/strong> <strong>free<\/strong><\/li>\n<\/ul><p>You have seen how easy it is to use this free plugin to import and export WordPress users. It also has an email feature to help you notify users of the changes and the site&rsquo;s data-protection considerations.<\/p><p>If you&rsquo;re running a WooCommerce store, this export plugin can import data from your WooCommerce customers. Besides WooCommerce, the plugin is compatible with Advanced Custom Fields, Paid Membership Pro, and WP LMS Course.<\/p><p>As for the import feature, it&rsquo;s possible to create a cron task to do the process periodically if you want to integrate the existing site with an external system. The plugin also offers a shortcode to import WordPress users from the front end.<\/p><h3 class=\"wp-block-heading\" id=\"h-2-wp-all-export\">2. <a href=\"https:\/\/wordpress.org\/plugins\/wp-all-export\/\" target=\"_blank\" rel=\"noopener\">WP All Export<\/a><\/h3><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"\/ca\/tutorials\/wp-content\/uploads\/sites\/2\/2022\/09\/The-WP-All-Export-plugin-banner.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"332\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/09\/The-WP-All-Export-plugin-banner.png\/w=1024,h=1024,fit=scale-down\" alt=\"The WP All Export plugin banner\" class=\"wp-image-64972\"  sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><\/div><p><strong>Plugin stats:<\/strong><\/p><ul class=\"wp-block-list\">\n<li><strong>Downloads:<\/strong> 90,000+<\/li>\n\n\n\n<li><strong>Rating:<\/strong> 4.6\/5<\/li>\n\n\n\n<li><strong>Price:<\/strong> <strong>freemium <\/strong>(the premium version starts from <strong>$99\/lifetime<\/strong>)<\/li>\n<\/ul><p>WP All Export simplifies the export procedure of WordPress custom data. It has a convenient drag-and-drop interface, making arranging CSV columns and XML elements easier before exporting them.<\/p><p>Unfortunately, you need to upgrade to the Pro plan for <strong>$99\/lifetime <\/strong>to use the plugin for bulk exporting users. Pro users can send the export file to various cloud storage services, schedule exports, and add rules to filter exported data. The plugin also supports WooCommerce integration, allowing you to export order data.<\/p><p>If you need the import feature, consider getting the Import + Export Pro plan for <strong>$299\/lifetime<\/strong>. It unlocks all the premium features in WP All Export and WP All Import plugins &#8210; convenient for moving user accounts between websites in a WordPress multisite network.<\/p><p>[<a href=\"https:\/\/www.wpallimport.com\/upgrade-to-wp-all-export-pro\/\" target=\"_blank\" rel=\"noopener\">DOWNLOAD<\/a>]<\/p><h3 class=\"wp-block-heading\" id=\"h-3-import-export-wordpress-users-and-woocommerce-customers\">3. <a href=\"https:\/\/wordpress.org\/plugins\/users-customers-import-export-for-wp-woocommerce\/\" target=\"_blank\" rel=\"noopener\">Import Export WordPress Users and WooCommerce Customers<\/a><\/h3><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"\/ca\/tutorials\/wp-content\/uploads\/sites\/2\/2022\/09\/The-Import-Export-WordPress-Users-and-WooCommerce-Customers-plugin-banner.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1544\" height=\"500\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/09\/The-Import-Export-WordPress-Users-and-WooCommerce-Customers-plugin-banner.png\/w=1024,h=1024,fit=scale-down\" alt=\"The Import Export WordPress Users and WooCommerce Customers plugin banner\" class=\"wp-image-64973\"  sizes=\"auto, (max-width: 1544px) 100vw, 1544px\" \/><\/a><\/figure><\/div><p><strong>Plugin stats:<\/strong><\/p><ul class=\"wp-block-list\">\n<li><strong>Downloads:<\/strong> 60,000+<\/li>\n\n\n\n<li><strong>Rating:<\/strong> 4.7\/5<\/li>\n\n\n\n<li><strong>Price:<\/strong> <strong>freemium <\/strong>(the premium version costs <strong>$69\/year <\/strong>for a single site)<\/li>\n<\/ul><p>The Import Export WordPress Users plugin is an ideal choice for WooCommerce owners. Like WP All Export, this plugin offers batch export and import features. You can easily export WooCommerce customers, users and guests to CSV while retaining login details. <\/p><p>Upgrading to the Pro plan for <strong>$69\/year<\/strong> lets you schedule imports and exports, bulk update existing users, and map and transform user fields when importing and exporting users from WordPress.<\/p><p>Besides providing different filter options like user role and date range, the Pro plan also supports import from URLs. The plugin allows you to export WordPress users to CSV, XML, Excel (XLS, XLSX), and TSV files. Use the pre-saved template to save time during each import and export procedure.<\/p><p>[<a href=\"https:\/\/www.webtoffee.com\/product\/wordpress-users-woocommerce-customers-import-export\/\" target=\"_blank\" rel=\"noopener\">DOWNLOAD<\/a>]<\/p><h2 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusion<\/h2><p>WordPress user data is essential information that every WordPress admin should manage regularly. Knowing how to export users from WordPress will help preserve and process user details when moving to a new website or wanting to access data offline.<\/p><p>This article has provided the steps to export WordPress users using the Import and Export Users and Customers plugin. We have also gone through the three best WordPress export plugins:<\/p><ul class=\"wp-block-list\">\n<li><strong>Import and Export Users and Customers<\/strong> &ndash; the most affordable option.<\/li>\n\n\n\n<li><strong>WP All Export<\/strong> &ndash; offers a beginner-friendly drag-and-drop interface.<\/li>\n\n\n\n<li><strong>Import Export WordPress Users and WooCommerce Customers<\/strong> &ndash; ideal for WooCommerce users.<\/li>\n<\/ul><p>We hope this article answers everything you want to learn about exporting WordPress users. Good luck!<\/p><p>        <div class=\"protip\">\n            <div class=\"protip__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path d=\"M1.49234 23.5024C1.23229 23.5024 0.972242 23.4024 0.782206 23.2123C0.562165 22.9923 0.452144 22.6822 0.502153 22.3722C0.562165 21.9221 1.14227 17.9113 3.00262 16.351C3.63274 15.8209 4.43289 15.5509 5.26305 15.5609C6.09321 15.5909 6.87335 15.9109 7.47347 16.4911C8.6937 17.6913 8.76371 19.6717 7.6435 20.9919C6.0832 22.8523 2.08245 23.4324 1.63237 23.4924C1.59236 23.4924 1.54235 23.4924 1.50234 23.4924L1.49234 23.5024ZM5.16303 17.5613C4.84297 17.5613 4.53291 17.6713 4.29287 17.8813C3.60274 18.4614 3.07264 19.9317 2.75258 21.242C4.06282 20.9219 5.5331 20.3918 6.11321 19.7017C6.55329 19.1716 6.54329 18.3814 6.0832 17.9213C5.85316 17.7013 5.5431 17.5713 5.20304 17.5613C5.19304 17.5613 5.17303 17.5613 5.16303 17.5613ZM11.7243 21.8821C11.4942 21.8821 11.2642 21.8021 11.0841 21.652C10.8541 21.462 10.7241 21.1819 10.7241 20.8819V15.9109L8.08358 13.2705H3.11264C2.81259 13.2705 2.53254 13.1404 2.3425 12.9104C2.15246 12.6803 2.07245 12.3803 2.12246 12.0902C2.19247 11.7102 2.84259 8.36953 4.70294 7.12929C6.33325 6.04909 8.96375 6.49918 10.244 6.80923C11.5442 4.96889 13.2546 3.4286 15.2349 2.33839C17.4553 1.11816 19.9858 0.518051 22.4963 0.498047C23.0464 0.498047 23.4865 0.948132 23.4865 1.49824C23.4865 5.0389 22.3763 9.97983 17.1753 13.7605C17.4853 15.0408 17.9354 17.6613 16.8552 19.2816C15.615 21.1419 12.2744 21.7921 11.8943 21.8621C11.8343 21.8721 11.7743 21.8821 11.7143 21.8821H11.7243ZM12.7245 16.181V19.6016C13.7146 19.2916 14.7948 18.7915 15.2049 18.1814C15.675 17.4812 15.605 16.091 15.385 14.9008C14.5248 15.3808 13.6346 15.8109 12.7245 16.181ZM9.66388 12.0302L11.9643 14.3307C13.1845 13.8306 14.3648 13.2204 15.485 12.5103C19.9358 9.51974 21.2361 5.60901 21.4561 2.53843C19.6157 2.67846 17.8254 3.20856 16.2051 4.09872C14.2847 5.14892 12.6544 6.68921 11.4942 8.54956C10.7841 9.65977 10.174 10.82 9.66388 12.0302ZM4.39289 11.2701H7.81353C8.1936 10.3599 8.63368 9.46974 9.11377 8.60957C7.92355 8.38953 6.51329 8.31952 5.81315 8.78961C5.19304 9.19968 4.70294 10.3099 4.39289 11.2701Z\" fill=\"#673DE6\"\/>\n                <\/svg>\n                <p class=\"protip__title\">\n                    Learn what else you can do with WordPress                <\/p>\n            <\/div>\n            <p class=\"protip__content\"><a href=\"\/ca\/tutorials\/speed-up-wordpress\/\">How to Speed Up WordPress<\/a><br>\n<a href=\"\/ca\/tutorials\/wordpress-tags\/\">How to Use WordPress Tags<\/a><br>\n<a href=\"\/ca\/tutorials\/how-to-install-wordpress\/\">How to Install WordPress<\/a><br>\n<a href=\"\/ca\/tutorials\/wordpress-maintenance-mode\/\">How to Enable Maintenance Mode in WordPress<\/a><br>\n<a href=\"\/ca\/tutorials\/change-wordpress-password\/\">How to Change User Password in WordPress<\/a><br>\n<a href=\"\/ca\/tutorials\/wordpress\/how-to-login-to-wordpress-dashboard\/\">How to Login to WordPress<\/a><\/p>\n                    <\/div>\n        \n\n\n\n<\/p><h2 class=\"wp-block-heading\" id=\"h-wordpress-export-users-faqs\">WordPress Export Users FAQs<\/h2><p>The following frequently asked questions can help you understand WordPress export users better.<\/p><div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1681363729483\"><h3 class=\"schema-faq-question\">How Do I Export Specific User Roles From WordPress?<\/h3> <p class=\"schema-faq-answer\">WordPress does not have a built-in option to export specific user roles. However, you can use a plugin like WP All Export to export the users in a specific role. You can choose to export the data in different formats, such as CSV or XML, and customize the exported fields.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1681363748932\"><h3 class=\"schema-faq-question\">How Do I Export WordPress Users to a CSV File?<\/h3> <p class=\"schema-faq-answer\">Use a plugin like <strong>Export Users to CSV<\/strong>. Go to the <strong>Users <\/strong>section in your WordPress dashboard and select the users you want to export. Then, click on the <strong>Export Users<\/strong> button, and the plugin will generate a CSV file with the selected user data.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1681363765797\"><h3 class=\"schema-faq-question\">Where Are Users Stored in WordPress?<\/h3> <p class=\"schema-faq-answer\">WordPress users are stored in the website&rsquo;s database, specifically in the <strong>wp_users <\/strong>and <strong>wp_usermeta<\/strong> tables. The<strong> wp_users <\/strong>table contains basic user information such as the username, email address, and password. The <strong>wp_usermeta<\/strong> table contains additional user data, such as the user&rsquo;s display name and profile picture.<\/p> <\/div> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>When running a WordPress website, you might need to export your users&rsquo; data. Unfortunately, WordPress doesn&rsquo;t provide built-in functionality for exporting user data. The only way to do it is using an import and export user plugin. With this in mind, we will cover the steps to exporting users from one WordPress site to another [&#8230;]<\/p>\n<p><a class=\"btn btn-secondary understrap-read-more-link\" href=\"\/ca\/tutorials\/wordpress-export-users\/\">Read More&#8230;<\/a><\/p>\n","protected":false},"author":115,"featured_media":139489,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"rank_math_title":"WordPress Export Users: How to Export to CSV File","rank_math_description":"Exporting WordPress Users can be useful for site migration. Check out this article to learn how to effectively export WordPress users.","rank_math_focus_keyword":"wordpress export users","footnotes":""},"categories":[22694,22692],"tags":[],"class_list":["post-64965","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-website-management","category-wordpress"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/tutorials\/wordpress-export-users","default":0},{"locale":"pt-BR","link":"https:\/\/www.hostinger.com\/br\/tutoriais\/exportar-usuarios-wordpress","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/tutoriels\/exporter-des-utilisateurs-wordpress","default":0},{"locale":"en-GB","link":"https:\/\/www.hostinger.com\/uk\/tutorials\/wordpress-export-users","default":0},{"locale":"en-MY","link":"https:\/\/www.hostinger.com\/my\/tutorials\/wordpress-export-user-how-to-export-to-csv-file-multisite-export","default":0},{"locale":"en-PH","link":"https:\/\/www.hostinger.com\/ph\/tutorials\/wordpress-export-user-how-to-export-to-csv-file-multisite-export","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/pt\/tutoriais\/exportar-usuarios-wordpress","default":0},{"locale":"en-IN","link":"https:\/\/www.hostinger.com\/in\/tutorials\/wordpress-export-users","default":0},{"locale":"en-CA","link":"https:\/\/www.hostinger.com\/ca\/tutorials\/wordpress-export-users","default":0},{"locale":"en-AU","link":"https:\/\/www.hostinger.com\/au\/tutorials\/wordpress-export-users","default":0},{"locale":"en-NG","link":"https:\/\/www.hostinger.com\/ng\/tutorials\/wordpress-export-users","default":0}],"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/ca\/tutorials\/wp-json\/wp\/v2\/posts\/64965","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/ca\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/ca\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/ca\/tutorials\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/ca\/tutorials\/wp-json\/wp\/v2\/comments?post=64965"}],"version-history":[{"count":9,"href":"https:\/\/www.hostinger.com\/ca\/tutorials\/wp-json\/wp\/v2\/posts\/64965\/revisions"}],"predecessor-version":[{"id":138106,"href":"https:\/\/www.hostinger.com\/ca\/tutorials\/wp-json\/wp\/v2\/posts\/64965\/revisions\/138106"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/ca\/tutorials\/wp-json\/wp\/v2\/media\/139489"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/ca\/tutorials\/wp-json\/wp\/v2\/media?parent=64965"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/ca\/tutorials\/wp-json\/wp\/v2\/categories?post=64965"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/ca\/tutorials\/wp-json\/wp\/v2\/tags?post=64965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}