Okay, so maybe I exaggerate a little, but once you see what they can really do to help you with your genealogy research … you might even agree.  (Plus, spreadsheets don’t pee on your stuff).

Spreadsheets can be intimidating if you’ve never used them, but they can also be one of the most valuable weapons in your arsenal for organization, research, and analysis.

Census Worksheet

This is one of my favorites.  I was having a hard time remembering which census records I found for which ancestors and which ones I hadn’t.  I also needed a way to figure out where else to look.  Of course … a spreadsheet!

This is the end result:

census worksheet snapshotI use Microsoft Excel, but spreadsheets created in Google Drive act basically the same way.

I realize it looks a little daunting at first, but once you have a system (yours may differ), I can tell at a glance exactly what is going on.  I’ve listed my ancestors according to generations in the leftmost column.  Then I listed all the states in which that ancestor lived (you’ll see why in a minute).  Then I have a column for each year the census was taken.  Obviously, this page is for the United States, but I also have pages for other countries – note the tabs at the bottom.  Each page is set up essentially the same way.

Once I had all the columns marked, I began coloring in the cells (or boxes) for those census years during the lifetime of each ancestor … those census years in which that particular ancestor should appear (with the exception of 1890 because I have never been able to find any surviving census records for any of the places where my ancestors lived … but just in case, I left the column there).

I also indicated in the appropriate columns where my ancestor lived if they weren’t in the United States.  This enables me to cross-reference them on one of the other pages.  For Irish census records, I went to National Archives of Ireland, where there is a (free) searchable index and corresponding images for all census years.  Canadian censuses (indexes and images) are available for free at Library and Archives Canada.

After identifying the boundaries within which I should be searching, I began to place Xs in the boxes for each year that I found that ancestor on the census.  This made it much easier for me to tell which censuses were missing.  I decided to add red squares around the empty boxes to further alert me that I still have missing census records.

Because the national census pages worked so well, I also created pages for each state in which an ancestor lived (only the ones that had state censuses).  Using the FamilySearch Wiki, I was able to identify the census years for each specific state – and which years had missing parts, etc.  Just having this information available to me visually all in one place has been incredibly helpful and has saved me a ton of time by not having to search through RootsMagic or through the hard-copy file just to see what’s missing.

If you think my spreadsheet might be helpful to you, here is a link.  I deleted all my family information, but left the column headings for the state and country census that was already there.  You’ll have to download it to make any changes.  Be forewarned … it was never intended to be printed, so it will look pretty wonky if you try.

Next time:  Timelines!


Do we share ancestors? Email me: lostancestors AT gmail DOT com

Copyright 2016 - Jenny-ology.com

Disclosure:  Some posts may contain affiliate links, which means I may be compensated if you purchase a product using one of those links. There is no additional cost to you. Occasionally I receive free products to review, which will be indicated in my review posts. All opinions are my own, regardless of compensation.  See my full disclosures at the link above.


Why Spreadsheets Are Cuter Than Kittens – Part 1 — 8 Comments

  1. I do something similar but I enter a column with their birth year. Then I subtract that from each census year so that I get an age that the individual should be close to. When I am searching census records that helps determining if a record is possible match or not.

  2. Great idea, I also thought of the birth year but for several of mine I also would add DOD. (I have so many duplicate names, particularly with the Scots-Canadian bunch!)
    Thinking if I did one for each branch it would help me even more. Can’t wait to see the timeline, so far that has been my biggest failure.

  3. I am starting to learn the value of spreadsheets and starting to use them in my research. Have used them forever at my day job but never really figured out their value to genealogy until recently. I just started one for old church records I’m going through. Putting all the entries into a spreadsheet then I can sort by family, couple, address, etc… Now I have another to use for census, thanks for the tip.

    • Christopher, I transcribed a church book using excel, too. It made it super easy to create an index, which I then posted on my blog 🙂 Keep an eye out – there will be more spreadsheets!

  4. This is a great idea, Jenny. I appreciate that you gave us a starter file. I can see using this for each of the family lines that I have. It will also be useful for when working on client work.

Leave a Reply

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