Skip to content
TheSpreadFix

Format Indian Phone Numbers

Indian phone numbers appear in dozens of variations: 9876543210, 09876543210, 91-98765-43210, +91 98765 43210, 0 98765-43210, (022) 24571234. This tool normalises them all to +91 E.164 format — the standard that CRMs, WhatsApp Business, SMS gateways and calling platforms expect. Upload your CSV or Excel file and convert an entire phone column in one pass.

Drop a CSV or Excel file here

.csv, .xlsx, .tsv

Your file stays on your device. It's read and cleaned in your browser — nothing is uploaded.

How it works

  1. Step 1

    Upload your file

    CSV or XLSX. Columns named phone, mobile, tel, contact, WhatsApp and similar are detected automatically.

  2. Step 2

    Review the conversions

    Each number is shown with its original value and the E.164 result. Invalid numbers are flagged with the reason.

  3. Step 3

    Download the clean file

    Get a new file with all phone numbers in +91XXXXXXXXXX format, ready for your CRM or messaging platform.

What it checks and fixes

10-digit mobile numbers

Numbers like 9876543210 are prefixed with +91 to become +919876543210.

0-prefixed numbers

National trunk prefix (09876543210, 022-24571234) is removed and +91 is added.

Already prefixed numbers

Numbers starting with +91, 91- or 0091 are cleaned of separators and normalised.

Landline numbers

STD code + number patterns (022-24571234, 080-25501234) are handled with correct length rules per city.

Indian phone number formats

India's numbering plan assigns 10-digit numbers for mobile phones (starting with 6, 7, 8 or 9) and variable-length numbers for landlines (2–4 digit STD code + 6–8 digit number, totalling 10 digits). The trunk prefix 0 is used for domestic dialing and is dropped in international format.

Format as enteredTypeE.164 output
9876543210Mobile (10-digit)+919876543210
09876543210Mobile with trunk prefix+919876543210
91 98765 43210Mobile with country code, spaces+919876543210
+91-98765-43210Mobile with +91 and hyphens+919876543210
0091 9876543210Mobile with 00 prefix+919876543210
022 2457 1234Mumbai landline with STD code+912224571234
080-2550-1234Bengaluru landline with STD code+918025501234

Mobile vs landline detection

After stripping the trunk prefix and country code, mobile numbers are exactly 10 digits and start with 6, 7, 8 or 9. Landline numbers also total 10 digits (STD code + subscriber number) but start with 2, 3, 4 or 5 (the STD code).

The tool uses this distinction to validate: a 10-digit number starting with 0 or 1 is invalid for India. Numbers shorter than 10 digits after cleaning (like an old 8-digit Delhi number without the STD code) are flagged for manual review.

Common formatting problems in Indian phone data

  • Inconsistent prefix — the same list has 9876543210, +919876543210 and 09876543210.
  • Spaces and hyphens inserted at different positions — +91 98765 43210 vs +91-9876-543210.
  • Country code without plus — 919876543210 looks like a 12-digit number but is actually +91 + 10 digits.
  • Excel scientific notation — long numbers like 919876543210 become 9.19877E+11 and lose digits.
  • Mixed countries — a few international numbers in a mostly Indian list get wrongly prefixed with +91.
  • Landline without STD code — 24571234 (8 digits) is a Mumbai number but needs 022 to be complete.

Why E.164 matters for Indian businesses

Most Indian businesses use WhatsApp Business, Zoho PhoneBridge, Freshcaller, Exotel or similar platforms for customer communication. All of these require or prefer E.164 format (+91XXXXXXXXXX). CRMs like HubSpot, Zoho and Salesforce display and match phone numbers correctly only when they're in a consistent international format.

For bulk WhatsApp messaging via the WhatsApp Business API, numbers must be in E.164. A list with mixed formats — some with +91, some without, some with 0 — causes delivery failures and wasted API credits.

Frequently asked questions

Does it handle landline numbers?

Yes. Landline numbers with STD codes (022-24571234, 080-25501234) are converted to E.164. Landline numbers without an STD code are flagged as too short for manual correction.

What about numbers from other countries in my list?

Numbers that already start with + and a non-91 country code are left unchanged. Numbers without a prefix are assumed to be Indian — the report states this assumption clearly.

Will it convert WhatsApp numbers correctly?

Yes. The output format (+919876543210) is exactly what the WhatsApp Business API expects.

Is my file uploaded?

No. The file is read and processed entirely in your browser. Nothing leaves your device.