To learn how to format phone numbers, birthdays, mailing addresses, and other types of data, check out Format Guidelines for Your Import File. Next to your Email Address column, create and label additional columns for First Name, Last Name, and any other information you want to import to Mailchimp.

Create and label a column for Email Address.

In a spreadsheet program like Microsoft Excel or Google Sheets, open your blank worksheet.

To prepare your file for import, follow these steps. Next, you'll use our import tool to upload your file and add your contacts to your Mailchimp audience. The file import process has two parts: First, you'll prepare your spreadsheet of contacts outside of Mailchimp and save it as a CSV file. That’s it! You’ve now connected your app and Mailchimp will import contacts.

Click Done after you’ve connected the app.

Previously connected integrations will have a checkmark instead of the add button.

Click ADD on one of the available integration tiles to begin connecting your app.

Click the Manage Audience drop-down and choose Import contacts.

If you have more than one audience, click the Current audience drop-down and choose the one you want to work with.

To connect another app and import contacts to Mailchimp, follow these steps. Here’s the list of currently supported apps:

To save time and effort, Mailchimp lets you connect six of the most commonly used integrations and will import contacts for you. If your import brings your total contact count above the limit of your Marketing plan tier, you'll be subject to an additional contact charge.If you’d like to send postcards to your contacts, check out our article on how to import mailing addresses.You can only import to one status at a time. In Mailchimp, you can categorize your contacts based on their email marketing status, such as subscribed or unsubscribed.Make sure you're familiar with our format guidelines before importing your file.

Certain fields, like birthday and date, must be formatted in a specific way.To get started with a file import, you'll need a blank sheet in a spreadsheet program like Microsoft Excel or Google Sheets, saved or exported as a comma separated value (CSV) file.

To change your plan type, visit the plans page in your account. To learn more, check out our pricing page. Free plans include up to 500 contacts and 1,000 sends per month, with a daily send limit of 500.Here are some things to know before you begin this process. In this article, you'll learn how to use our import tool to add and update contacts in Mailchimp. You can also auto-update multiple existing contacts at once. Import from a connected app, upload a comma-separated value file (CSV), copy and paste contacts from a spreadsheet like Microsoft Excel or Google Sheets, or type info directly into the import table. Our import tool helps you add or update contacts in Mailchimp.

Mac word import text to avery template