Easy Way to Create a Census Checklist Using Excel

02/16/2013

5 Comments

 
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:


 


Comments

Deborah Sweeney link
02/16/2013 5:42pm

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

Reply
Kenneth R Marks link
02/16/2013 7:43pm

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 www.braunhart.com

Kenneth

Reply
Deborah Sweeney link
02/17/2013 4:13pm

Thank you Kenneth. I am glad you have enjoyed the World War II letters. I will check out your site!

Mariann Regan link
02/17/2013 4:04pm

This was interesting to me. I've never used Excel, but I can see the appeal of how it works. And I haven't used ancestral quest yet. Looks very orderly. And BTW, Salome Hitler? Makes me shiver.

Reply
Kenneth R Marks link
02/17/2013 4:10pm

I just happened to start with Ancestral Quest many years ago and I like it. I use Excel a lot for checklists so this is a good "Marriage." And her surname was "Hippler" not the evil name .

Reply



Leave a Reply