Genealogy spreadsheet

Spreadsheets are perfect for genealogy research to help organize, manage, and visualize discoveries and progress.

Genealogy's Star: Using Microsoft Excel® in Genealogy

Research Goals - Genealogy Do-over week 2 | Gathering Branches of My Family Tree #genealogy #gendover

I have group sheets written in Excel – which I love. But I’ve moved more to group sheets written in Word because I love the ability write my citations easily and to keep them well orga…

Genealogy lends itself well to forms. Forms to organize our information, to see where our holes are, to gather like information, and many other reasons. Excel is a great tool to use to organize your information, because if you can't find a form to suit you, you can use Excel and make your own. Here are the different ways I have used Excel in genealogy: 1. Timelines: I love timelines. I make a timeline for a person (usually a man because there's more information). I put the left column as…

The creator of House Elves Anonymous teaches you how to create a 12 generation pedigree spreadsheet for your genealogy research, using only free software.

Did you know you can import results from an Ancestry.com search directly into an Excel spreadsheet? Think of the many ways you could use this technique to create a data set and then manipulate it...

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 […]

Buy all 40 CensusTools spreadsheets for only $13.95! Buy CensusTools CensusTools provides researchers with quality forms to electronically record, preserve and archive family history data. Our census templates for Excel spreadsheets are fillable census forms that allow you to type your census data directly into a spreadsheet laid out in the same format as the Read More »

There’s a simple way you can make your ancestor’s timeline more interesting and more useful. Add hyperlinks! If you’re like me, your timelines probably include dates when your ancestor...

Download a free Genealogy Research List Template for Excel or Google Sheets. Track your work, make notes, create a basic timeline.

When I began my quest to find certain cemetery stones, it was almost like a rain shower, each cemetery had so many of my direct ancestors, plus siblings and other children. Back then I didn't have a digital camera, as a result, I only took photos of my direct ancestors. The process was to buy the film, take it to be developed and return later to pick them up. Then had enlargements of my favorite shots made as 8 x 10s. My husband and I went all over Massachusetts, Connecticut, a few places in…

Genealogy Excel and Word Group Sheet Templates

If you are anything like me, you have binders and file folders full of records, memorabilia, research, etc. on the many branches of your family tree.

Dig deeper in your research to find hidden gems at these four free and underused genealogy websites.

A well-organized spreadsheet is best for making records searchable.

Last year I worked on going over my genealogy with the "Genealogy Do Over". In particular I liked listing out my research goals. Well, here I am a year later, and have done a lot of work on my goals. I finished up the genealogy photobook for my mother, and did a lot of research for it. Here is a photo of my spreadsheet at the beginning of last year: And here is a more recent shot of it: As you can see I have filled in some more of the squares. While there are still more empty spaces than I'd…

Airtable is an excellent, free, cloud-based spreadsheet program that makes creating and maintaining genealogy research logs a pleasure.

The top five useful gadgets for genealogists to effortlessly help them with their family history research and data collection.

Sheet_Example