Guide · beginner
How to import contacts and clean up duplicates
Import a CSV of contacts into Montr BI CRM, match your columns, avoid duplicates and merge the ones that slip through. Takes about 10 minutes.
Your customers live in a spreadsheet, a billing tool and a few phones. This guide gets them into one place, with no duplicates.
Before you start
Prepare your file. It takes five minutes and saves an hour.
- Save it as a CSV.
- Put column names in the first row: name, email, phone, and so on.
- Use one row per person.
- Write phone numbers with the country code, like +91 98xxxxxxx or +971 50xxxxxxx.
- Delete empty rows and test entries.
- Add a column for source (for example “Diwali sale”, “Shopify”, “Expo 2026”).
Check your consent
Only import people you may contact. If you plan to send marketing messages, note where each person agreed to hear from you. Add a column for it if you have the information. Do not import a bought list.
Step 1: open Import in the CRM
Open the CRM, go to contacts, and choose Import.
Step 2: upload your file
Upload the CSV. Montr reads the columns and shows you the first rows.
Step 3: match your columns
For each column in your file, choose the CRM field it belongs to. At a minimum, match name and email (or phone if you work on WhatsApp).
- Match your source column to a source field or a custom field.
- Leave columns you do not need unmatched.
- If your data has a field the CRM lacks, add a custom field first, then match it.
Step 4: let duplicate protection work
Montr checks for duplicates during import. A person who already exists should not be created a second time. Look at the summary after the import:
- How many records were created.
- How many were skipped as duplicates.
- Any rows that failed, and why.
Fix failed rows in your file and import them again.
Step 5: tag the import
Tag everyone you just imported, for example “diwali-2026-import”. Tags let you find the group later and build a campaign audience.
Step 6: find remaining duplicates
Some duplicates slip through: the same person with two spellings, two emails or a new number. Montr catches duplicates with rules you control and has a merge screen.
- Open the duplicates view in the CRM.
- Review each pair side by side.
- Choose which values to keep.
- Merge. The activity history from both records is kept on the result.
You can merge contacts, companies and deals.
Merge carefully. If two people share an email, such as a family or a company inbox, they may be different people. When in doubt, leave them apart.
Step 7: set up a saved view
Create a saved view for the import: filter by your tag or source. It gives you a list to check, call or send to later.
Step 8: check consent flags
Open a few contacts and look at the Consent tab. It shows opt-ins and opt-outs with the source and timeline. Fix anything missing before you send marketing messages. Montr respects these flags across email, WhatsApp and voice.
If something goes wrong
Deleted records go to the Trash and can be restored for 30 days, so a mistake is not final. Only a platform admin can delete a record for good.
Common mistakes
- Messy phone numbers. Without the country code, WhatsApp sends can fail.
- One column for full name. Split it if you can, or use the full name field.
- Merging too eagerly. Check every pair.
- Skipping the source column. Later you will not know where anyone came from.
Next steps
Send your first campaign to the list. See email marketing or run your first WhatsApp campaign. To keep the CRM current, read how to build a CRM your team actually updates. The CRM page lists everything it does.