Easy Way to Create a Census Checklist Using Excel

2/16/2013

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 Comments

Deborah Sweeney link

2/16/2013 09:42:01 am

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

Kenneth R Marks link

2/16/2013 11:43:55 am

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

Deborah Sweeney link

2/17/2013 08:13:44 am

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

Save Time
Check out the new
By Location Feature

Free Resource Links

Facebook Page

Enter Email

Search This Site

Write or Record Your Autobiography the Easy Way

Use the Coupon Code HUNT to get a 10% discount

RSS Feed

"The Ancestor Hunt" is a participant in the Amazon Services LLC Associates Program. There may be a small commission paid to "The Ancestor Hunt" should you purchase from Amazon.

.
"The Ancestor Hunt" is also an affiliate for "A Life Untold", and "Audiobiography". There may be a small commission paid to "The Ancestor Hunt" should you purchase from these companies.