Easy Way to Create a Census Checklist Using Excel

This technique was created in preparation for the 1940 Federal Census and I have adapted it for other censuses  It is easy to implement, using your Genealogy Database software, Microsoft Excel and the Excel Text Import Wizard. It was invaluable to me in keeping track of what I had found and not found as the census records were released in 2012.

Check out this video to see how to implement this technique, which as it turns out is very easy:

3 thoughts on “Easy Way to Create a Census Checklist Using Excel”

  1. I use Excel for all sorts of things. It makes sense to use it for tracking genealogy as well. Thank you for sharing.

    1. Deborah – thank you for the nice comment. I have seen and enjoyed your site with the World War 2 letters. I have a series on my family history site – “Letters from Germany” which are letters from 1915 through 1940 or so – all in old German script and fortunately after 5 years I have a very good translator. They are a wonderful way to tell the stories of our ancestors. If you are interested, the site is http://www.braunhart.com

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top