Importing addresses into SendPro Online or PitneyShip

You can import addresses from other sources into your SendPro Online or PitneyShip address book.

Addresses added in SendPro Online or PitneyShip are also visible on other SendPro products.

The SendPro Online or PitneyShip address book can hold an unlimited number of addresses. However, on SendPro C Lite, SendPro C, SendPro+, SendPro C Auto, and Connect+ series and SendPro P meters, only 1000 addresses are visible.

Select your software version

There are currently two versions of our shipping software. Click on the image that matches your Home screen to view the instructions for your version.

SendPro Online (classic)

1. If you are importing addresses from another program, export/save those addresses as a CSV file. Make sure that your file meets the guidelines below.
2. From the menu at the top, select Address Book.
3. Select the + (plus) icon.
   
4. Select Import multiple addresses.
   
5. (Optional) To use a template to create your import file, select Download a .csv template. The file template.en-us.csv will be downloaded. You can insert your addresses into this template, or copy the headers (first row) from this template into your own address file. However, this is not necessary because you will be prompted to map your address data later. Make sure that your file meets the guidelines below.
6. Once you have created your CSV file of addresses to import, select Browse and choose your file.
7. If you wish to remove all existing addresses in your address book and replace them with the addresses in the import file, select Replace my current Address Book data with my imported data. If this is not checked, the addresses in the import file will be added to the addresses already in your address book.
   Note: If you use a shared address book, the replace option is not available.
8. If you are importing a file that was exported from your UPS or FedEx account, select Addresses are from my UPS/FedEx address book.
9. Select Continue. If you are importing a UPS or FedEx file, you are finished. If importing any other file, proceed with steps 10-11.
10. The mapping screen appears. Match your CSV file fields on the left with the SendPro address book fields on the right. Review the list and make sure that all of the fields are mapped correctly. For any that say Ignore Field, choose the correct field. If you choose Ignore Field, that field will not be imported.
    
11. Select Continue.

PitneyShip (new)

1. If you are importing addresses from another program, export/save those addresses as a CSV file. Make sure that your file meets the guidelines below.
2. From the menu at the top, select Address Book.
3. Select Import.
   
4. (Optional) To use a template to create your import file, select Download .csv template. The file sample-address-import.csv will be downloaded. You can insert your addresses into this template, or copy the headers (first row) from this template into your own address file. However, this is not necessary because you will be prompted to map your address data later. Make sure that your file meets the guidelines below.
   
5. Select the type of file you are importing:
   • To import a file that you exported from UPS, select Import UPS Contacts.
   • To import a file that you exported from FedEx, select Import FedEx Contacts.
   • For all other files, select Import Multiple Contacts.
6. Select Choose File and choose your import file.
7. If you wish to remove all existing addresses in your address book and replace them with the addresses in the import file, select Replace my unshared addresses with imported addresses. If this is not checked, the addresses in the import file will be added to the addresses already in your address book.
8. Select Continue.
9. The mapping screen appears. Match your CSV file fields on the left with the PitneyShip address book fields on the right. Review the list and make sure that all of the fields are mapped correctly. For any that say Ignore Field, choose the correct field. If you choose Ignore Field, that field will not be imported.
   
10. Select Import.

Address import guidelines

• The order of the columns in the import file does not matter.
• SendPro Online or PitneyShip require the first and last names to be in a single field called Name. If the first and last names are in separate columns in your data file, you can use Excel's concatenate function to put them into a single column. You may also include title, middle name, or middle initial in the Name field if you choose.
• You can use only fields that correspond to those available in SendPro Online or PitneyShip. The number of imported fields cannot exceed the maximum number of fields available in SendPro Online or PitneyShip. For example, CSV files exported from Google accounts usually contain many more fields than those available in the SendPro Online or PitneyShip address book.
• Do not include \ or / (slash) characters in the CSV file.
• Because addresses must pass USPS validation when used in SendPro Online or PitneyShip, the following fields are required. You can import addresses that do not contain these fields, but in order to use the address, these fields must be filled in.
  • Full Name and/or Company Name
  • Street Address 1
  • City
  • State/Province¹
  • ZIP Code
  • Country²
  ¹The State/Province field only accepts two-letter abbreviations for US states.
  ²In the classic version of SendPro, the Country field only accepts either two-letter country codes or the country spelled out in full. For example, it will accept "US" or "United States", but not "USA". For a complete list of country codes, see https://www.pitneybowes.com/us/support/postage/usps-international-country-codes.html. This does not apply to PitneyShip.