Importing International Phone Numbers

In this article, you will learn how to import tasks that contain international phone numbers. 

Onfleet recognizes all phone numbers that conform to the E.164 format within the International Public Telecommunication Numbering Plan. Essentially, this format specifies that all phone numbers can have a maximum of 15 digits including the corresponding country code.

International Country Calling Codes

Onfleet also recognizes International Country Calling Codes that can be found here.

Preparing The Import Sheet

The recipient phone numbers within your spreadsheet must properly display all the required fields. For example, this is a sample phone number format for a Slovakian phone number: +421915426219

If you are using Excel to create your import, you will need to make sure the cells containing the phone numbers display the + for the import to be successful. There are a few ways to ensure the correct cell format, which are outlined below.

The first way to achieve this (see GIF below) is to apply a custom cell format with these steps:

  1. Highlight the column and/or cells that contain the phone numbers
  2. Click Format → Cells → Custom
  3. Type: +0 → Click OK
  4. You should now see the + displayed in front of the international phone numbers

Similarly, the second way to achieve this is to simply display text within the cells instead of digits

  1. Highlight the column and/or cells that contain the phone numbers
  2. Click Format → Cells → Text
  3. Click OK
  4. You should now see the + displayed in front of the international phone numbers

Changing the cell format can also be easily achieved in Google Sheets by performing similar steps:

  1. Highlight the column and/or cells that contain the phone numbers
  2. Click Format → Number → More Formats → Custom Number Format
  3. Type +0 and Click Apply

 Return to Top