This Genealogy Report Shows You What's Missing

Update: Family Tree Analyzer is now available for Mac.

How would you like a tool that shows you exactly which census forms you haven't found for each person in your family tree?

Sound like a time-saver? You'd better believe it is. Let's take a look at the Census Report tool in the free software program, Family Tree Analyzer (FTA). (See their website for the free download and their Facebook page for support.)

This is a simple process of (1) open file, (2) run report, (3) work with your results.

Before You Start

An approximate birth year and country of
birth will give you the best results.

Learn from my experience and get better results:

• Enter an estimated birth date for everyone in your tree. When you don't know someone's date, make them about 25 years older than the oldest child you've found for them. There's a big difference when searching for someone born in 1850 vs. 1900.
• Enter a country of birth and death whenever possible. Say you've researched several generations of a family and they stayed in one area. If someone's children never emigrated, assume the person was born and died in that country. Add a note that this is not verified.

Now the FTA Census Report will be much smarter and you'll need to do very little editing of your Census Report.

Open Your Data File

Once you install FTA, all you need is your tree's latest GEDCOM file (see the definition). Check your software's File menu for an Export option. If your tree is on Ancestry.com, but not on desktop software, go to your Tree Settings online. Find the green Export tree button. Some websites believe in one shared tree. That means you don't have full control of your tree, and you cannot download a GEDCOM. The control freak in me can't imagine going that route.

Launch FTA and open your GEDCOM file.

Run the Census Report

To run a report showing which census records you're missing:

Make 2 selections and click "Show Missing from Census" to run the report.

1. Click the Census tab at the top.
2. Check the boxes for the Relationship Types you'd like to include in your report:
   
   • Direct Ancestors
   • Blood Relations
   • Related by Marriage
   • Married to Blood or Direct
   • Unknown
3. Choose a census report from the Census Date menu. You'll find:
   
   • UK Censuses from 1841–1911
   • the UK National Register of 1939
   • Ireland Censuses for 1901 and 1911
   • US Federal Censuses from 1790–1940
   • Canadian Censuses from 1851–1921
   • Scottish Valuation Rolls from 1865–1925
4. Click the button labelled Show Missing from Census. Your report will open in a new window.

Your report is ready to export to Excel. Notice the status line at the bottom of the report. You can double-click an entry from this report view to go to FamilySearch and find the census you're missing.

FTA is smart. It knows if someone in your tree was alive and living in the right country for a particular census. By default, it doesn't search for anyone over the age of 90, but you can change that.

Now that you have the report, click the Excel icon at the top of the report window. Save the file to your computer in the default CSV (Comma-Separated Values) format. Now go back to step 1 and repeat the process for each census year you need.

Analyze Your Results

Now it's time to work with the data. I found a small number of people who didn't belong in this report. So before you start working through people one line at a time, let's check a few things.

To work with your report more easily, hide the spreadsheet columns you don't need right now. To hide a column, click the letter at the top of the column, like G. This will select the whole column. Then right-click the selected column and choose Hide from the menu.

The most important columns to keep visible are:

