• Test Your DNA!

Track Your Family Ethnicity on an Excel Chart!

My Ancestry or Ethnicity at a Glance! Everyone’s doing it so why not you? Below you’ll find a blank, 6-generation Excel sheet formatted so that you can track your ancestors names OR – as the new fad suggests – color-code each ancestor’s country or ethnicity. As an example, here’s mine and the logic I chose. First I created an excel sheet with each cell outlined that would have an ancestor’s country listed. I stuck to the convention where father’s are on top and mother’s on the bottom… coughs.. well.. it’s a tradition. I chose to vertically align the countries in … more…