> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://myoperator.crisp.help/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 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 | +44 7700000000 | ❌ 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