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
- Make sure you’re familiar with how to import contacts to Mailchimp.
- Subscribed contacts who are imported to a list don't go through the signup process, so you'll need to verify that you have permission to email them.
- This address field is automatically included when you create a list, but is hidden from signup forms unless you choose to make it visible.
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.
During the import process, you’ll match the single address column to the Address - Combined field.
After you import, you see this information in the list view as well as the individual contact profile.
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.
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.
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.
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.