Magento 2 has a built-in function that allows store-owner to export and import customers’ data. This is very helpful if you want to transfer your customers’ data to another store, or store your customers data for other purposes.
Previously, I published a tutorial on how to csv import product in Magento 2. In this tutorial, we will learn how to import and export customers data with csv file in Magento 2
Export customers data in Magento 2
In this part, I will explain how to export customer data to a CSV file.
Step 1: In Magento 2 admin dashboard, go to System > Data Transfer > Export
Entity tyle select
Customer main file
Step 2: Include or exclude customers attribute from the exported csv file
In the Entity Attributes tables, you can choose to include or exclude a specific attribute from the exported csv file.
For example, if I want to export only female customer, in Gender attribute, I will select
Female, note that the exlucded value will still appear in export file but with no value.
If you want to enclose any special characters that might be found in the data as an escape sequence, select the Fields Enclosure checkbox.
Step 3: Start to export file
When you finish choosing attributes, click on continue button at the bottom of the page to start importing customer CSV file
Once finishing, if you are using Magento 2.3, you will receive a CSV file contain all the customer information you select in Step 2, open the file and you will see information as below
If you are using Magento 2.4, you will see the message