j-j.co.za
Sharing thoughts and ideas on business, security and photographyChecking a sample of South African ID Numbers in Excel
Posted on March 11, 2015All South African Identity numbers have built in validation digits. The formula to check these isn’t a secret. This afternoon I needed to check a list of ID numbers to ensure they were all valid and was most grateful to Robert MacLean (and Riaan Pretorius) for their work in putting together (and sharing) an excel sheet which can validate the numbers. Just copy and paste in your sample.
Find a copy of this useful spreadsheet here : ID Number checker
Cross posted on ITSec’s blog.