{"id":107563,"date":"2019-08-14T08:55:21","date_gmt":"2019-08-14T08:55:21","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/users-import-export-with-excel-for-wordpress\/"},"modified":"2024-11-25T07:10:49","modified_gmt":"2024-11-25T07:10:49","slug":"users-import-export-with-excel-for-wp","status":"publish","type":"plugin","link":"https:\/\/pcd.wordpress.org\/plugins\/users-import-export-with-excel-for-wp\/","author":18216844,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"1.6","stable_tag":"trunk","tested":"6.7.5","requires":"3.0.1","requires_php":"8.1","requires_plugins":null,"header_name":"Users Import Export with Excel for WordPress","header_author":"extendWP","header_description":"Import Export Users for WordPress with Excel.","assets_banners_color":"d1e3da","last_updated":"2024-11-25 07:10:49","external_support_url":"","external_repository_url":"","donate_link":"https:\/\/extend-wp.com\/users-import-export-with-excel-for-wordpress\/","header_plugin_uri":"","header_author_uri":"https:\/\/extend-wp.com","rating":3,"author_block_rating":0,"active_installs":100,"downloads":6433,"num_ratings":2,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":{"1.0":"","1.1":"<p>Compatibility with wp5.5<\/p>","1.2":"<p>Compatibility with wp6<\/p>","1.3":"<p>Compatibility with wp6.4 and hpos<\/p>","1.4":"<p>PHP spreadsheet library instead of phpexcel\nimport customers with excel<\/p>","1.5":"<p>fix css<\/p>","1.6":"<p>update phpspreadsheet<\/p>"},"ratings":{"1":1,"2":0,"3":0,"4":0,"5":1},"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":2139342,"resolution":"128x128","location":"assets","locale":""}},"assets_banners":{"banner-772x250.png":{"filename":"banner-772x250.png","revision":2139342,"resolution":"772x250","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":[],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":2139342,"resolution":"1","location":"assets","locale":""},"screenshot-2.png":{"filename":"screenshot-2.png","revision":2139342,"resolution":"2","location":"assets","locale":""},"screenshot-3.png":{"filename":"screenshot-3.png","revision":2139342,"resolution":"3","location":"assets","locale":""}},"screenshots":{"1":"Import Users &amp; Customer - Export Users with Excel for WordPress Import screen","2":"Import Users &amp; Customer - Export Users with Excel for WordPress data mapping","3":"Import Users &amp; Customer - Export Users with Excel for WordPress Export screen"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[207580,207579,154044,14850,150105],"plugin_category":[45],"plugin_contributors":[168527,88613],"plugin_business_model":[],"class_list":["post-107563","plugin","type-plugin","status-publish","hentry","plugin_tags-customers-import","plugin_tags-export-excel","plugin_tags-user-export","plugin_tags-user-import","plugin_tags-users-import","plugin_category-ecommerce","plugin_contributors-productexcelimport","plugin_contributors-taz_bambu","plugin_committers-taz_bambu","plugin_committers-wpcodefactory"],"banners":{"banner":"https:\/\/ps.w.org\/users-import-export-with-excel-for-wp\/assets\/banner-772x250.png?rev=2139342","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/users-import-export-with-excel-for-wp\/assets\/icon-128x128.png?rev=2139342","icon_2x":false,"generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/users-import-export-with-excel-for-wp\/assets\/screenshot-1.png?rev=2139342","caption":"Import Users &amp; Customer - Export Users with Excel for WordPress Import screen"},{"src":"https:\/\/ps.w.org\/users-import-export-with-excel-for-wp\/assets\/screenshot-2.png?rev=2139342","caption":"Import Users &amp; Customer - Export Users with Excel for WordPress data mapping"},{"src":"https:\/\/ps.w.org\/users-import-export-with-excel-for-wp\/assets\/screenshot-3.png?rev=2139342","caption":"Import Users &amp; Customer - Export Users with Excel for WordPress Export screen"}],"raw_content":"<!--section=description-->\n<p>With this WordPress plugin you can Import Users &amp; Customers for WooCommerce  and Export Users with Excel instantly - xlsx file<\/p>\n\n<p>Export Customers: WooCommerce Customers Export <a href=\"https:\/\/extend-wp.com\/product\/users-customers-import-export-excel-wordpress-woocommerce\" title=\"Users-Customers Import Export with Excel for WordPress &amp; WooCommerce\">PRO Version<\/a><\/p>\n\n<p>Data mapping - Drag and drop Excel Columns to User Fields easily. No More Hassle with CSV's!<\/p>\n\n<p>Users Export for WorPress in Excel by the hit of a button<\/p>\n\n<p>Ajax driven plugin, very easy to use. All your data will be implemented on the spot, without any delay or inaccuracy.<\/p>\n\n<p>Automap excel columns to User fields for ease of use<\/p>\n\n<p><strong>The <a href=\"https:\/\/extend-wp.com\/product\/users-customers-import-export-excel-wordpress-woocommerce\" title=\"Users-Customers Import Export with Excel for WordPress &amp; WooCommerce\">PRO Version<\/a> of this wp plugin allows you to do Users &amp; Customer Import Export for WooCommerce with their additional fields plus custom fields defined.<\/strong><\/p>\n\n<h4>Benefits<\/h4>\n\n<ul>\n<li>If you are doing a website migration from another site to Wordpress or the opposite, you can use this easy via excel import and export functionality.<\/li>\n<\/ul>\n\n<h4>How to<\/h4>\n\n<ol>\n<li>Navigate to Users -&gt; Users Import\/Export link or press 'Settings' link of the plugin on Plugins WP page.<\/li>\n<li>Create an excel or use the sample from plugin setting's page with the data - 1st row  is the heading eg. Name, 2nd row will have the user name. Use 1 row for each user. Each Column represents a field to import along with your user.<\/li>\n<li>Upload the excel file on Users Import Export with Excel for WordPress settings page.<\/li>\n<li>Once you upload, map the data from the excel to the user fields of WordPress.<\/li>\n<\/ol>\n\n<h4>Supported User Fields<\/h4>\n\n<ul>\n<li>First Name<\/li>\n<li>Last Name<\/li>\n<li>Username - user_login<\/li>\n<li>Nickname<\/li>\n<li>Display Name<\/li>\n<li>Email<\/li>\n<li>Password<\/li>\n<li>User URL<\/li>\n<li>Description<\/li>\n<li>Roles - you can add multiple roles separated by comma<\/li>\n<\/ul>\n\n<p><strong>PRO VERSION<\/strong>\n[youtube https:\/\/www.youtube.com\/watch?v=Qz3ZtdeBfOE&amp;rel=0]\n* Easily migrate your WooCommerce Store by exporting Customers to Excel and Easily Importing to your new website.\n* Option to Send Email Notification on User Import\n* Customers Export: Export WooCommerce Customers in Excel - supports their specific fields eg, addresses + custom fields defined\n* Filter Users to Export by Creation Date\n* Choose what addition User fields to Export\n* Import  \/ Export Users with roles defined customly or from other plugins \n* Additional WooCommerce User Meta &amp; other custom fields defined Supported<\/p>\n\n<p><a href=\"https:\/\/extend-wp.com\/product\/users-customers-import-export-excel-wordpress-woocommerce\" title=\"Users-Customers Import Export with Excel for WordPress &amp; WooCommerce PRO\">Get it Here<\/a><\/p>\n\n<h4>Video Instructions<\/h4>\n\n<p>[youtube https:\/\/www.youtube.com\/watch?v=Tk36nxkc1ms&amp;rel=0]<\/p>\n\n<!--section=installation-->\n<ol>\n<li>Upload the plugin files to the <code>\/wp-content\/plugins<\/code> directory and unzip, or install the plugin through the WordPress plugins screen directly.<\/li>\n<li>Activate the plugin through the 'Plugins' screen in WordPress<\/li>\n<li>Use the Users Import\/Export submenu link under Users or Settings link on plugins page to use the plugin.<\/li>\n<li>Upload your excel file (there is a link for a sample excel file) and proceed to data mapping and creating your users.<\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt id='in%20which%20format%20do%20i%20import%20and%20export%20users%3F'><h3>In which format do I import and Export Users?<\/h3><\/dt>\n<dd><p>You can easily create a .xlsx file or use the example file on plugin settings page. Export is made in xlsx as well.<\/p><\/dd>\n<dt id='can%20i%20import%20woocommerce%20customers%20with%20excel%20for%20woocommerce%3F'><h3>Can I import WooCommerce Customers with Excel for WooCommerce?<\/h3><\/dt>\n<dd><p>Yes, just the naming customer in the role column of your excel file.<\/p><\/dd>\n<dt id='can%20i%20import%20or%20export%20woocommerce%20customers%20with%20excel%3F'><h3>Can I import or export WooCommerce Customers with Excel?<\/h3><\/dt>\n<dd><p>Yes, this feature is available in the <a href=\"https:\/\/extend-wp.com\/product\/users-customers-import-export-excel-wordpress-woocommerce\" title=\"Users-Customers Import Export with Excel for WordPress &amp; WooCommerce PRO\">PRO Version<\/a>.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>1.6<\/h4>\n\n<p>update phpspreadsheet<\/p>\n\n<h4>1.5<\/h4>\n\n<p>fix css<\/p>\n\n<h4>1.4<\/h4>\n\n<p>PHP spreadsheet library instead of phpexcel\nimport customers with excel<\/p>\n\n<h4>1.3<\/h4>\n\n<p>Compatibility with wp6.4 and hpos<\/p>\n\n<h4>1.2<\/h4>\n\n<p>Compatibility with wp6<\/p>\n\n<h4>1.1<\/h4>\n\n<p>Compatibility with wp5.5<\/p>\n\n<h4>1.0<\/h4>","raw_excerpt":"WordPress Plugin to import Users and export Users with Excel for WordPress and WooCommerce Customers Import Export","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/107563","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=107563"}],"author":[{"embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/wpcodefactory"}],"wp:attachment":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=107563"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=107563"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=107563"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=107563"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=107563"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=107563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}