UPDATE (09 NOV 2015): 23andme is retiring Countries of Ancestry (the tool formerly known as Ancestry Finder) as of November 11, 2015. I’m leaving this blog post out here for posterity, mainly due to vanity and the amount of time I put into creating my Excel sheet. 😉
Update: I have made some changes to the Import tool – you can download the latest version at the original link listed below. See more info at the bottom of the post.
After creating and writing up my last post on the process to automate the download of 23andme Ancestry Finder data files for your matches, I could not resist working on a way to combine all of those data files into one.
I figured Microsoft Excel was the best common denominator to use for this process – there are any number of tools I could use to combine the files and work with them at the command line, but that would limit the number of people who could use it.
So, here’s the quick scoop: My Excel spreadsheet is designed for use with the .CSV data files you have already downloaded from 23andme’s Ancestry Finder. (Again, see my Ancestry Finder Download Tool post for more info on that process.)
- It will import ALL .CSV data files in a selected folder
- It will add a column with the name of the 23andme user the data file came from. (It uses the data file name for that, so don’t rename them after you download them!)
Then it will make you a sandwich. A nice juicy data sandwich.
Each data row will have the source person AND matching person’s name in it – otherwise you would have a list of a few hundred thousand matches without knowing whom they belonged to!