Add 91 to phone numbers in Excel – in one go
Paste your numbers or upload the Excel or CSV sheet below. +91 is added only to numbers that do not have a code yet, a leading 0 is removed, and numbers that already start with + or 00 (Dubai, UK, US…) keep their own code. Download the fixed sheet – or, if you would rather do it inside Excel or Google Sheets, the formulas are right under the tool.
What the tool does to each number
WhatsApp only understands a number in full international form: country code, then the mobile number, with no 0 in front and no spaces. A 10-digit number on its own is not enough – in a wa.me link or a bulk send, 9876543210 has no country, so it fails or reaches the wrong person. The tool reads every number on its own, so a column with mixed formats comes out right in one pass.
Your sheet is read in your browser and is not uploaded anywhere. Name, city, amount and every other column stay as they are; the fixed number goes into a new “Clean phone” column. The tool also removes duplicates and numbers that are too short – if you only want the code added, untick those two boxes.
| In your sheet | After the tool | Why |
|---|---|---|
| 9876543210 | +919876543210 | 10-digit Indian mobile – +91 added |
| 09876543210 | +919876543210 | Leading 0 (the trunk 0 for calls inside India) removed, then +91 added |
| 98765 43210 or 98765-43210 | +919876543210 | Spaces and dashes removed |
| 919876543210 | +919876543210 | Already has 91 – not added twice |
| +91 98765 43210 | +919876543210 | Already has +91 – only the spaces go |
| 9.19877E+11 (in an Excel cell) | +919876543210 | Excel only shows the number short – the full number in the cell is read |
| +971 50 123 4567 | +971501234567 | Another country’s code is kept |
| 0044 7911 123456 | +447911123456 | 00 is the same as +, so the UK code is kept |
Excel formula to add 91 to phone numbers
If your numbers are all Indian mobiles, put this in B2 (with the numbers in column A) and drag it down. It leaves a number that already starts with + alone and puts +91 in front of the last 10 digits of everything else – so 9876543210, 09876543210 and 919876543210 all become +919876543210.
=IF(LEFT(A2,1)="+",A2,"+91"&RIGHT(A2,10))
That short version breaks when numbers have spaces, dashes or brackets in them (98765 43210 would become +918765 43210). For a messy column, first clean it in B2 with SUBSTITUTE, then add the code in C2:
B2: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2," ",""),"-",""),"(",""),")","")
C2: =IF(LEFT(B2,1)="+",B2,"+91"&RIGHT(B2,10))
When the column is right, copy it and use Paste Special → Values, so the numbers stay even if you delete column A. The result is text, which is what you want: Excel will not turn it into 9.19877E+11 again.
How to add 91 in Google Sheets
Both formulas above work in Google Sheets without any change. Sheets also has REGEXREPLACE, which removes every space, dash, dot and bracket in one step. With the numbers in column A, this one formula does the whole job:
=IF(LEFT(A2,1)="+",REGEXREPLACE(A2&"","[^0-9+]",""),"+91"&RIGHT(REGEXREPLACE(A2&"","[^0-9]",""),10))
The &"" turns a typed number like 9876543210 into text first, because REGEXREPLACE only works on text (TO_TEXT would copy the cell’s display format, so a column shown as 9.88E+09 would break). If you type a number with + yourself, start it with an apostrophe ('+919876543210), or Sheets and Excel drop the + and keep only the digits.
More formulas: remove 91, fix 9.19E+11, make wa.me links
Remove 91 or +91 from a phone number: =RIGHT(B2,10) on the cleaned column B gives the plain 10-digit mobile, for SMS tools and forms that want it without the code.
Number without the + (the format wa.me links and many CRMs want): ="91"&RIGHT(B2,10) gives 919876543210.
WhatsApp link for each row: ="https://wa.me/91"&RIGHT(B2,10) gives https://wa.me/919876543210 – tap it to open a chat without saving the number.
Numbers showing as 9.19877E+11: the full number is still in the cell; Excel is only showing it short. Select the column → Format Cells → Number with 0 decimal places, or use =TEXT(A2,"0") to get it as text. Before you type or paste new numbers, format the column as Text. One catch: a CSV saved while the column showed 9.19877E+11 really has lost the last digits (it saves 919877000000), so open the original .xlsx instead, or check a few rows.
Mixed countries in one column: the formulas above assume every number without + is Indian, so they would turn a UAE number written as 971501234567 into a wrong +91 number. The tool above does not – a number longer than 10 digits that does not start with 0 keeps its own code.
Send to the fixed list
Fixing the numbers is usually the step before sending something to all of them – a wedding invitation, a fee reminder, a Christmas or New Year offer. In the tool, press “Send to this clean list” and the list opens in the Rapid Sender bulk sender, with every column kept. Write one message with {{name}} in it, and each person gets their own message with their own name, from your own WhatsApp number, one by one.
Your first 50 messages are free; after that, credit packs start at ₹149 for 250 messages. If you would rather save the contacts on your phone first, turn the same sheet into a contacts file with the Excel to VCF converter.
Saving the numbers to your phone instead? Excel to VCF converter
Frequently asked questions
Excel में नंबर के आगे 91 कैसे लगाएं?
नंबर कॉलम A में हों तो B2 में =IF(LEFT(A2,1)="+",A2,"+91"&RIGHT(A2,10)) लिखें और नीचे तक खींचें। या अपनी Excel फ़ाइल ऊपर के टूल में डालें – जिन नंबरों में 91 नहीं है उनमें +91 जुड़ जाएगा, आगे का 0 हट जाएगा, और फ़ाइल आपके फ़ोन या कंप्यूटर से बाहर नहीं जाती।
Will it add 91 twice to numbers that already have it?
No. Numbers starting with +91, 0091 or 91 followed by 10 digits are recognised and left as they are; only spaces and dashes are removed. The Excel formula also keeps numbers that start with +, and takes only the last 10 digits of the rest, so 919876543210 does not become +91919876543210.
Should the number have + in front for WhatsApp?
For a wa.me link, use only digits: https://wa.me/919876543210, with no +, spaces or leading 0. In a contact sheet for a bulk sender or in your phone’s contacts, +919876543210 is the clearest form – both mean the same number.
How do I remove 91 from phone numbers in Excel?
Use =RIGHT(A2,10). It keeps the last 10 digits, so +919876543210, 919876543210 and 09876543210 all become 9876543210. If the numbers have spaces, clean them with SUBSTITUTE first, or RIGHT will count the spaces too.
Can I add a country code other than +91?
Yes. Choose the default country in the tool – +92, +880, +977, +971, +1, +44 and every other code are there. In the formula, replace "+91" with the code you need and 10 with the length of a mobile number in that country (for example 9 for the UAE).
Is my contact list uploaded anywhere?
No. The sheet is read and fixed in your browser. Nothing is sent to a server, and the list you pass to the sender stays in this browser tab.
Ready to send your message?
Upload your list, write your message and connect your WhatsApp. It is free and takes a few minutes.
Start sending