How does MyOperator handle duplicates or incorrect phone numbers in my Excel/CSV upload?
Quick answer
During upload, MyOperator automatically skips duplicate numbers, invalid formats, non-Indian numbers (by default), and blank rows. Only the first occurrence of a duplicate is kept; valid +91 numbers are imported.
When should I use this guide?
Open it right after preparing your audience file to understand what will be accepted, what will be skipped, and how to read the error report.
1. What the system removes automatically
Type of entry | Action taken |
|---|---|
Duplicate phone numbers | Only the first instance is kept |
Invalid numbers | Skipped |
Blank/malformed rows | Skipped |
2. Example upload vs. result
Name | Phone number | Import result |
|---|---|---|
John Doe | 919876543210 | ✅ Imported |
Jane Smith | 98765abc | ❌ Skipped – invalid format |
Rahul | ❌ Skipped – non-Indian | |
(blank) | (blank) | ❌ Skipped – empty row |
Only John Doe is imported; the rest are excluded with error notes.
Even if you save the file in the restricted pattern (blank, international numbers etc), you will get an error while uploading those contacts.
3. Notes & best practices
- Default rule: only 91 numbers are accepted (international sending not yet supported).
- File hygiene:
- Use international format 91XXXXXXXXXX.
- Remove special characters or spaces in numbers.
- Eliminate duplicates and blank rows before upload.
- Error handling: click Download Error Report after upload to review rejected entries and fix them before retrying.
4. Edge cases & fixes
Issue | Impact | Recommended action |
|---|---|---|
Renamed or deleted a mandatory column | Upload fails | Keep original headers |
Special characters in numbers | Number rejected | Remove spaces, dashes, symbols |
Blank rows | Validation errors | Delete empty rows |
Non-Indian numbers needed | Skipped | Enable international sending (when available) |
5. Summary
- The system filters out duplicates, invalid, non-Indian, or blank entries.
- Only clean 91 numbers are imported by default.
- Always review the Error Report and clean your file to maximise delivery success.
Keywords: duplicate phone numbers, invalid number, Excel upload, error report, MyOperator
Updated on: 12/01/2026