What File Do You Put Emails Into to Upload Into Mailchimp

Format and Import Mailing Addresses

This page is now available in other languages.

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

In this article, you'll acquire how to import mailing addresses to Mailchimp.

Before you beginning

• Make sure you're familiar with the overall import process.
• Subscribed contacts who are imported to an audience don't go through the signup process, so you'll demand to verify that you have permission to email them.
• Each audience includes an Address field by default, just it'due south hidden from signup forms unless you choose to make it visible.

Review your import file

Your Mailchimp audience includes an Address field that's designed to shop each contact'due south complete mailing address. We automatically format addresses that you collect with your signup form or connected store, merely imported contacts and their data will need some extra attention.

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

• Columns Are mailing addresses stored in a unmarried column or multiple columns? The import procedure differs for each.
• Address length Each line of an address must exist fewer than 45 characters.
• Country codes Use the two-letter land code instead of the land name. Our system will attempt to recognize countries past name, merely it increases the likelihood of error. For case, "United States" won't piece of work with some features, just "United states of america" will.
• United Kingdom addresses A United Kingdom accost with Great britain as the country will non import correctly. You lot'll need to use GB instead.

Format and import a unmarried accost column

To format and import a unmarried mailing address column, follow these steps.

1. Review your import file to confirm that each contact's consummate accost is stored in a single column. This must include the street, city, country or province, zip or postal code, and land.
   
2. Brand sure each role of the address is separated by two spaces and remove whatever commas.
3. Log in to Mailchimp and begin your import.
4. On the Lucifer step of the import process, match the single address cavalcade to the Accost - Combined field and click Confirm.
   
5. Go along to friction match the other columns in your file as needed and complete your import.

After you import, you'll see address information in the contact tabular array every bit well every bit the individual contact profile.

Format and import multiple address columns

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

In the import process, you ordinarily match each column in your file to a corresponding audience field in Mailchimp. When yous take multiple accost-related columns, yet, you'll match each one to a different office of the aforementioned address field. These options are labeled with Address plus the specific component, like this.

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

To format and import multiple address columns, follow these steps.

1. Review your spreadsheet to make sure street information, urban center, state or province, ZIP or postal, and country information is stored in unlike columns.
   
2. Log in to Mailchimp and begin your import.
3. On the Lucifer pace of the import process, match the first address cavalcade to the corresponding part of the address field. For instance, let's say the kickoff address column in your file is labeled Street Address. To friction match it to the correct part of the address field, you'll choose Address - Street Address from the Column name drop-downward and click Confirm.
   
4. Repeat step three for each address cavalcade.
5. Continue to friction match other columns in your file as needed and complete your import.

Subsequently you match and import all of the accost columns in your file, your contacts' full addresses volition exist stored in the Accost field of your Mailchimp audience. You lot tin can meet this information in the contact table every bit well equally the individual contact profile.

Adjacent steps

Now that you've imported mailing addresses, you lot can ship printed postcards to your Mailchimp contacts. Hither are a few resource to help you get started.

Nigh Postcards
Create a One-Fourth dimension Send Postcard
Create an Abandoned Cart Postcard

baezwaythe.blogspot.com

Source: https://mailchimp.com/help/import-mailing-addresses-postcards/

Share this post