How Do You Mass Upload Emails Into Mailchimp

Format Guidelines for Your Import File

This page is now available in other languages.

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

In this article, you lot'll learn how to format each cavalcade in your file to get the best results when you import.

Before you starting time

• If yous've already started an import, learn how to review and edit your audience fields or troubleshoot your import.
• The just field Mailchimp requires is Email Address. Other fields are optional, but may be necessary for personalization, segmentation, or other features.
• Clearly label each column in your import file so you can easily choose the field type during the import procedure. For case, if y'all have a column named "Contact Email Addresses," yous'll know to choose the Email Address field type.
• You tin can adapt the columns in your file in whatsoever society.

Email address

You must include an electronic mail address column in your import file, and only one electronic mail for each contact. Review this column for anything that might cause syntax errors, like missing information, unsupported characters, and extra spaces earlier or after an address. For example, we can simply support international characters similar ñ or é if they come up after the @ symbol.

Text

Text fields are express to a maximum of 255 bytes of information, and will be clipped if the limit is exceeded. In many alphabets, this is equal to 255 characters. Some alphabets or symbolic characters, like emoji, utilise more than one byte of information per grapheme, then it isn't always a one-to-i ratio.

Use text fields for:

• first name and last proper noun
• linguistic communication preferences
• numbers without comma separators
• additional data y'all want to add, like chore title or company name

Address

The address field is designed to contain each contact'south complete mailing address, which can exist used with postcards, sectionalization, and other features. This field is automatically included when you create an audience, just is hidden from signup forms unless you choose to make it visible.

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

• Include each contact'southward consummate address, including the nix code and country. If the address information in your file is stored in multiple columns, combine them during the import.
• Separate each part of the address with two spaces instead of commas.
• Each line of the address must be fewer than 45 characters.
• Employ the 2-letter land code instead of the country name. Our organisation will try to recognize countries past name, but it increases the likelihood of fault.

• A Uk accost with Great britain as the country will not import correctly. You'll need to utilise GB instead.

  

Telephone

The phone field is included when you create a new audition, but is subconscious from signup forms unless you cull to go far visible. It uses international format past default. If you know yous'll but accept U.South. telephone numbers, cull the (###) ###-#### format on the Audience field and merge tags page.

Zero lawmaking

Use the goose egg code field in combination with text fields if you take U.S. address data stored in divide columns and don't desire to combine them. To store international postal codes, use an boosted text field. Zip code fields are limited to five digits.

Annotation

Sure features, like postcards and address-based segmentation, won't work with address data stored in separate audience fields. If the address information in your file is stored in multiple columns, we'll assistance you combine them when you lot import.

Number

Use a number field to import numbers or currency values to your audition. We'll add together comma separators to large numbers similar 1,000 or 1,000,000.

Engagement

To import dates other than birthdays, employ either the ISO Standard yr-month-appointment format (YYYY-MM-DD) or month-24-hour interval-yr format (MM-DD-YYYY).

Mailchimp volition attempt to convert the date field to match your account's default date format. For best results, nosotros recommend that you use the ISO Standard format, YYYY-MM-DD.

Birthday

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

To exercise this, you'll need to import your contacts' nativity month and 24-hour interval information into a birthday field instead of a regular date field. We'll accept a field with ISO Standard year-month-day format (YYYY-MM-DD) or a month-solar day format (MM/DD), only we merely require and shop the month and mean solar day.

Epitome

Image fields must contain the full source URL for a hosted paradigm, which can be used to insert personalized images in campaigns.

Website

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

Marketing permissions

If yous add together contacts who take given GDPR-friendly consent for marketing permissions, y'all can import that information to Mailchimp. To match the column to a Mailchimp audience field, select Marketing Permissions for the column name. Imported permissions must lucifer the marketing permission options you lot specified for this audience in your GDPR-friendly grade.

Tags

Tags assistance you lot organize and label your contacts. To import tags, create a unmarried column in your spreadsheet labeled Tags. For each contact, add all of the tags that utilize to them, separated by commas.

Here are some other things to know when y'all prepare your tags for import.

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

Groups

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

In your file, label the grouping column to lucifer your group category. For each contact, include their group names. To add a contact to more one group proper name, separate each name with a comma and a space.

For example, if you have a Newsletter Preferences grouping category and the group names are Student Events, News, and Donations, format the Newsletter Preferences cell for someone in all three groups like this.

Download a sample import file

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

Download the sample CSV file, and supplant the sample information with your subscriber data. Customize the fields to lucifer the data you take for your audience. Follow the format guidelines for different types of information, to update your Mailchimp audience 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

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

Note

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

brownjoiny1992.blogspot.com

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

Bagikan Artikel ini