What Video Format Can I Upload to Mailchimp?

Format Guidelines for Your Import File

This page is at present available in other languages.

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

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

Before y'all offset

• If you lot've already started an import, larn how to review and edit your audience fields or troubleshoot your import.
• The simply field Mailchimp requires is Email Address. Other fields are optional, but may be necessary for personalization, partition, or other features.
• Clearly label each column in your import file so yous tin easily choose the field type during the import process. For case, if you have a column named "Contact E-mail Addresses," you lot'll know to choose the Email Address field type.
• You tin accommodate the columns in your file in any society.

Electronic mail accost

You must include an email address column in your import file, and only one email for each contact. Review this column for anything that might crusade syntax errors, like missing data, unsupported characters, and extra spaces before or subsequently an accost. For example, nosotros tin can but back up international characters similar ñ or é if they come after the @ symbol.

Text

Text fields are express to a maximum of 255 bytes of information, and volition 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 grapheme, so information technology isn't e'er a one-to-1 ratio.

Use text fields for:

• first name and last proper name
• language preferences
• numbers without comma separators
• additional information yous want to add together, similar job title or company name

Address

The address field is designed to incorporate each contact'due south complete mailing address, which tin be used with postcards, segmentation, and other features. This field is automatically included when you create an audience, simply is hidden from signup forms unless you choose to make information technology visible.

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

• Include each contact's complete address, including the cypher 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 exist fewer than 45 characters.
• Use the two-letter land code instead of the country proper noun. Our organisation will attempt to recognize countries past proper name, but it increases the likelihood of fault.

• A United Kingdom address with United kingdom as the land will not import correctly. You lot'll demand to employ GB instead.

  

Phone

The telephone field is included when you create a new audience, simply is hidden from signup forms unless you choose to brand it visible. It uses international format past default. If you know y'all'll only accept U.Due south. phone numbers, cull the (###) ###-#### format on the Audience field and merge tags page.

Zip code

Use the zip lawmaking field in combination with text fields if yous have U.S. address information stored in carve up columns and don't want to combine them. To store international postal codes, use an additional text field. Goose egg code fields are limited to v digits.

Note

Certain features, similar postcards and address-based segmentation, won't piece of work with address data stored in carve up audition fields. If the address information 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 together comma separators to big numbers like ane,000 or 1,000,000.

Date

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

Mailchimp will try to convert the engagement field to friction match your account's default appointment format. For all-time results, we recommend that y'all apply the ISO Standard format, YYYY-MM-DD.

Birthday

If you store your contacts' birthdays, you tin can use this information to ship annual altogether automations that include special offers or friendly messages.

To practise this, y'all'll need to import your contacts' nascence calendar month and day data into a altogether field instead of a regular date field. We'll accept a field with ISO Standard year-month-day format (YYYY-MM-DD) or a calendar month-twenty-four hours format (MM/DD), but nosotros merely require and store the calendar month and twenty-four hours.

Prototype

Prototype fields must contain the full source URL for a hosted image, which tin be used to insert personalized images in campaigns.

Website

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

Marketing permissions

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

Tags

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

Here are some other things to know when yous set up your tags for import.

• If a tag doesn't already exist in your audience, we'll create it when you import.
• Tag names tin be 100 characters or fewer. If a tag exceeds the grapheme limit, we'll truncate it.
• Emojis cannot exist imported. Nosotros recommend you replace any emojis with text.
• If a tag contains a comma, you'll need to enclose the tag in double quotes to retain the comma. For example, the tag Monday, Wed 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 audience doesn't already include the groups in your import file, you'll need to create them first.

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

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

Download a sample import file

If y'all need help, try our sample import file as a starting point. The sample file contains columns for an import that includes email accost, first name, final name, address, birthday, a custom group, and tags.

Download the sample CSV file, and replace the sample data with your subscriber information. Customize the fields to lucifer the data you 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 the file in a spreadsheet programme like Microsoft Excel or Google Sheets.

Sample CSV Import File

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

Note

The data independent in the sample import file is not actual contact data and has been created for informational purposes only. Replace the sample information earlier you import.

popeformoush.blogspot.com

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

Share this post