DoetraBangla numbers to English across the whole Excel file.
Excel does not treat ০১৭১২ as a number — sums, sorting and lookups all break. Drop the file: digits become English, Bangla words stay exactly as they are.
What it fixes
Phone numbers
+880, 880, a missing 0, Bangla digits, dashes — one form, operator shown.
+৮৮০ ১৭১১-২৩৪৫৬৭ → 01711234567
NID 13 → 17
Birth year added from your date column. Numbers Excel already cut are caught.
2695412873561 → 19902695412873561
Broken Bijoy text
Names typed in SutonnyMJ become real Bangla; English stays as it is.
Avãyi ingvb → আব্দুর রহমান
The same person twice
Matched by NID, phone or birth date — even across Bangla and English.
মোঃ রফিকুল ইসলাম → Md. Rafiqul Islam
Why not just ask a free AI chatbot?
Chatbots are great at writing. Cleaning 5,000 rows of ID numbers is a different job.
| Free AI chatbot | This tool | |
|---|---|---|
| Where your NID and phone list goes | Sent to someone’s server | Stays on your computer |
| How many rows | Stops or skips rows on big files | 100,000+ rows, every sheet |
| Does it change numbers by mistake? | Can quietly invent or drop digits | Exact rules — unsure cells flagged, never changed |
| Proof of what changed | No | “Changes” sheet, cell by cell |
| Your Excel formatting | Lost — you get plain text | Kept: sheets, colours, widths |
| Bijoy-broken Bangla, BD phones, NID, 64 districts | Hit or miss | Built for Bangladesh |
| Same person in Bangla and English | Only if you ask, row by row | Found across the whole file |
| Same result every time | Different each try | Always the same |
How it works
Four steps, under a minute for most files.
- 1
Drop your file
Excel or CSV. We read every sheet right in your browser.
- 2
Check the columns
We guess which column is phone, NID, date, district. Change any guess.
- 3
Review
See every fix before and after. Settle the flagged cells and duplicates.
- 4
Download
The same workbook, cleaned, with a full list of changes inside.
Questions
Will Bangla names and addresses change too?
No. Digits change only in cells that hold just a number, and in phone, NID, date and money columns. Text like "বাড়ি নং ১২" stays as it is.
Is my file uploaded anywhere?
No. Everything runs in your browser. You can even turn off the internet after the page loads.
Does it change my original file?
No. You download a new, cleaned copy. Your original stays as it was.
What about formulas?
Formula cells are never touched. Only typed text and numbers are cleaned.
How do you know the operator?
From the prefix: 013/017 Grameenphone, 014/019 Banglalink, 018 Robi, 016 Airtel, 015 Teletalk. A number ported to another operator keeps its old prefix.
Which spelling do districts get?
The official 2018 English spellings (Chattogram, Cumilla, Barishal, Jashore, Bogura), or Bangla if you prefer.