How to Upload Spreadsheet Email List to Mailchimp

Format Guidelines for Your Import File

This page is now available in other languages.

When yous import contacts to Mailchimp, you lot'll lucifer each column in your import file to a field in your Mailchimp audition. Certain types of fields, like email address and altogether, require a specific format to import correctly.

In this commodity, you'll acquire how to format each cavalcade in your file to become the all-time results when yous import.

Before you start

• If you've already started an import, learn how to review and edit your audience fields or troubleshoot your import.
• The only field Mailchimp requires is E-mail Address. Other fields are optional, simply may exist necessary for personalization, partition, or other features.
• Clearly label each column in your import file then you tin can easily choose the field type during the import procedure. For example, if you have a column named "Contact Email Addresses," you'll know to choose the Email Accost field type.
• You tin can suit the columns in your file in any lodge.

Email address

You must include an e-mail address column in your import file, and simply ane email for each contact. Review this column for anything that might cause syntax errors, like missing information, unsupported characters, and extra spaces before or after an address. For instance, nosotros can only support international characters like ñ or é if they come up later the @ symbol.

Text

Text fields are limited to a maximum of 255 bytes of data, and will be clipped if the limit is exceeded. In many alphabets, this is equal to 255 characters. Some alphabets or symbolic characters, similar emoji, use more than ane byte of information per character, then it isn't e'er a one-to-ane ratio.

Use text fields for:

• commencement name and final name
• language preferences
• numbers without comma separators
• additional data you desire to add together, similar chore title or company name

Address

The address field is designed to comprise each contact'south complete mailing address, which can be used with postcards, partitioning, and other features. This field is automatically included when y'all create an audience, but is hidden from signup forms unless you choose to make it visible.

Here are some other things to know when you gear up your address field for import.

• Include each contact's consummate accost, including the nothing lawmaking and country. If the accost data in your file is stored in multiple columns, combine them during the import.
• Split each part of the accost with two spaces instead of commas.
• Each line of the address must exist fewer than 45 characters.
• Utilise the 2-letter of the alphabet country lawmaking instead of the country proper noun. Our system will attempt to recognize countries by name, but it increases the likelihood of error.

• A United kingdom of great britain and northern ireland address with UK as the country will not import correctly. You'll need to use GB instead.

  

Phone

The phone field is included when yous create a new audience, but is hidden from signup forms unless yous cull to make it visible. It uses international format past default. If you know you'll but have U.S. phone numbers, choose the (###) ###-#### format on the Audition field and merge tags page.

Zip code

Employ the zip code field in combination with text fields if you take U.S. address data stored in dissever columns and don't want to combine them. To store international postal codes, use an additional text field. Zip code fields are limited to v digits.

Note

Certain features, like postcards and address-based partition, won't piece of work with address data stored in divide audience fields. If the address data in your file is stored in multiple columns, we'll help you combine them when you import.

Number

Utilize a number field to import numbers or currency values to your audience. We'll add comma separators to large numbers like one,000 or 1,000,000.

Date

To import dates other than birthdays, utilise either the ISO Standard twelvemonth-month-date format (YYYY-MM-DD) or calendar month-day-twelvemonth format (MM-DD-YYYY).

Mailchimp will attempt to convert the date field to match your account'due south default engagement format. For best results, we recommend that you use the ISO Standard format, YYYY-MM-DD.

Birthday

If you shop your contacts' birthdays, you can use this information to send annual birthday automations that include special offers or friendly messages.

To practice this, you'll demand to import your contacts' nascency calendar month and solar day information into a birthday field instead of a regular date field. We'll have a field with ISO Standard twelvemonth-month-day format (YYYY-MM-DD) or a month-day format (MM/DD), but we only require and store the month and 24-hour interval.

Image

Epitome fields must incorporate the full source URL for a hosted image, which tin exist used to insert personalized images in campaigns.

Website

Website fields can exist used to store custom links for each contact and must include the total URL.

Marketing permissions

If you lot add contacts who have given GDPR-friendly consent for marketing permissions, you tin can import that data to Mailchimp. To friction match the column to a Mailchimp audition field, select Marketing Permissions for the cavalcade name. Imported permissions must match the marketing permission options you specified for this audience in your GDPR-friendly form.

Tags

Tags help yous organize and label your contacts. To import tags, create a unmarried column in your spreadsheet labeled Tags. For each contact, add together all of the tags that utilise to them, separated by commas.

Here are another things to know when you prepare your tags for import.

• If a tag doesn't already exist in your audience, we'll create it when yous import.
• Tag names can exist 100 characters or fewer. If a tag exceeds the character limit, nosotros'll truncate it.
• Emojis cannot exist imported. We recommend you supercede any emojis with text.
• If a tag contains a comma, y'all'll need to enclose the tag in double quotes to retain the comma. For example, the tag Monday, Wednesday should be formatted as "Monday, Wednesday".

Groups

If you plan to use groups, you tin add together subscribers to groups during the import process. If your audition doesn't already include the groups in your import file, you'll need to create them first.

In your file, label the group column to match your group category. For each contact, include their group names. To add together a contact to more one group name, carve up each name with a comma and a space.

For instance, if you have a Newsletter Preferences group category and the group names are Pupil Events, News, and Donations, format the Newsletter Preferences cell for someone in all 3 groups like this.

Download a sample import file

If you need help, try our sample import file as a starting point. The sample file contains columns for an import that includes email address, offset name, last name, address, birthday, a custom group, and tags.

Download the sample CSV file, and supersede the sample data with your subscriber data. Customize the fields to match the data y'all have for your audience. Follow the format guidelines for different types of information, to update your Mailchimp audition correctly.

Sample file

Click the link to download the sample CSV import file. For best results, open up the file in a spreadsheet program like Microsoft Excel or Google Sheets.

Sample CSV Import File

After you update the file with your subscriber information and save it, learn how to import information technology into Mailchimp.

Note

The information contained in the sample import file is not actual contact information and has been created for informational purposes merely. Supplant the sample data before yous import.

mottcappitst.blogspot.com

Source: https://mailchimp.com/help/format-guidelines-for-your-import-file/

Share this post