Get started
Platform / Moving to Mercleo

Move your members and their history to Mercleo

Import your people from a spreadsheet or your old tools, match them to the right fields and merge the duplicates. Their history and consent come with them.

UploadMap columnsReviewImport
members-export.csv4,212 rows · 7 columns
Column in your fileField in MercleoExample
Email addressEmailmaya@acme.org
First nameFirst nameMaya
Last nameLast nameChen
Member sinceJoined2019-04-02
LevelMember tierProfessional
Opt inEmail consentYes
NotesSkipPrefers email
6 of 7 columns mappedContinue to review
Possible duplicateSame email, different names
Maya Chenmaya@acme.org
Phone416 555 0134
JoinedApr 2019
Events12
M. Chenmaya@acme.org
Phone(none)
JoinedJan 2021
Events3
Merge into Maya Chen · keeps the earliest join date and every eventMerge
Duplicates

Duplicates are found and merged when you import

Imports check for people you already have. Review possible duplicates side by side and merge them, keeping the history from both.

Matched before they landNew rows that match an existing person update them instead of adding another.
A queue to work throughAnything unclear waits in the duplicates queue for a person to decide.
What comes across

Import each person’s history, not only their name

The details that make a profile useful come with each person.

People and membershipContacts, companies, member tiers, join and renewal dates.
Contacts4,180
Companies312
Memberships2,904
Events and givingPast attendance, donations and receipts, as history on each person.
Event attendance18,240
Donations6,031
Receipts5,870
Consent, keptEmail consent and where it came from, so you can keep sending to the right people.
Maya ChenConsented
SourceImported · signup form, 2019
Review first

Review every import before anything changes

Every import ends with a review: who is new, who gets updated and what needs a decision. Confirm when it looks right.

Start with a test fileTry a small export first and check how it lands.
Fix in the file, or afterDownload the rows that need work, or clean them up in Mercleo.
Import reviewmembers-export.csv
4,148new people
32updates to people you have
14possible duplicates
18rows with no email
Nothing is imported until you confirm. Rows with problems are listed so you can fix them first.