Import Mailing Addresses for Postcards

When you import contacts into Mailchimp, you can include their mailing addresses to use with postcards, segmentation, and other features. How you’ll set up your import depends on whether your import file contains address data in a single column or across multiple columns.

In this article, you’ll learn how to import mailing addresses to Mailchimp.

Before You Start

Review Your Import File

First, you’ll need to review your import file to make sure addresses are formatted correctly. Mailchimp’s Address field is designed to store each contact’s complete mailing address. We automatically format addresses that you collect with your signup form or connected store, but imported contacts and their data will need some extra attention.

Here are some things to consider when you review your import file.

  • Are mailing addresses stored in a single column or multiple columns? The import process differs for each.
  • Each line of the address must be fewer than 45 characters.
  • Use the two-letter country code instead of the country name. Our system will attempt to recognize countries by name, but it increases the likelihood of error. For example, "United States" won't work with some features, but "US" will.
  • A United Kingdom address with UK as the country will not import correctly. You’ll need to use GB instead.

Import a Single Address Column

If your import file stores each contact’s complete address in a single column, you’ll need to follow a few extra formatting guidelines.

  • Confirm that the address column includes every part of the address, including the street, city, state or province, zip or postal code, and country.
  • Separate each part of the address with two spaces and remove any commas.

Here’s how addresses should look before you import.

import-address-singlecolumn-example

During the import process, you’ll match the single address column to the Address - Combined field.

import-address-combined

After you import, you see this information in the list view as well as the individual contact profile.

contacttable-addressfield-example

Import Multiple Address Columns

If your import file has separate columns for address details like street address, city, state, country, and zip code, we’ll help you combine them when you import.

Here’s how the address data in your spreadsheet might look before you import.

import-file-addresses-multiplecolumns

In the import process, you’ll match the columns in your file to corresponding list fields in Mailchimp. In most cases, you’ll match one column to one list field. When you have multiple address-related columns, however, you’ll match each individual address column to a different part of the same address field. These options are labeled with Address plus the specific component, like this.

  • Address - Street Address
  • Address - Address Line 2
  • Address - City
  • Address - State/Prov/Region
  • Address - Country
  • Address - Zip/Postal

For example, let’s say the first address column in your file is labeled Street Address. To match it to the correct part of the address field, you’ll choose Address - Street Address from the Column name drop-down and click Save.

import-address-streetaddress

After you match and import all of the address columns in your file, your contacts’ full addresses will be stored in the Address field of your Mailchimp list. You can see this information in the list view as well as the individual contact profile.

contacttable-addressfield-example

Next Steps

Now that you’ve imported mailing addresses, you can send your contacts printed postcards from your Mailchimp account. Here are a few resources to get you started.

About Postcards

Create a One-Time Send Postcard

Create an Abandoned Cart Postcard


Was this article helpful?

Anything else we can do to improve our site?