Bento

Export Data from Mailchimp for Bento

This guide will help you export all the lists, tags, segments, and custom fields you need from Mailchimp so you can import them into Bento.

Prerequisites

Prerequisites

Access to your Mailchimp account

Required permissions to export data

A place to save your exported CSV files

Spreadsheet software to review and clean up CSVs

What You'll Export

  • Subscribers (Lists/People)
  • Tags
  • Segments (Saved Searches/Lists)
  • Custom Fields
  • Automations (for mapping later)

Step-by-Step Export Process

1
Log in to Mailchimp

Go to Mailchimp and log in with your credentials. Once you are logged in, navigate to the Audience section.

Login and navigate to Audience
2
Export Audience (All Statuses)

From your audience screen, click Subscription Status select box and check each of the status options.
Click Export Segment.
Mailchimp will generate a ZIP that contains a CSV for each of those statuses that has a contact assigned to it and email you a link to download it.
The downloaded ZIP will contain similar CSV files to the following:
- subscribers_email*.csv · unsubscribed_email*.csv · non_subscribed_email*.csv · cleaned_email*.csv

Export your Contacts to CSV
3
Export Tags

Tags are included in your audience export CSVs. Review the CSV columns to see all tags in use.

4
Export Segments

In Audience, click Segments.
For each segment, export the contacts using the export option.

Export your Contacts to CSV
5
Export Custom Fields (Merge Tags)

Custom fields (called Merge Tags in Mailchimp) are included in your audience export CSV. Review the CSV columns to see all custom fields in use.

7
Export Automations (Optional)

For automations, go to Automations.
There is no direct export, but you can screenshot or document the steps for reference when rebuilding in Bento Flows.


Merge & Clean

  1. Open each of the exported CSV in your spreadsheet tool.
  2. Rename columns to Bento‑friendly names (email, first_name, tags, etc.), ensure they match in each csv file.
  3. Comma‑separate multiple tags (e.g. vip,customer).
  4. Delete any blank or irrelevant columns — Bento ignores missing headers but a tidy sheet is easier to debug.
  5. Save each CSV as a separate file.

Column Map Example

EmailTagsRemove TagsFirst NameLast Name
[email protected]customer, mqlleadJesseHanley

After Exporting

  • Double-check your CSV files for all required data (contacts, tags, groups, custom fields).
  • Organize your files and screenshots for easy access during the Bento import process.
  • If you need to clean up or rename tags/fields, do so in the CSV before importing to Bento.

Troubleshooting

Missing Data?
  • Make sure you exported from the correct section (Audience, Tags, Groups).
  • Check your downloads folder for the CSV file.
  • Open CSVs in a spreadsheet app to review all columns.
  • Lists over 100k contacts? Mailchimp may split exports into multiple CSVs—download every part and combine before merging statuses.
Export Button Not Visible?
  • You may need admin permissions to export data.
  • Try a different browser or clear your cache.
  • Contact Mailchimp support if you still can't export.

Critical Terminology: Mailchimp → Bento

Before we dive in, let’s align on key concepts. This table is your Rosetta Stone for migrating mental models from Mailchimp to Bento.

Mailchimp TermBento TermWhat It Actually Means
ContactPersonA human with an email address
Audience(none)Bento has a single People table — use tags + segments instead of siloed lists
TagTagLabels for categorization — in Bento, tags are first-class and support advanced logic
GroupTag or SegmentDepending on behavior, use a dynamic Segment or a static Tag in Bento
Merge FieldFieldCustom data attached to a Person, like first_name, plan, or last_seen_at
CampaignBroadcastA one-time email sent to a specific group or segment
AutomationFlowIf-this-then-that workflows — Bento Flows support triggers, delays, branching, and more
GoalEvent + Flow logicLogic conditions inside a Flow that advance a user based on behavior
Event TrackingEventTrack pageviews, clicks, custom behavior — all events are first-class in Bento
Merge TagsLiquidDynamic content via Liquid templating

The Mental Model Shift

Mailchimp: "Here's an audience with Groups and Tags."

Bento: "Here's a person who visited 5 pages, clicked 3 emails, has an LTV of $497, and is currently browsing your pricing page."

Final Thoughts

This migration will take you 2–4 hours of actual work.

Remember:

  • Take screenshots before changing anything
  • Test with your own email first
  • Keep Mailchimp running during transition
  • Document everything for your future self

Quick Reference

During Migration:

  • Check Bento's Dashboard
  • Monitor deliverability score
  • Test forms and integrations
  • Send one test email after changes

Before Canceling Mailchimp:

  • All Contacts are imported
  • All automations rebuilt
  • List is warmed up on Bento
  • Forms all working
  • Deliverability metrics stable

Emergency Contacts:

You've got this. And if you don't? That's what support is for. Ship it.