Phone Number Format

Do phone numbers need to be entered in my Google Sheet in a specific format?

This article describes how to format the phone numbers entered in your Google Sheet.

Phone numbers can be entered in Google Sheets in a variety of different formats. Common charaters found in phone numbers are automatically removed by WhatsApp Sender prior to sending messages. Such characters include dashes, brackets and spaces.

The following example phone number formats below are accepted for US phone numbers:

  • +15162652941

  • +1-718-799-3725

  • (876) 3733376

  • 6314242678

  • 16314245599

It is generally good practice to include the country code (starting with a + sign) when entering phone numbers in your Google Sheet in order to avoid ambiguity. This is especially the case if you have recepients from different countries.

When a phone number is entered in Google Sheets without a country code, the default country code will be used.

The default country code can be set by clicking Extensions > WhatsApp Sender > Default Country Code.

In the Default Country Code dialog box, select the desired country from the Country Code drop-down and then click Save.