South African ID Number Checker in Excel version 2
6 July 2026 - this is version 2.1, version 2.2, 2.3 and 2.4 were lost when the host had a problem. There is a bug in multiple checks in this version and some issues with checking leap years.
A long time ago, I built a simple Excel spreadsheet that worked out if an ID number was valid or not. Since I released it, I have received a lot of feedback about the spreadsheet. Most of the feedback was about how it worked, but a week ago, Riaan contacted me and pointed out a bug in it, so I took this as an opportunity to rebuild it.
Not only does the new version check the validity of the ID number, but it also tells you where the person was born, their gender, and birth date.
Something else I wanted to do was clean up the calculations. So now they have been moved to their own (hidden) tab and are documented.
For those who need to do bulk checking, the second sheet of the Excel spreadsheet contains the ability to check multiple ID numbers.
I want to extend a massive thanks to Riaan Pretorius—not only for pointing out the bug but also for running the new version through its paces and finding some issues in it. The fact that this one is much better is owed to him. I just typed the code 😊
You can download the Excel file below!