Free tool

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.

With India (+91) as the default code. Pick another default country in the tool for Pakistan (+92), Bangladesh (+880), Nepal (+977), UAE (+971) and others.
In your sheetAfter the toolWhy
9876543210+91987654321010-digit Indian mobile – +91 added
09876543210+919876543210Leading 0 (the trunk 0 for calls inside India) removed, then +91 added
98765 43210 or 98765-43210+919876543210Spaces and dashes removed
919876543210+919876543210Already has 91 – not added twice
+91 98765 43210+919876543210Already has +91 – only the spaces go
9.19877E+11 (in an Excel cell)+919876543210Excel only shows the number short – the full number in the cell is read
+971 50 123 4567+971501234567Another country’s code is kept
0044 7911 123456+44791112345600 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.

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

How do I add 91 before all numbers in Excel at once?

Upload the sheet to the tool on this page and download it back – +91 is added to every number that needs it. In Excel itself, put =IF(LEFT(A2,1)="+",A2,"+91"&RIGHT(A2,10)) in the next column and drag it to the last row. If the numbers have spaces or dashes, remove them first with SUBSTITUTE as shown above.

नंबर कॉलम A में हों तो B2 में =IF(LEFT(A2,1)="+",A2,"+91"&RIGHT(A2,10)) लिखें और नीचे तक खींचें। या अपनी Excel फ़ाइल ऊपर के टूल में डालें – जिन नंबरों में 91 नहीं है उनमें +91 जुड़ जाएगा, आगे का 0 हट जाएगा, और फ़ाइल आपके फ़ोन या कंप्यूटर से बाहर नहीं जाती।

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.

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.

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.

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).

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