The Ancestor Hunt
  • Home
  • Blog
  • Newspapers
  • Newspaper Links
  • Obituaries
  • BMD Records
  • Photos
  • Yearbooks
  • Directories
  • By Location
  • Cemetery Records
  • Divorce Records
  • Naturalizations
  • Immigration
  • Mortuary Records
  • Church Records
  • School Records
  • Voter Records
  • Coroner Records
  • Probate and Wills
  • Alumni Records
  • Newsletter Page
  • Tools
  • Genealogy News
  • California Genealogy
  • Videos
  • Fun With Newspapers
  • About
  • Contact
  • Privacy Policy

Easy Way to Create a Census Checklist Using Excel

2/16/2013

3 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:


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.

Reply
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

Reply
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!




Leave a Reply.

    Check Out the NEW Subscription Options

    Save Time
    With the ​By Location Feature
    ​
    Free Resource Links
    ​​

    By Location Newspapers Obituaries BMD Records Directories Photos Yearbooks Cemetery Records Divorce Records Naturalizations Mortuary Records Immigration Church Records School Records Voter Lists Coroners Records Probate and Wills Alumni Records

    Subscribe
    Option 1 - Receive Links to New Published Articles 4 X per month

    Enter Email
    Subscribe
    ​    Option 2​ - Receive New Complete
    Bi-Monthly Newsletter​     ​
    Enter Email

    Search This Site

    Write or Record Your Autobiography the Easy Way

    Picture
    ​Use the Coupon Code HUNT to get a 10% discount
    Picture
    ​Use the Coupon Code HUNT to get a 10% discount
    Facebook Page
    Picture

    RSS Feed

    Archives

    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    October 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    April 2013
    March 2013
    February 2013
    January 2013
    December 2012
    November 2012
    October 2012
    September 2012
    May 2012
    April 2012
    November 2010
    October 2010

Picture
©2012-21

Thanks for Visiting The Ancestor Hunt
The Ancestor Hunt is focused on helping primarily hobbyist genealogy and family history researchers to achieve their goals.

"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", Trace.com, and "Audiobiography". There may be a small commission paid to "The Ancestor Hunt" should you purchase from these companies.