WooCommerce Orders – Export Phone Numbers of Customers to a CSV File

Want to plan a phone marketing campaign? Want to contact your users who have made orders in WooCommerce through WhatsApp? You need to have all the customers’ phone numbers on a CSV file.

However, it’s really difficult to search for all your customer numbers opening the orders one by one. You need to follow a repeated process like this:

  • Open an order
  • Go to the billing information
  • Copy the name and number
  • Paste it on Excel or Google Sheets
  • Close that order
  • Open another order
  • Go to the billing information
  • Copy the name and number
  • Paste it on Excel or Google Sheets
  • Close that order
  • And so on…

Therefore, you’ll have a somewhat tedious time trying to obtain all phone numbers on a CSV file.

Fortunately, we can show you how to export all user phone numbers in just some seconds. For this, you need to use the WooCommerce Orders Spreadsheet plugin.

It’s a great tool that allows you to do advanced searches and apply changes in bulk in just some minutes. Not only that… You can import or export info using CSV files.

You can download the plugin here:

Download WooCommerce Orders Spreadsheet Plugin - or - Read more

Once installed, open the spreadsheet by going to Sheet Editor > Edit Orders.

 

Now just follow these simple steps to export all your customers’ phone numbers.

1- Open the “Export” tool

With this tool, you can quickly export thousands of orders with their complete information. You don’t necessarily need to export all your order columns, you can select specific columns, as we’ll show you here.

So, open the Export tool on the top toolbar.

2- Export the phone numbers

Now you need to select these values in order to export the customers’ phone numbers to a CSV file that you can edit with Microsoft Excel or Google Sheets.

  • What columns do you want to edit: billing phone
  • Tick the I understand it will export all the posts from my current search
  • OPTIONAL: Tick the I will edit this file with Microsoft Excel
  • Click on Start new export to start the export process.

Done!

It was a piece of cake! You didn’t need to spend many hours trying to obtain your customers with orders’ phone numbers. Now you can use your customers’ phone numbers to have great marketing campaigns.

You can download the plugin here:

Download WooCommerce Orders 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