Excel Tip - Verifying Personal Details using the SA ID Number

Its pretty well known that the first 6 digits of your South African ID Number is your Date of Birth. Un-beknown to many though, the SA ID Number has a few other Personal Details hidden within its 13 digits!


This is the breakdown {YYMMDD}{G}{SSS}{C}{A}{Z}

YYMMDD: Date of birth

G: Gender. 0-4 Female; 5-9 Male.

SSS: Sequence No. for DOB/G combination.

C: Citizenship. 0 SA; 1 Other.

A: Usually 8, or 9 (can be other values)

Z: Control digit.


Using this information and some neat Excel Formulas we can maximise the use of the ID Number to Verify and/or extract this key Personal Info, as well as validate the ID Number itself.


Click here to Download this handy Spreadsheet that will enable you to do all of that without having to come up with the Formula!

Share on Facebook
Share on Twitter