Why does your Contacts folder suddenly contain six identical entries for 'Sarah Chen'? Why do imported calendar events show up three times—even after you deleted them once? Why does Outlook act like it’s never seen that CSV before, even though you’ve imported it twice this week?
Because Outlook doesn’t *automatically* skip duplicates—and most people assume it does. It doesn’t. Not by default. Not in any version. And worse: the setting that controls this isn’t where you’d expect it.
Most Common Cause
You’re using
File > Open & Export > Import/Export > Import from another program or file, then selecting a PST, CSV, or vCard—but skipping the final checkbox labeled
"Do not import duplicates". That box is unchecked by default. Always. Even if you imported the same file last Tuesday.
I’ve seen this trip up even experienced users. They click through the wizard fast, miss that one checkbox, and walk away thinking, “Outlook must be smart enough to handle this.” It isn’t. Not unless you tell it to.
Diagnostic Steps
First, confirm whether duplicates are truly new imports—or lingering artifacts from earlier attempts.
Open your target folder (e.g., Contacts or Calendar). Sort by
Modified (right-click column header >
Field Chooser > drag
Modified into view). Look at timestamps: if all duplicates share the exact same Modified time down to the second, they came in together—in one import.
Next, check your import history. Outlook doesn’t log this, but Windows does. Go to
Event Viewer > Windows Logs > Application and filter for source
MSExchangeIS (if on Exchange) or search for
import and
outlook.exe. Not always helpful—but worth checking if duplicates appear *after* syncing, not just after manual import.
Finally, test with a tiny file. Export 3 contacts as CSV. Delete them manually. Then re-import that same CSV—
with the "Do not import duplicates" box checked. If they still appear twice, the issue isn’t the import wizard. It’s something else.
Fix #1: Enable the Hidden Checkbox During Import
This fixes ~70% of cases.
Start the import:
File > Open & Export > Import/Export > Import from another program or file > Next > Comma Separated Values > Next.
Browse to your file. Click
Next.
Here’s where almost everyone fails: On the next screen, you’ll see:
- Replace duplicates with items imported (default)
- Allow duplicates to be created
- Do not import duplicates ✅
That third option is what you want. But note: it only appears
after you’ve selected the destination folder—and only for certain file types (CSV, vCard, Outlook Data File). It won’t show for Excel files or plain text.
Also: this setting applies per-import. There’s no global toggle. You must select it every time.
Fix #2: Disable Auto-Import Rules That Ignore Duplicates
Some teams use Outlook rules to auto-import email attachments (like meeting notes saved as .ics). Those rules bypass the import wizard entirely—and ignore duplicate logic.
Go to
File > Manage Rules & Alerts > Email Rules > New Rule > Apply rule on messages I receive. Look for rules with actions like
“move message to folder” +
“run a script” or
“start application”.
If you find one tied to an import macro or PowerShell script, open Outlook in Safe Mode (
Outlook.exe /safe) and disable it temporarily. Test again.
This took me three days to figure out originally. A marketing team had a rule that auto-saved every .ics attachment to Calendar—no dedupe logic, no prompts, no logs. Just silent duplication.
Fix #3: Exchange Server Sync Conflicts (Less Common But Critical)
If you’re on Exchange (office.alibaba.com uses Exchange Online), duplicates can appear when Outlook syncs with the server *while* you’re importing locally.
Here’s the counterintuitive part: turning off Send/Receive
before importing doesn’t help. What works is disabling
cached Exchange mode just for the import session.
Go to
File > Account Settings > Account Settings > double-click your Exchange account > uncheck "Use Cached Exchange Mode" > OK > Restart Outlook.
Now import your file. Afterward, re-enable cached mode and let Outlook resync. Duplicates vanish—because Outlook now treats the import as a local-only operation, not a sync conflict candidate.
This only applies to Outlook desktop (365/2019/2016). Outlook Web doesn’t support cached mode, so duplicates there usually stem from browser autofill or extension interference (e.g., a CRM plugin injecting contacts twice).
| Feature |
Outlook 365 |
Outlook 2019 |
Outlook 2016 |
Outlook Web |
| "Do not import duplicates" checkbox in CSV import |
✅ Yes |
✅ Yes |
✅ Yes |
❌ No (manual dedupe only) |
| Auto-dedupe during vCard import |
✅ Yes (v3+) |
⚠️ Partial (v2 only) |
❌ No |
✅ Yes |
| Cached mode toggle affects import behavior |
✅ Yes |
✅ Yes |
✅ Yes |
N/A |
| Duplicate detection based on SMTP address (not display name) |
✅ Yes |
✅ Yes |
✅ Yes |
✅ Yes |
| Can import .ics files without duplicates? |
⚠️ Only if UID matches |
⚠️ Only if UID matches |
⚠️ Only if UID matches |
✅ Yes (server-side dedupe) |
Still Not Working?
If duplicates persist after trying all three fixes:
- Check your Outlook add-ins. Go to File > Options > Add-ins > Manage: COM Add-ins > Go…. Disable everything except Microsoft ones. Restart.
- Run Outlook in Safe Mode (Outlook.exe /safe) and try the import again. If it works, an add-in is interfering.
- Look at your Exchange mailbox quotas. If you’re near quota, Outlook may fail mid-sync and retry imports silently.
- Contact your IT team with these specifics: your Outlook version, whether you’re on Exchange Online or on-prem, and a screenshot of the exact import wizard screen where duplicates appeared.
Don’t waste time deleting duplicates manually. Use this shortcut instead: In any folder, press
Ctrl+Shift+V to open
View Settings, then click
Filter… >
Advanced tab > add condition:
Subject contains + the name of your imported item (e.g., “Client Demo — Acme Corp”). Select all results, then delete.
Then go back and do the import—this time with
"Do not import duplicates" checked.
