can I bulk upload contacts to mailchimp into a segment

View or Consign Your Contacts

This page is now available in other languages.

After y'all've collected your desired contacts in Mailchimp, you lot may want to export those contacts into a CSV file. You tin can export an entire audience, a segment, or a group. Exports can include subscribed, non-subscribed, unsubscribed, and cleaned contacts.

In this article, you'll larn how to view and consign your contacts, and access the export history for each audience.

Before you start

Here are some things to know before y'all begin this process.

The General Data Protection Regulation (GDPR) is a European Spousal relationship (Eu) privacy law that gives Eu citizens the right to ask nearly how their personal information is stored and used. If a contact requests their personal information from you, you'll need to export straight from their contact profile instead of using the processes described in this article.
Contact exports don't include campaign report information, like open and click rates. To download campaign report data, consign a campaign report.
Your export may include a Nil file that contains separate CSV files for each blazon of contact (subscribed, unsubscribed, non-subscribed, and cleaned). Unarchive the ZIP file to admission the CSV files and open up them in your preferred spreadsheet application.
Contact Exports and their CSVs are bachelor in your account for 30 days.

Configure contact table

The contact table provides basic data about the contacts in your audience. Reorder columns or turn them on or off to configure your preferred view. When you hide a column, it doesn't delete the respective audition field or hide the field on your signup form.

To configure the columns on the contact table, follow these steps.

Click Audience.
Click All contacts.
If you have more than one audience, click the Electric current audience drop-downwardly and choose the one you want to piece of work with.
Click the Toggle Columns drop-downwardly menu.
Uncheck the boxes next to the fields you want to hide or check the boxes next to the fields you want to view.
To reorder columns, click and drag the three dots next to any proper name field and elevate it to your preferred location.
Click Salve.

View or consign an audience

To view or export your entire audience, follow these steps.

Click Audience.
Click All contacts.
If you accept more than than one audition, click the Current audition drop-down and choose the ane y'all want to work with.
Click Export Audience.
After the export loads, click Export as CSV to download the file to your computer.

View or consign a segment

To view or consign a saved segment, follow these steps.

Click Audition.
Click All contacts.
If you accept more than one audience, click the Current audition drop-down and choose the ane you desire to work with.
Click View Segment, and choose the segment you want to export.
Click Export Segment.
After the export loads, click Export as CSV to download the file to your computer.

View or export tagged contacts

To view or export tagged contacts, follow these steps.

Click Audience.
Click All contacts.
If you have more than i audience, click the Electric current audience drop-down and choose the i you want to work with.
Click the Filter by Tags drib-down menu and choose the tag you want to work with.

Nosotros'll generate a segment of all the contacts in your audience with that tag practical to them.
From the segment view, click the Filtered Past Tags drop-down bill of fare to choose more tags. When y'all're done, click Export Segment.

Later the export loads, click Export as CSV to download the file to your computer.

View or export a grouping

Y'all also have the pick to view a group, or export it. To view or export a group of subscribers, follow these steps.

Click Audience.
Click Audience dashboard.
If you have more than one audience, click the Electric current audience drop-down and choose the one you lot desire to piece of work with.
Click the Manage Audience drop-down and choose Manage contacts.
Click Groups.
Click View Groups to expand the group you want to view.
Click the # contacts link to view the private contacts in each group.
Click Consign Segment.
After the export loads, click Consign as CSV to download the file to your estimator.

Open your consign file

Your export may include a ZIP file that contains separate CSV files for each blazon of contact (subscribed, unsubscribed, non-subscribed, and cleaned). Unarchive the ZIP file to access the CSV files and open each file individually in your preferred spreadsheet application. An consign containing a single contact type—for example an export of archived contacts—will contain but i CSV file.

How y'all open up a CSV file depends on the spreadsheet program you use. You lot can open the file with whatsoever spreadsheet plan, but we detect virtually people utilise Microsoft Excel, Google Sheets, or OpenOffice Calc.