• CensusName (a married woman's maiden name is in parentheses)
• Age
• BirthDate
• BirthLocation
• DeathDate
• DeathLocation

The first people I'll look for have a birth location and death location in another country. I see only a couple of people who match this description. The first one is a familiar name: Domenico Sarracino. I know he never came to America, so I can remove him from this report.

Next I want to remove everyone with an unknown birth and death date. I know that in my family tree, these are most likely relatives of relatives. I might know nothing beyond their names. They shouldn't be my focus, so I'll remove them from my spreadsheet.

Finally, I'll sort the entire spreadsheet by the CensusName column. Now I can scroll through the names and remove duplicates. I found about 15 people who appeared to be duplicates with the same name and birth date.

One more step. For each name in the spreadsheet, I'll check their entry in my family tree. I quickly spot some more who I know never came to America.

The reason FTA doesn't know they never left Italy is that my birth and death dates don't always say they were born or died in Italy. I didn't want to make that assumption, but now I think I'd better. When it's a safe assumption, I'll put in the country and add a note that this is not confirmed.

More lines deleted.

Now I have a list of 120 people who need me to find them in the 1900 U.S. Federal Census. That may sound like a lot of people, but my family tree has almost 20,000 people. It's about 0.6% of my total tree. That sounds manageable. And finding those missing census forms will make my tree that much more valuable.

I'm ready to begin searching for those census sheets. I'll whittle down my list as I go, keeping track of my progress. Then it's on to the census reports for 1910, 1920, 1930 and 1940.

Go Fill in the Blanks

Now you're ready to make targeted searches for those missing census sheets. Family Tree Analyzer is a must-have if you want to make your family tree your legacy.

Want a cheap thrill? When you're done, create a new GEDCOM and run the report again. Look at your results!

And speaking of Family Tree Analyzer:

• How to Find Errors in Your Family Tree
• How to Handle the Unrelated People in Your Family Tree
• Use This Tool to Discover Family Tree Insights

6 Ways to Add Another Generation to Your Family Tree

When you started building your family tree, you may have known only your 4 grandparents' names. What fun it is each time you discover a relative's parents' names. You've added another generation to your tree!

Here are 6 places to look for the names of that previous generation. Some may surprise you.

1. Census Sheets

Look closely at each member of your relative's household in each census. You may find the Head of Household's mother, father, mother-in-law, or father-in-law living with the family. The best find is the male head of household's father-in-law. Now you've got the wife's maiden name!

2. Draft Registration Cards

If your male relative was single and the right age, his draft registered card may name his father or mother as his nearest relative. In this example, Tony Jr. is not his real name—it's Anton Jr. But this card is evidence that he is, in fact, named after his father.

The draft registration card for a single man may give you his mother or father's name.

I'd heard stories about "Uncle Anton" from my mother-in-law. When I found this card, I realized his father's name was Anton, too.

3. Ship Manifests

If your ancestor emigrated during a particular span of years, you're lucky. Their ship manifest may include a column labelled, "The name and complete address of nearest relative or friend in country whence alien came."

Your relative may give the name of their spouse. But an unmarried traveler may name their father or mother.

Your immigrant ancestor's ship manifest can tell you their hometown—and their parent's name.

This is my grandfather Adamo naming his father Giovanni as the relative he's leaving in his town of Baselice.

4. Social Security Applications and Claims Index

A while ago I found a collection on Ancestry.com called "U.S., Social Security Applications and Claims Index, 1935-2007".

If your relative worked in the United States after the 1935 founding of the Social Security Administration, they should have Social Security records. Hopefully you're already familiar with the SSDI—the Social Security Death Index. That can give you dates and places of birth and death.

But the Applications and Claims Index can give you much more! With some luck, you can learn the decedent's father's name and their mother's maiden name.

Plus, if you're looking up a female relative by her birth date, you can learn her married name.

5. Passport Applications

If your relative was a U.S. citizen going to another country at a certain time, they needed a passport. These applications can be a treasure trove. And you even get a photo.

Here's some of what you might learn about your relative:

• birth date and place
• address
• occupation
• father's name, birth date or age, birthplace and address
• wife's name

If the applicant is a married woman, you'll get details about her husband rather than her father.

A passport application provides lots of names, dates and places you need.

This example is from a relative named Walter Smith. It provides birth dates and countries for Walter, his wife Elizabeth, and his father George. It also says when he sailed from Liverpool to the U.S., and on which ship. The next page has photos of Walter and Elizabeth.

That's some valuable info when you're researching a guy named Smith!

6. Vital Records

Of course all genealogy fans want to find their ancestor's birth, marriage and death records. Keep in mind that:

• The parents' names on a birth record should be pretty reliable. But either parent may be using a nickname rather than their true, full name.
• All information on a death record is obviously supplied by someone other than the person who died. What if the decedent is an 85-year-old who was born in another country? Will their child, who's supplying the information, know the correct spelling of their grandparents' names? What if they never even met those grandparents?
• If the couple getting married is pretty young, you can have more confidence in how they list their parents' names. (The "nickname" rule still applies.) But if the couple is older—2 widows getting remarried—the information is more likely to have an error.
• If your couple got married in the same little town where they were born and raised, the clerk writing the names is more likely to get them right.

The lesson to take away is this: Don't give up on that previous generation if you can't get your relative's vital records. You have 5 other types of records to find, each of which can help you fortify your family tree.

And speaking of adding generations:

• How I Gained 2 More Generations in 1 Day
• How to Find More Great Grandfathers for Father's Day
• Step-by-Step Discovery of My 5th Great Grandparents

5 Things to Learn from Your Ancestor's Yearbook

I hope your ancestors weren't like me. In high school I didn't join any clubs, and I played no sports. My yearbooks won't tell you much about me. Except that I'm a nerd because I was in the National Honor Society.

When my husband (the former high school track star) told me about all the sports his father Ben played, I wanted to find Ben's yearbook. So I searched Ancestry.com and found the 1934 yearbook from Sanger High School in California. That was the year Ben's older brother Abe was a senior, Ben was a junior, and their brother Bill was a freshman.

My father-in-law, center, as a tough
17-year-old student.

If you can find your ancestor's high school yearbook, here are 5 key things to look for.

1. Which Sports They Played

I found photos of all 3 brothers on different teams:

• Abe played basketball and ran track.
• Ben played basketball, ran track, and played football.
• Bill played basketball and ran track.

Their faces in each sports photo told me a lot, too. Ben looked determined and angry—nothing like the kind man I knew. Abe looked confident and pleasant. Bill looked sweet and shy.

2. Which Clubs They Joined

Bill grew up to be an accountant, so we weren't surprised to find him in the Scholarship Society and the Latin Club. But finding Abe there with his little brother in the Latin Club was a surprise. We think Ben was too busy with sports to pick a club.

My husband's uncles, Bill and Abe, standing together in the back row of the Latin Club.

Maybe your ancestor was in all the school plays. Does that match what you know about them?

3. Who Their Friends Were

In my own high school yearbook the seniors included a quote or a few words. My words seem like utter nonsense. But if you read what everyone wrote, it becomes clear who my closest friends were. We all used the same bizarre phrases.

Look at the candid photos, too. If you find your ancestor goofing around with some other students, try to find them in a class photo and identify them.

4. What Ambitions They Had

In some yearbooks, seniors will write what their plans are. They may say where they're going to college and what they'll study. Maybe they're joining the military. Or they may say which trade or profession they're about to start.

Will you be surprised by what your ancestor was planning to do?

5. What Their Community Was Like

My father-in-law's yearbook includes advertisements from several local businesses. The names of the businesses and their owners reflect a variety of ethnicities. Yet they don't match what I see in the student photographs.

The Sanger High School students in 1934 were about 45% Japanese, 20% Armenian, and a mix of English, Irish and Scandinavian. Of course I spotted the one Italian kid.

My husband's Uncle Abe and father Ben on a pretty short basketball team.

It may tell you something about your ancestor if you learn they were in a small minority. Or that they were part of a large group.

More than all these facts, it's the photos I'm thrilled by. I love having so many never-before-seen photos of my father-in-law and 2 of his brothers as teenagers.

If you can access Ancestry.com, search for their "U.S., School Yearbooks, 1900-1990" collection. There's also Classmates.com and other sites that may have what you need.

Ancestry has 3 of my father's Bronx, New York, yearbooks, and now I know he was in the school band with my godfather—his future wife's 1st cousin. How cool a discovery is that?

And speaking of photos:

• How to Increase the Value of Your Family Tree Images
• Picturing America Through Your Ancestors Eyes
• 1925 Death Photo Holds a Clue to My Ancestor's Life