DoetraNID 13 to 17 digits for the whole list at once.
An old 13-digit NID becomes 17 digits by putting the birth year in front. If your list has a birth date column, each row gets its own year. Rows with no birth date or a wrong-length number are listed for you.
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
Why does Excel turn the end of a 17-digit NID into 00?
Excel only keeps 15 digits of a number and turns the rest into zeros. We flag those cells — the real number has to come from the original paper. In the file we give back, NIDs are stored as text so they are never cut again.
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.