Here are some links to show you how to open files in these programs.

Open a CSV file with Excel
Open a CSV file with Google Sheets
Open up a CSV file with OpenOffice Calc

About your consign file

Export files contain your audience fields along with contact data that Mailchimp collects. If y'all have GDPR-friendly forms enabled for your audience, the CSV file header volition match the GDPR form field label in your segments.

What'due south included

Audience fields (excluding the linguistic communication field)
Tags
Marketing permissions
If your audience is GDPR-enabled, this column will evidence each marketing permission a contact has opted into in the signup form.
MEMBER_RATING
The contact'due south member action rating.
OPTIN_TIME
The fourth dimension a contact accessed your signup form, if they used it to sign upwards. This volition not evidence for contacts who haven't completed the double opt-in process.
OPTIN_IP
The IP address used when the contact accessed the hosted signup form. This will not show for contacts who haven't completed the double opt-in procedure.
CONFIRM_TIME
The engagement and time the contact clicked the link in the opt-in confirmation e-mail.
CONFIRM_IP
The IP address used when the contact joined your audience.
LATITUDE
Latitude for the IP address of the CONFIRM_IP.
LONGITUDE
Longitude for the IP accost of the CONFIRM_IP.
GMTOFF and DSTOFF
Our system is based on UTC time. GMTOFF indicates the aligning made to the time based on geolocation information, and DSTOFF takes daylight saving time into account. These are used in conjunction to determine TIMEZONE.
TIMEZONE, CC and REGION
Based on the contact's geolocation information. This will only bear witness information when geolocation data has been captured.
LAST_CHANGED
The date and time when information in the contact'south profile was last changed or updated.
LEID and EUID
LEID is the unique identifier for a contact, specific to an audition. EUID is the unique identifier for a contact on the account level, across all audiences.
NOTES
Notes added within the contact profile page.

What's not included

Here are some examples of data that is non included in your audience export. For GDPR compliance purposes, some of this data tin can be exported from an individual contact'due south contour.

Signup source
Campaign date metrics, like opens and clicks
Purchase history
Linguistic communication
Predicted demographics
Favorite email customer
Social profile data
A consummate record of contact profile updates

View export history

To view or download an export from the past xxx days, follow these steps.

Click Audience.
Click All contacts.
If you take more than than one audience, click the Electric current audience driblet-down and choose the one you lot want to work with.
Click the Manage contacts drop-down and choose Contact exports.

Each entry on the Exports page shows the date contacts were exported, who made the export, and how many contacts were exported on that date. Click Export equally CSV to download a copy of any previous consign.

Troubleshoot a contact consign

My export includes foreign or unexpected characters.

If your data contains special characters, your export may not display correctly in Excel. To meet special characters in Excel, use one of these workarounds.

Change the file extension from .csv to .txt, then open up the file in Excel. When Excel prompts for the file type and character encoding, fix encoding to UTF-8.
Open the CSV file in a text editor, and make sure the text editor'southward settings are prepare to UTF-8 encoding. Re-create all the content from the text editor and paste it into a blank Excel sheet. Then apply the Text-To-Columns office in Excel to split everything into columns.

My address field just says "US."

When physical addresses are imported incorrectly, our import tool inserts "Usa" every bit the default value. You'll demand to reformat and re-import your original file in society for Mailchimp to read, store, and consign the accost data correctly. To learn more nearly how to properly format physical address data in Mailchimp, bank check out our format guidelines. After your file is corrected, perform an auto-update import to fix the address fields.

I'thousand looking for the marketing status of my contacts.

Most contact exports contain separate files for each contact blazon (or marketing status). The contact type appears in the file name of the exported file.

I'one thousand looking for my archived contacts.

Archived contacts are exported separately from your active contacts. To learn more most viewing and exporting archived contacts, check out Annal or Unarchive Your Contacts.

edwardssuliterty1953.blogspot.com

Source: https://mailchimp.com/help/view-export-contacts/