Organize Your Family History

Stay focused and happy while exploring your roots

My progress-tracking spreadsheet

By 16 Comments

I wrote this post, which is one of the most-read posts on this blog (more than 31,000 views!), way back in 2013. It got a great response, so I thought I’d run it again for newer readers. For me, being able to see at glance which documents I’ve found (or need to find) for my ancestors has been really helpful. I hope you find the post useful!

My memory is not what it used to be. And I’m finding the more family history research I do, the more I’m duplicating effort. In the process of researching one person, another person will pop into my mind. I’ll look for a record for that person, rejoice in finding it, then realize I’d already found it!

So in an effort to avoid that, as well help me in my never-ending quest to not feel overwhelmed about my genealogy research, this past weekend I created a series of progress-tracking spreadsheets. I was inspired by Miriam’s Census Spreadsheet, which is a Google Doc. I’m a Mac user and I used the Numbers program (similar to Excel) to create three spreadsheets (so far) that track progress, by ancestor, on finding the following records:

Sheet 1: BMD

  1. birth records
  2. marriage records
  3. death records
  4. burial records
  5. grave photos

Sheet 2: Censuses

On the first table (pictured above) I have a row for each ancestor (this is a work in progress…I’ve been adding info a generation at a time and up to my great-great grandparents), and a column for each U.S. Census. I fill in the square in blue if that record was found. A grey square indicates the ancestor wasn’t alive for that census. A blank (white) square indicates I still need to find this record. I also have a table of state censuses, so I can note those.

Sheet 3: Military

Here I track what military records I’ve found for each ancestor, by war or conflict. This one’s definitely a work in progress.

Going through this process helped me realize how much census work I’d done and how much more work I had to do to find birth, marriage and death records. I think these charts will help me feel a sense of accomplishment and also help me hone in on work that needs to be done. I’ll keep adding ancestors from Reunion, until I’m caught up, and then plan to keep up with the spreadsheet as I find more records.

Keeping track of my progress

By 16 Comments

Keeping track of genealogy researchThis year, I’ve been focusing on one family line, the Adams line. I’ve been trying to gather as much information as possible not just on my direct-line ancestors (my focus in past years) but also on the siblings of my direct-line ancestors. It’s fun and fulfilling. But it’s also a bit overwhelming because there are so many people I can’t remember all of them.

I keep track of everything in my family-tree software, Reunion. But I also like having an at-a-glance summary of where I stand in my research on each person. Three years ago, I created a progress chart, which had a series of tabs on a spreadsheet in which I marked the documents I had found on each of my direct-line ancestors. That worked pretty well and gave me an at-a-glance summary I craved.

I find myself wanting a similar chart for all my research subjects, including the collateral lines, and I’m struggling with getting my arms around that. Part of my problem, I think, is that I want to be able to see everything at the same time, which is challenging when your family tree’s branches stretch wide.

Here’s what I’ve settled on. I’m creating a single spreadsheet for all the data I’m looking for for each family group (B/M/D, censuses, newspaper, military, wills, land, etc.). In my previous progress chart, I’d had all my direct-line ancestors listed on each sheet, with a separate sheet for each type of data. In this new chart, I have all my data types across the top, with a row for each member of the family group. I have a separate sheet (a tab) for each family group. I decided to start with my parents in the first sheet and work back in time by generation.

I’ve spent a little time with it and I think it’s going to be really helpful. As I started filling it out, I paid attention to how it made me feel and I had two conflicting feelings:

  • Overwhelm because there are so many people to enter into it and so many data types to research
  • Excitement as I realized how many opportunities for research there are

I think the key to making this useful and not overwhelming is putting one family group on each sheet. That narrows the focus and allows me to see what I have and what I can still research. It also helps me avoid feeling overwhelmed.

Having each family group on a separate sheet makes it easier to fill out the chart initially as well. I ordinarily enjoy filling out forms and updating progress charts. But this one was so large it felt like it might turn into a big exercise in tedium. So if I take it one family group at a time, it feels like fun, not drudgery.

I’ll keep you posted. Once I have it in shape where I think it might be useful to others, I’ll blog again and offer to send it to anyone who might want to use it.

If you have a similar chart and/or have any suggestions for mine, please share in the comments. I’m all ears!

Tracking progress

By 38 Comments

My memory is not what it used to be. And I’m finding the more family history research I do, the more I’m duplicating effort. In the process of researching one person, another person will pop into my mind. I’ll look for a record for that person, rejoice in finding it, then realize I’d already found it!

So in an effort to avoid that, as well help me in my never-ending quest to not feel overwhelmed about my genealogy research, this past weekend I created a series of progress-tracking spreadsheets. I was inspired by Miriam’s Census Spreadsheet, which is a Google Doc. I’m a Mac user and I used the Numbers program (similar to Excel) to create three spreadsheets (so far) that track progress, by ancestor, on finding the following records:

Sheet 1: BMD

  1. birth records
  2. marriage records
  3. death records
  4. burial records
  5. grave photos

Sheet 2: Censuses

On the first table (pictured above) I have a row for each ancestor (this is a work in progress…I’ve been adding info a generation at a time and up to my great-great grandparents), and a column for each U.S. Census. I fill in the square in blue if that record was found. A grey square indicates the ancestor wasn’t alive for that census. A blank (white) square indicates I still need to find this record. I also have a table of state censuses, so I can note those.

Sheet 3: Military

Here I track what military records I’ve found for each ancestor, by war or conflict. This one’s definitely a work in progress.

Going through this process helped me realize how much census work I’d done and how much more work I had to do to find birth, marriage and death records. I think these charts will help me feel a sense of accomplishment and also help me hone in on work that needs to be done. I’ll keep adding ancestors from Reunion, until I’m caught up, and then plan to keep up with the spreadsheet as I find more records.