WooCommerce – Export Emails of Customers From a Specific City, State, or Country

You’re preparing a new email campaign and want to know your customers’ emails in order to contact them. Maybe you have a great copywriter who’ll send thousands of emails to your customers inviting them to shop with you.

Besides, you want to know in which specific country, state or city they live in order to personalize the messages you’ll send them. For this you need to export their emails, and that seems it will require some time if you’re using WooCommerce without any help.

But please, don’t worry!

We want to show you a great tool you can use to export your customers’ emails by filtering them by country, state or city. We’re talking about the WP Sheet Editor Users Spreadsheet plugin.

It’s really simple. Just follow these steps:

Install WP Sheet Editor

With this plugin you can edit your users’ information in a spreadsheet. You can also export their info and apply changes to thousands of them.

You can skip this step if you have the plugin installed and activated.

You can download the plugin here:

Download WordPress Users Spreadsheet Plugin - or - Read more

Open the users’ spreadsheet

To open the users’ spreadsheet, you need to go to WP Sheet Editor > Edit users

Filter users by country

One of the ways in which you can filter your customers in order to export their emails is by country. For this, you need to use the WP Sheet Editor’s “Search” tool, so open it on the toolbar.

Once you open the “Search” tool, you need to set these values to look for your customers by country.

  • Select “Customer” in “Role”.
  • Check the “Enable advanced filters” checkbox.
  • Select “billing_country” in “Field key”.
  • Choose “=” in “Operator”.
  • Write the country in the “Value” field (United States, for example)
  • Hit the “Run search” button.

Copy from the Spreadsheet

Once you’ve found your products, you just need to copy the content of the “Email” column and paste it in a google doc or wherever you need to.

Use the Export tool

If you don’t want to export users’ emails copying from the spreadsheet, you can use the plugin’s Export tool. Just click it above the toolbar.

Then you need to select the Email column to export and hit the Start new export button. Done!

You can easily find and export your customers’ emails with WP Sheet Editor. For this you need to use the “Search” tool; open it on the toolbar.

After you’ve opened the tool, you need to set these values:

  • Select “Customer” in “Role”.
  • Check the “Enable advanced filters” checkbox.
  • Select “billing_state” in “Field key”.
  • Choose “=” in “Operator”.
  • Write the state in the “Value” field (New York, for example)
  • Hit the “Run search” button.

Copy from the spreadsheet

After that, just copy the content of the “Email” column and paste it in a google doc or wherever you need to.

Use the Export tool

If you don’t want to export users’ emails copying from the spreadsheet, you can use the plugin’s Export tool. Just click it above the toolbar.

Then you need to select the Email column to export and hit the Start new export button. Done!

To look for your customers by city and then export their emails, you need to take some simple steps. Start by opening the “Search” tool on the toolbar.

Then, enter the terms of the search:

  • Select “Customer” in “Role”.
  • Check the “Enable advanced filters” checkbox.
  • Select “billing_city” in “Field key”.
  • Choose “=” in “Operator”.
  • Write the city in the “Value” field (New York, for example)
  • Hit the “Run search” button.

Copy from the spreadsheet

Then you need to copy the content of the “Email” column and paste it in a google doc or wherever you need to.

Use the Export tool

If you don’t want to export users’ emails copying from the spreadsheet, you can use the plugin’s Export tool. Just click it above the toolbar.

Then you need to select the Email column to export and hit the Start new export button. Done!

Really simple!

Did you ever imagine it was going to be that easy? Start using the WP Sheet Editor Users Spreadsheet plugin to export your customers’ emails and don’t lose time anymore.

You can download the plugin here:

Download WordPress Users Spreadsheet Plugin - or - Read more

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close Menu