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 *