This Free, Elegant GEDCOM Analyzer Is a Wonder

How does your family tree measure up? When I tried out Ancestry Pro Tools almost two years ago, I didn't care about its Tree Checker feature. I had free Family Tree Analyzer software to help me find all kinds of mistakes.

Even without subscribing to Pro Tools, my tree on Ancestry has a rating of 8.3 ("Very good"). What's keeping me from scoring a 10? A few data errors, lots of missing source citations, and what they think are 10,398 duplicate people. (They're not.)

But I found a new tool for improving your family tree rating called GEDminer that's outstanding! You've got to take a look at this thing. There's nothing to download, but you need to export your family tree's GEDCOM file first.

The instant, deep analysis of your family tree is worth a ton, but this genealogy tool is free.

GEDminer is a web-based program that's a very friendly way to see how your family tree measures up. If you're skeptical or want to see it in action first, you can view an analysis of their sample GEDCOM. Please understand your file is NOT uploaded to a server. The data processing happens in your web browser, and all the results go POOF! when you close your browser. (Your data may stay in your computer's cache memory for a while.)

Go to https://gedminer.com and drop your GEDCOM file in the box on the webpage. (The link to see sample data is beneath the box.) I dropped in my latest GEDCOM with 85,360 people. I know I'm missing tons of source citations—I'm always working on that. So where do I stand?

• My Tree Health Score is 75.33%. It says that's better than 55.56% of other users.
• I scored 74.09% in Completeness (defined as names, dates & places filled in). When I click on Completeness, it breaks this down into terrifying numbers:
  • 50,805 non-living people missing a death place
  • 47,995 non-living people missing a death date
  • 10,007 people missing a birth place. I have been putting a state or county into the birth and death place fields when I see they're empty. I have a long way to go.
• I scored 52.42% in Sourcing. This says I still have 40,616 people with no source citations. The spreadsheet I'm using for this huge task agrees!
• I scored 99.9% on Consistency (defined as free of errors & warnings). It lists 5 people with "data errors" for me to fix, but these are only a taste. They include people who were too old or young when their child was born. But the full, detailed list of data errors is in the next section.

Beneath these scores is a section called Quick Wins. This tells me my family tree has:

• 23 data errors (I worked on it and got it down to three errors, two of which are supported by the documents: an 88-year-old father and a 56-year-old mother.)
• 10,007 people without a birth place (I got it down to 9,953.)
• 40,616 unsourced people

The last two are also found above in the Tree Health Score section. But under Quick Wins, you can click these problem types and go to a new page filled with the exact details.

Click a type of error to see complete details about what you need to correct. Then export the full list as a spreadsheet and get busy.

• When you click to see your data errors in detail, the new page gives you the option of seeing:
  • All data errors
  • Date issues only
  • Age issues only
  • Relationship problems only (for me, these were all mothers who were too young)
  • Duplicate Facts only (for me, most of these are cases where I have two very different death records for people, so I recorded both)
  • Quality issues only (this would be key missing facts; I have none!)
• When you click to see your missing places or unsourced people errors in detail, the new page gives you the option of seeing:
  • All missing items
  • Line Origins only (these are the people you're stuck on—you can't ID their parents)
  • Missing Dates only
  • Missing Places only
  • Unsourced people only
  • People with no spouse (if we knew the spouse, they'd be in there, right?)
  • Missing Deaths only

Best of all, after you scroll to the bottom of a long list and click Show All, you can scroll back up and choose Export CSV. This gives you a spreadsheet to use to complete your fixes. You can tackle them one-by-one and delete them from the spreadsheet or mark them done.

I won't export my list of unsourced people since I'm already working on that. But when I'm finished with that project, I can use GEDminer again to see who slipped through the cracks.

While you're on that detail page, look close to the top of the page for four links:

• Suggestions
• Errors
• Vital Sharpener
• Tree Structure

Now:

• Click Vital Sharpener to see all the incomplete dates in your family tree. Sometimes we can't do anything about these because no records are available. But if the people are from the 1900s or later, try a new search on a site you don't use all the time.
• Now click Tree Structure right next to Vital Sharpener. These results have different categories to view:
  • Hidden Cousins tries to group together people with the same last name. That doesn't work well for my tree. Welcome to small towns in Italy.
  • Unlinked Individuals shows you the unattached people floating in your family tree. I have 184 people with zero connection to me. But they're in there on purpose. If more vital records ever become available, I may be able to connect them.
  • Duplicate Finder says I have 409 people with the same (or almost the same) name and birth year. I don't have enough information to be sure some are the same person. I'll review them and see if I can find a few that I should merge. You'll see that the list ranges in match-i-ness from 100% on down. My lowest duplicate is a 57% match, but they're worth looking into. They have the same name, same hometown, same father's name, and very close birth years.

The bonus facts this free tool displays about your family tree can be real eye-openers. And it's all interactive. Click around!

Still Not Sure? Here's the Old Way.

Before I found GEDminer, I planned to show you how you can use Family Tree Analyzer to find these errors. I'm so impressed with GEDminer, but you know I appreciate the heck out of Family Tree Analyzer. So here's what to click. You won't get your score, but you will get lists of what needs your attention. Get your GEDCOM file and open it in Family Tree Analyzer.

To find data errors, click the Errors/Fixes tab and under Data Errors select:

• Birth before father aged 13 and mother aged 13
• Birth after father aged 90+ and mother aged 60+
• Birth after mother's death and more than 9m after father's death
• Marriage before aged 13 and spouse aged 13
• Marriage after death and after spouse's death
• Facts dated before birth
• Birth after death/burial
• Birth after baptism/christening
• Facts dated after death
• Burial/cremation before death
• Child born too soon after sibling
• Child likely born too soon after sibling
• Male Wifes and Female Husbands
• Duplicate Fact
• Possible Duplicate Fact

One way to find duplicate people in your family tree is to go to the Errors/Fixes tab, choose Duplicates? then sort by Birth Date.

To find unlinked individuals, click the Main Lists tab. In the Relation column of the Individuals table, filter to select "Unknown".

Here's the report I used to make a spreadsheet of all my people who had zero source citations. Go to the Main Lists tab and find the Num Sources column in the Individuals table. Click the down arrow for that column and Sort A to Z. Filtering doesn't work, although it should. I exported the full list, then deleted everyone who didn't have zero source citations.

I hope you find this breakdown of problems inspiring and not discouraging. After you've made a good amount of corrections, go back and see the improvement in your family tree.

Taking the Next Step in Family Tree Analysis

Last week I showed you how to use a spreadsheet to gain insight into your family tree. If you're a Mac user, be sure to see the useful comments beneath that article from Mac user Mick.

In the article I challenged myself to tackle a bigger project. I wanted to use Microsoft Power BI Desktop software to further dissect the data and look for trends. I've always been a frustrated programmer, meaning I want to be good at it, but I get so frustrated! This time I got clear step-by-step Power BI instructions from Microsoft Copilot—what a lifesaver.

Working with the Data from Your Family Tree

The first step was to import my spreadsheet of everyone in my family tree into the program. The spreadsheet I exported from MyHeritage Family Tree Builder last week had problems. It wasn't possible to use that file because several rows didn't follow the format. So I exported my people from Family Tree Analyzer (old reliable). Once I imported the spreadsheet, I could see all the category names in Power BI Desktop. These include ID, LastName, FirstName, BirthDate, BirthLocation, etc.

How many ways can you think of to analyze your family tree?

Next, in Power BI Desktop's Report view, I created a table to hold all the data. I gave it some visual formatting to make it easier for me to understand:

• Bold column headers with a color background.
• Alternating white and light green rows like some ancient, pleated computer printout paper.

Note: I'm using the town of Colle Sannita in these examples because it's so complete in my family tree. About 95% of the available vital records are in my tree. The other 5% are records of people from out of town or who I can't identify.

Then I used the Filters column to the right of my table and added one data field: BirthLocation. I chose Advanced filtering, not Basic filtering. This let me filter down to any birth location that contains a certain town name, like Colle Sannita. When I click Apply filter, I can see that it's working. Hurray!

But I want to see how many people that filter includes. How many people in my family tree have I documented as being born in Colle Sannita?

I consulted Copilot to find out how I can do this. First I had to add a new function to my data fields to count the rows. The Copilot guidance used the generic title of RowCount for this. Next, to show the row count, I had to add a "card" to display it on. I did that and formatted it until I got what I wanted: a whole number with a comma to show thousands. My total count before applying a filter is 85,362 (bigger than it was last week). To make it more straightforward, I changed the function's name from RowCount to People. Now my card says 85,362 People.

Let's put it to use!

• When I filter BirthLocation to contain Colle Sannita, I have 25,120 People.
• When I filter BirthLocation to contain Baselice, I have 17,335 People.
• When I filter BirthLocation to contain New York, I have 902 People.
• When I filter BirthLocation to contain Bronx, I have 293 People.

I can do this with MarriageLocation and DeathLocation. I can do it for last names. I'll clear out my filter and drag LastName into the Filter section. I'll type my name, Iamarino, in the search box, and I see right there that I have 815 people with that last name. When I click Apply filter, the main screen shows the filtered list of people and the card says 815 People.

Getting More Specific

Now let's try two filters at once. I know there was an earthquake in Colle Sannita in 1805 that killed many people. I'm going to drag both DeathLocation and DeathDate into the Filters area. Using Advanced filtering, I'll choose:

• DeathLocations that contain Colle Sannita, and
• DeathDates that contain 1805.

Combining these filters leaves me with 54 people. I know the earthquake happened on 26 Jul 1805, thanks to Colle Sannita expert, Dr. Fabio Paolucci. I see people in this list who died well before the earthquake. I'm going to change my DeathDate filter to "contains 26 Jul 1805" or "contains 27 Jul 1805". This brings the list down to 28 people. (I can't add more than two dates, but a visual scan of the dates showed that all the victims seemed to die on these two dates.)

I created another filter to find years with very high or low death counts. I added a filter for DeathLocation that contains Colle Sannita, and one for DeathDate. I can keep changing the year and clicking Apply filter to see how many deaths there were. Here are a few results:

• 1810 had 113 deaths
• 1811 had 165 deaths
• 1812 had 145 deaths
• 1813 had 88 deaths
• 1860 had 126 deaths

I wanted to find a way to export or graph these numbers, but FRUSTRATION! My only choice would be to keep changing the filter and jot down the results in another spreadsheet. (Any programmers reading this are laughing their heads off.) I tried creating a dashboard that could show the results of various filters, but it didn't work. If I do make a separate spreadsheet, I can use Excel to turn the data into line graphs and bar charts. I have started doing this. See the image below.

It didn't take long to enter facts into a new spreadsheet to make these line graphs.

Going Deeper

Next let's try a 3-part filter. I'm wondering if the girl babies outnumbered the boy babies in my ancestral hometowns. I'll create a filter that contains a BirthLocation of Colle Sannita and a BirthDate of 1810. I'll include Gender, which shows me the Female/Male split without my having to touch it. Then I'll keep changing the year.

• In 1810 there were 199 births: 103 female and 96 male. Girls win.
• In 1820 there were 170 births: 79 female, 91 male. Boys win.
• In 1830 there were 177 births: 93 female, 84 male. Girls win.
• In 1840 there were 139 births: 71 female, 68 male. Girls win, but it's a close one.
• In 1850 there were 210 births: 114 female, 96 male. Girls win.
• In 1860 there were 206 births: 113 female, 93 male. Girls win.
• In 1870, 1880, 1890, 1900, and 1910 the boys win. Change in the water?

Now let's take a quick look at the marriages I've documented in Colle Sannita. There are two main churches, but the one in the heart of town is much older. I'll filter the MarriageLocation to those containing the older church: San Giorgio Martire. Wow! I've got 4,119 people who I know married there. I'll change the filter to show the location of the newer church in the area called Decorata. I've got 245 people who married there.

How are these both odd numbers? My guess is because of people who had more than one marriage. Only the preferred marriage appears in this database.

One more filter for the road. Italians have a tremendous reverence for the Virgin Mary, so they use the name Maria a LOT. Even the boys got Maria for a middle name. So, how many people in my family tree from Colle Sannita have a first name that contains Maria? 21,491 people!

I'd love to hear your suggestions for other ways to dissect the facts in my family tree.

Use a Spreadsheet to Analyze Your Family Tree

My family tree is an enormous database with 85,363 people. People often write to me to ask why their great grandparents are in my tree. They want to know how I'm related. Many times I'm not an actual relative.

That's when I have to explain the purpose of my family tree. I've connected entire towns through blood or marriage. Everyone in there has some type of connection to me. It's a jigsaw puzzle with no border pieces. It never ends, and I love that.

When you export your family tree to a spreadsheet, you can pull out statistics you can't get any other way.

I need to find a way to create statistics about my family tree to help explain why their people are in there. I don't see any reports in various desktop family tree software that would do the trick. The Ancestry.com version of my family tree gives a few stats in its tree overview:

• People 85,363
• Photos 11,233 (at least 10,000 are document images)
• Documents 13 (these are PDFs)
• Records 1 (no idea what that is)

That isn't what I want. If only I could use an Excel spreadsheet to sort and filter these stats to the surface.

I won't use Family Tree Analyzer today because readers point out it doesn't have a Mac version anymore. But a lot of software doesn't have a Mac version. I've been saying that since 1984.

I downloaded MyHeritage Family Tree Builder, and then found out it has no Mac version. {sigh} Let's get on with it.

Choose Your Software

First I found an article titled "5 Best Free Gedcom to Excel Converter Software for Windows". It recommended these programs you can download:

1. Gramps. This one may work on your Mac and on Linux, too.
2. MyHeritage Family Tree Builder. This has tons of features, especially if you sync it with your tree on MyHeritage.
3. ScionPC. Last updated in 2016.
4. Oxy-Gen. Last updated i 2023.
5. GEDxlate. This is so old it may not work on your Windows computer.

Export Your Data

I imported my latest complete GEDCOM file into MyHeritage Family Tree Builder. Every day I export two GEDCOM files from Family Tree Maker (my program of choice). One excludes media and notes, and one includes everything. Then I went to the Edit menu in Family Tree Builder and chose Export to Excel. I clicked Export list of people, but you can create a custom export if you wish.

The export to Excel command in any software creates a .CSV file. CSV stands for Comma Separated Values, and you can use any brand of spreadsheet software to open it. Even though your software says "Export to Excel", it is not creating an Excel file that you may not be able to use.

Open that CSV file with whatever spreadsheet software you have—even if it's Google Sheets. Then save it to your preferred format. I have Microsoft Office 365, so I saved my file in Excel's .xlsx format.

Make Your Data Easier to Use

Now you can view the results in your preferred software program. The first thing I always do is make the top row (with the column header names) bold, and freeze the top row. That way the headers are always visible as I scroll. I went ahead and made some columns wider so I could see their contents. Next, I hid a few columns I'm not going to use:

• ID
• Prefix
• Married Name (No!! Birth names only.)
• Death cause

I rearranged a couple of columns, too. I moved Last name before First name, and Gender after Suffix. I clicked Sort on Excel's Data menu and sorted my 85,363 people by Last name then First name.

Now we're ready for some statistics!

Start Filtering

On Excel's Data menu, I clicked Filter. This puts an arrow (indicating a menu) beside each column header. I clicked the arrow beside Birth place and typed Colle Sannita in the Text Filters search box. That's my paternal grandfather's hometown.

This tells me my family tree has 25,122 people born in Colle Sannita. (I can look at the bottom of the Excel window to see how many records fit in this filter.) The beauty of the filter is that it will select any place, any address, that includes Colle Sannita. That's something I can't do any other way.

I can change that filter to see that my tree has (listed from most to least):

• 25,122 people born in Colle Sannita (repeating this for comparison)
• 17,335 people born in Baselice (my maternal grandfather's hometown)
• 10,409 people born in Pesco Sannita (birthplace of a 1st great grandmother)
• 2,789 people born in Santa Paolina (birthplace of a 2nd great grandmother)
• 2,696 people born in Circello (birthplace of a 3rd great grandfather)
• 1,962 people born in Sant'Angelo a Cupolo (this town's records begin in 1861, keeping this number low)
• 935 people born in Apice (birthplace of a 3rd great grandmother)

I had no idea what these totals would be, and it's exciting to see them. I've been working hardest on Colle Sannita for a long time because I have the most ancestors there.

Now I'll use the filter on the Marriage place column. This shows me I have recorded (listed from most to least):

• 8,200 marriages in Colle Sannita
• 4,400 marriages in Baselice
• 3,914 marriages in Pesco Sannita
• 1,502 marriages in Santa Paolina
• 1,314 marriages in Circello
• 538 marriages in Sant'Angelo a Cupolo
• 338 marriages in Apice

I've been busy, haven't I? But what I see is how much work I need to do in many of my ancestral hometowns.

Filter Out More Facts

Another fact I can filter is any date (birth, marriage, or death) that includes a particular year. I typed 1855 into the text filter search box and found that my family tree has 542 people born in that year. In most of my ancestral hometowns, record keeping began in the second quarter of 1809. So how many people in my family tree were born in the first full year of civil record keeping? I'll type 1810 in the text filter search box to see that it's 581 people.

A big part of my family came from the town that started keeping records in 1861. So how many people in my family tree were born in that year? I'll type 1861 in the text filter search box to see that it's 539 people.

If I wanted to take the time, I could track trends in my towns by using two or more filters at once. I can filter to show one town and one year. This shows me that in 1860 the town of Colle Sannita recorded 206 births and 126 deaths. I've taken the time to work ALL this town's available vital records into my family tree, so those numbers are good.

Take the Next Step

I could use this data in more powerful software to report on birth, death, and marriage trends. For instance, there's Microsoft Power BI (BI = Business Intelligence), which I've used before. I've noticed that some years have a much higher death count than others. This could point to a terrible disease sweeping through the town, or an earthquake. If I were to create such a report, it would give me more insight into the lives of my ancestors.

It's been a long time since I used Microsoft Power BI to analyze my family tree. Now the software has AI features to make it easier to use. It sure sounds like I need to try it again.

Wouldn't you like to know where your family tree has the most roots? What other details would you filter for?

Your Family Tree's Top 10s

At the end of each day that I work on my family tree, I export a GEDCOM file from Family Tree Maker. Any family tree software program and some online trees give you this option. Today we'll use that GEDCOM to highlight trends in our family trees.

First, open your latest GEDCOM in the free Family Tree Analyzer program. The main screen has some interesting numbers. Here's what it finds for my tree:

• Direct Ancestors: 418
• Descendants: 2
• Blood Relations: 18,520
• Married to Blood or Direct Relation: 5,226
• Related by Marriage: 50,035
• Linked through Marriages: 10,343
• Unknown relation: 189

Let's use Family Tree Analyzer to discover the Top 10s in our family trees.

Follow a few simple steps to discover the Top 10s in your family tree.

Top 10 Jobs in Your Family Tree

In Family Tree Analyzer, click the Main Lists tab and then the Occupations tab beneath it. This displays 2 columns: Occupation and Count. Click the arrow next to Count and choose Sort Z to A. Now the list shows you the most common jobs in your family tree.

Note: If Sort Z to A doesn't look like it worked, change it to Sort A to Z and then back again. That should do the trick.

For a long time, I didn't bother adding a particular occupation to my Italian relatives. Contadino (masculine) or Contadina (feminine) is a farmer or peasant. I come from peasants. They were almost all contadini! But I have tried to add them lately. Here are the Top 10 Jobs in my family tree:

• Bracciale (farmhand or laborer), 718
• Contadino and Contadina (both mean farmer or peasant) combined, 338
• Custode di Pecore and Pastore (both mean shepherd) combined, 186
• Calzolaio (shoemaker), 109
• Sartore (tailor), 97
• Filatrice (cotton spinner or seamstress), 93
• Proprietario and Proprietaria (both mean owner, proprietor, or landlord), 101
• Tessitrice (weaver), 72
• Massaro (steward or farm manager), 59
• Massaro di Campo (farm owner), 54

I'm surprised to see that the occupations I pulled from U.S. Census records have such small numbers. Then again, I had no one in the U.S. until the 1900 census, and many of them changed jobs often. Here are the Top 10 U.S. Jobs in my family tree:

• Laborer, 14
• New Worker, 10
• Shoemaker, 9
• Farmer, 7
• Chauffeur (truck driver), 6
• Clerk, 6
• Barber, 6
• Operator at a Dress Factory, 5
• Telephone Operator, 5
• Carpenter, 5

Most of the people who make up that list lived in New York City where jobs of all types were plentiful. The farmers were my husband's relatives in California.

Top 10 Sources in Your Family Tree

If your number of sources is low, you owe it to everyone with any connection to you to work on your source citations! My family tree uses 565 different sources.

To the left of the Occupations tab, click the Sources tab. The label on the last column in this table is Num Facts. Click the arrow next to Num Facts and choose Sort Z to A. Now the list shows the most-used sources in your family tree.

Here are the Top 10 Sources in my family tree:

• State Archives of Benevento, town of Colle Sannita, 54,560 (and I have SO many more to add)
• State Archives of Benevento, town of Baselice, 8,514 (many facts still need this source)
• State Archives of Benevento, town of Pescolamazza, 7,748 (many facts still need this source)
• State Archives of Avellino, town of Santa Paolina, 6,931 (many facts still need this source)
• 1940 U.S. Federal Census, 2,509
• the book "Colle Sannita nel 1742" by Dr. Fabio Paolucci, 2,337
• State Archives of Benevento, town of Apice, 2,037
• State Archives of Benevento, town of Sant'Angelo a Cupolo, 1,827
• State Archives of Benevento, town of Circello, 1,708
• 1930 U.S. Federal Census, 1,442

As usual, Italians dominate my family tree. The #1 source is not a surprise to me, but the amount is staggering. This is the hometown of the paternal side of my family tree, and everyone's related to me somehow.

Top 10 Last Names in Your Family Tree

For this list, we can restrict the results to our blood relatives. Click the Surnames tab next to the Main Lists tab. In the Relationship Types section, choose (1) Direct Ancestors, (2) Blood Relations, and (3) Descendants. Now click the Show Surnames button. This will take a while to display if your family tree is very large. Watch the progress bar in the lower left corner of the program to see that it's working.

Once your table displays, click the arrow next to the Individuals column and choose Sort Z to A. Now you can see the most common names in your family tree. Here are the Top 10 Last Names in my family tree:

• Pozzuto, 889
• Mascia, 861
• Zeolla, 833
• Martuccio, 772
• Piacquadio, 673
• delGrosso, 562
• Iamarino (my maiden name), 489
• Pilla, 481
• Palmiero, 472
• Basile, 382

Every one of those last names comes from Colle Sannita. Three or four are also found in my other ancestral hometowns. This list surprises me because I restricted the results to blood relatives. The results look very different if I include spouses and their families.

Now try this. Clear the sort from the Individuals column and sort the Families or Marriages columns from Z to A. For me, the Families have the same Top 10 Last Names, but in a different order. The same is true for the Marriages column—same names, different order. Is that true for your family tree?

Top 10 Treetops in Your Family Tree

A "treetop" is the eldest person on each branch of your family tree. They represent the furthest back you've gone with your research. Click the Treetops tab that's way to the right of the Surnames tab. In the Relationship Types section, choose (1) Direct Ancestors, (2) Blood Relations, and (3) Descendants. There are 2 more options that are pre-chosen, and you can leave them that way:

• Include Unknown Countries in Treetops Filter
• Include Individuals that have only one parent known

Now click the Show People at top of tree button.

This table loads fast, and at the bottom left I see my tree has 284 treetops. Let's see which last names can boast the deepest roots in our family trees. Click the arrow next to the Surname column and choose Sort Z to A.

In my family tree, some of my treetops are living DNA matches. I chose to research only the side of their family that's related to me. To filter these people out, let's restrict the results to direct ancestors only. Leave the Surname sort in place. Over in the Relation column, click the arrow and choose only Direct Ancestor.

Here are the Top 10 Direct Ancestor Treetops in my family tree, sorted by last name:

• #1: Zullo, Giuseppe. He's my 6th great grandfather born about 1711.
• #2–10: Zeolla, born as early as about 1646. They are my 4th through 9th great grandparents. Talk about deep roots!

It's only now, looking at these results, that I realize how important the name Zeolla is in my family tree. The 4 names I grew up knowing are way down the list:

• Iamarino, my maiden name, has four 7th and 8th great grandparents at the treetop. The Iamarino name was in the town of Colle Sannita for centuries, but never in huge numbers.
• Leone, my maternal grandfather's name, has one 5th and one 6th great grandparent at the treetop. The Leone name was in the town of Baselice for centuries, but in very small numbers.
• Sarracino, my grandmother's father's name, has one 5th great grandfather at the treetop. This family came from a very small town that didn't start keeping civil records until 1861. Discovering that fact was a devastating blow.
• Saviano, my grandmother's mother's name, has one 3rd great grandfather at the treetop. The Saviano family came from the same undocumented town as the Sarracino family.

I'm sure you'll find surprises when you generate your Top 10 lists. You may even uncover areas that need your research attention. I'd love to hear what you've found and if any of the names or towns I've listed mean anything to you. Please leave a comment below.

Do You Need AI Guidance for Your Family Tree?

An article in "Who Do You Think You Are" magazine looks at the research guidance feature in Legacy 10 software. (This software is 100% free at legacyfamilytree.com.) This feature is like having a professional genealogist sitting beside you saying, "Have you looked here yet?"

From what I can see, this feature is like the benevolent AI of the 1980s. People are wary of AI now because it's eliminating jobs for humans and creating false imagery. But Artificial Intelligence has been around for a long time.

Your self-built genealogy intelligence can rival any artificial intelligence for working on your family tree.

In 1986 I was a copywriter for a computer software company. I wrote a brochure and article about their new AI software called MINDOVER. It used AI to track mainframe computer systems and predict problems before they happened. I was so intrigued that I tried to write an AI program about a favorite subject of mine: architecture. The first step was to build its knowledge base. I entered the names of architectural styles and the features each one included. The software then asked a question like, "Does the building have this feature?" Based on your answer, it narrowed down the style asked the next logical question.

You're already using your own intelligence to build your family tree. That intelligence comes from your experience. And it grows in value each time you work on your tree. That intelligence might look something like this. Let's say a family member tells you they think your relative married in New York City in about 1920. What can you do to prove this? You might:

• Search for the couple in the U.S. Federal Census in 1920, 1930, 1940, and 1950 to narrow down the year they married.
• Search for the couple in the New York State Census of 1925 for any more clues.
• Search the "New York, New York, U.S., Marriage License Indexes, 1907-2018" database for the date of their marriage license.
• Search the New York City Municipal Archives for the marriage certificate. (See Day 5 in "7 Days to a Better Family Tree".)
• Search their local newspapers for a marriage or engagement announcement.

If this process makes perfect sense to you, then your own genealogy intelligence is doing a fine job. But if this whole concept is brand new to you, the AI research guidance feature may be the kick-start you need.

If you don't want to switch to Legacy 10 software, you have 3 options:

1. Install Legacy 10 and import your GEDCOM file. Follow its research suggestions, but record the data in your family tree software. Or,
2. Use Family Tree Analyzer to show you which types of documents you're missing. Or,
3. Learn which resources are available and search every one that applies. For example:
   • Which censuses are available for the country where a particular relative lived?
   • Which vital records (birth, marriage, death) are available for their location?
   • If the person emigrated, can you access their ship manifest to learn more?
   • Can you find their naturalization records?
   • Which military records are available even if the person never served in the armed forces?
   • Are there city directories for the place where they lived?
   • Is their school yearbook online?
   • Was this person ever mentioned in their local newspaper? You may find a birth or marriage announcement, an obituary, or a human interest story.
   • If they traveled, can you find their passport application?

Once you've run through every possible type of record, you have built your internal knowledge base. You can refresh your memory on the types of documents available by doing what I did to write the list above. Consult your file folders.

The FamilyTree folder on my computer has sub-folders for different types of documents. These include:

• applications
• census
• certificates (that's vital records)
• city directories
• draft cards
• immigration
• military records
• naturalization
• newspapers
• passports
• yearbooks
• and a few others.

If you're new to this hobby, go to your favorite genealogy website and search for a person. Take note of the results page and the types of documents it offers to you. Ancestry has a feature on their search results page called "Browse by collection". This makes it easy to see the types of documents in the results.

I did a search for my great grandfather who came to America several times but always went home to Italy. The collections in his results included:

• Census & Voter Lists
• Birth, Marriage & Death
• Military
• Immigration & Emigration
• Directories & Member Lists
• Court, Land, Wills & Financial
• Family Trees

These results were not all for my great grandfather—some were for men with roughly the same name. But this is a good way to get familiar with the main types of records available. Then it's a matter of looking at what you have for a person, and using logic to decide what else you may find.

I've written several times about my Document Tracker spreadsheet. The overwhelming size of my family tree made me abandon this tool. But if you're new to family tree building, this spreadsheet is a great substitute for AI. It's pre-built intelligence that will help you gain the experience you need.

Are you using the research guidance feature in Legacy 10? If so, please share your experience in the comments of this article.

How to Find Location Errors in Your Family Tree

I love how family tree software uses predictive typing to keep us consistent. Predictive typing is a software feature that suggests words or phrases as you type. It can save you keystrokes and avoid typos.

I take advantage of this feature when entering addresses in my family tree. Why type out the full church address (Chiesa di San Leonardo Abate, Via Roma, 6, Baselice, Benevento, Campania, Italy) when I can type is "chiesa di san l" and choose the matching result?

But I've been adding facts to my family tree since 2002. I'm sure I've made mistakes. The places in our family tree need us to review them.

Let's see how the free Family Tree Analyzer (FTA) can help us find mistakes and inconsistencies.

Make that genealogy map work for you! Use this tool to find inconsistent place names in your family tree.

Your first step when using FTA is to generate your tree's latest GEDCOM file. If you use desktop family tree software, you can export a GEDCOM file from your software. If you work on your family tree online, go to your tree and export a GEDCOM file from the website.

Now open your GEDCOM in FTA and give it a moment to load. Then click the Export menu and choose Locations to Excel. This will open a spreadsheet in the generic *.csv format on your computer. Since I have Excel software, I'm prompted to save it in the Excel format right away.

Because genealogists love maps:

• Collect Important Family Places to 'Tour' Anytime
• 3 Spring Cleaning Tasks for Your Family Tree
• Without Vital Records, What Can You Do?

Get Your Places in Order

If your spreadsheet software allows, sort the contents by Country, Region, Subregion, Address, and Place, in that order. Scroll through and scan your spreadsheet for anomalies. Look for anything that strikes you as being a possible mistake. Highlight the suspicious Places in yellow so you can find and act on them later.

Here's one surprising thing I found. Looking at the town of Santa Paolina, Italy, I noticed two different church addresses. I thought I knew which one of them was wrong. But when I went to Google Maps, I realized I'd been using the wrong church name and address for this town! The bad information comes from an Italian parishes website I use often. From now on I'll have to double check its facts on the map.

Did a bad address creep into your family tree? I had one that came from a "reliable" source!

I switched to Family Tree Maker and looked at the Places tab. When I located the now-wrong church information, I was ready to make the correction. Here it's easy to overwrite all uses of the wrong address at once. With a copy and paste, I changed them all to the correct church name and address. This eliminated the wrong church from my family tree file. That will prevent the wrong church from showing up in predictive typing, too.

If your family tree is online only, open your GEDCOM file in your favorite text editor. This is how you'll see where you used the bad address. Search the entire file for the street address in question.

If the place is part of a birth, baptism, death, or residence fact, scroll up until you see a line beginning with 1 NAME. This shows you the name of the person in your family tree who needs you to fix this address. But if the address is part of a shared fact, like a marriage, look just above it for a line beginning with 1 HUSB or 1 WIFE. Copy either of their ID numbers (e.g., @I30048@) and scroll to the top of your GEDCOM file. Now search for another instance of that ID. I found a line showing 0 @I30048@ INDI. The very next line gave me the name I needed, 1 NAME Rocco Enrico /Gambino/.

Focus on the Street Address

There's another way to sort the Locations spreadsheet that will be useful to you. Try a new A to Z sort on the Place column only. When I did this I noticed three entries for 210 Ridgewood Avenue. Each one was in Allegheny County, Pennsylvania. But they all showed different towns: Bellevue, Pittsburgh, and West View. What's going on there?

Use this free genealogy tool to find location errors in your family tree. Fix them and improve your consistency.

I looked for the street address in Family Tree Maker's Places tab, but you can search your GEDCOM file, too. All three instances belong to one man. His 1930 and 1940 censuses say the address is in the West View Borough of Pittsburgh. His World War II draft registration card says it's in Bellevue. His 1950 veterans compensation application says it's in Pittsburgh.

On Bing Maps* and Google Maps, I found that 210 Ridgewood Avenue is part of the West View borough of Pittsburgh. The front window of the nearest U.S. post office (seen on Google Maps) says, "West View Branch, Pittsburgh, PA". I'll use 210 Ridgewood Avenue, West View, Allegheny County, Pennsylvania, USA, as the location. This puts a very accurate pin in the map within Family Tree Maker. The pin is right at the front door.

* I love Google Maps for its Street View, but Bing Maps points out the county or province and gives you the full information.

But why does his draft registration card say Bellevue? They wrote his address as 210 Ridgewood Ave., Bellevue, Allegheny Co., Penna., twice. On Google Maps, I found another Pittsburgh borough of Bellevue. It's right near West View, but it doesn't have a Ridgewood Avenue.

The logical answer was on the back of the draft card. The local draft board itself was not located in tiny West View, but in tiny Bellevue. It may have been a clerical error, or else that's how they were recording everyone they registered.

Without Family Tree Analyzer, there's only one way I could have found this discrepancy. I'd have to be looking at this man's list of facts in my family tree. Since he's the father-in-law of my 3rd cousin, that might never have happened. I'm glad to be able to sort this out today so I can see this cute little house in Google Street View.

I'm eager to work with this spreadsheet and add consistency to all my addresses.

Have Your Genealogy Plan B Ready to Go

My missing source citations project has exciting side effects. Revisiting some people uncovers my past errors. And sometimes I can merge two people because I found solid evidence that they're the same person.

Imagine how upset I was when I couldn't work on this project for about a week. A programming error broke the website I need the most for gathering source citations!

I needed a Genealogy Plan B so I could stay productive. Sometimes I go to Plan B late in the day when I'm getting tired of source citations. My usual Plan B is renaming the entire set of vital records I downloaded for my 3rd great grandmother's hometown of Apice. I've made tremendous progress, but I've got a ways to go.

The only problem with that Plan B is it makes me feeling like I'm neglecting my family tree. I needed something else. A Genealogy Plan B+ or a Plan C.

Take advantage of your GEDCOM file to see exactly who needs more research.

I don't remember which train of thought led me to it, but here's what I did. And it was super productive and fulfilling.

Eighty-five people in my tree have a special note in their birth date description field. It says their father was in America when they were born. This note is on their Italian birth records because it was the father's duty to report the birth. If he was away, the midwife or a grandparent would report the birth. Since this isn't the norm, they included an explanation. The reasons I've seen include:

• the weather was too bad to bring a newborn into town
• the father was ill
• the father was dead (look for a date!)
• the father was working somewhere in the countryside
• the father was out of the country, often in America.

Whenever I see that the father was in America, I add a stock phrase to the birth date description field:

• Her father was in America when she was born, or
• His father was in America when he was born.

Last week, searching for these fathers this became my Genealogy Plan B. I opened my GEDCOM file in Notepad++. This software has a GEDCOM language filter that makes the huge file easier to understand. I searched for every instance of "was in America".

One by one, I found these people in my Family Tree Maker file and began researching their father. Almost all were men who I didn't know had gone to America. I found their immigration records first. Then I searched for more U.S. documents, like draft registration cards and censuses. Sometimes I learned that they brought over their family and stayed here.

Many of the U.S. documents led me to discover later generations for the first time. I found distant cousins I didn't know existed. In some cases they had lived close to me.

After a few days of following my Italian cousins to America, I was still eager to return to source citations. Each morning I checked the Antenati site. On July 18th the website worked again!

Getting back to Genealogy Plan A, I had 2 productive days of citing sources for more than 100 people per day.

Not everyone is as driven as I am to be productive every day. But if you have more than a casual interest in your family tree, consider working on projects. Choose projects that will improve your family tree with every step you take.

Here are some project suggestions you may want to use as your Genealogy Plan A, B, and C:

• Collect missing census records and cite them immediately.
• Search for immigration and naturalization records and cite them immediately.
• Gather draft registration cards for every eligible man and cite them immediately.
• Try to fill in missing dates and cite them immediately.
• Add those missing source citations!

If your family tree has more than a handful of people, you'll need help figuring out what's missing. My tree is so vast, I abandoned my Document Tracker, but it's a great tool for seeing what you have and what you need. I used it with great results when the 1940 U.S. census came online, and a bit for the 1950 census.

Use the free Family Tree Analyzer to find missing fact types and missing censuses in your family tree.

Family Tree Analyzer offers an efficient way to see who's missing their census data. Here's how:

• Use Family Tree Analyzer to open your GEDCOM file.
• Click the Census tab.
• Choose the Relationship Types you want to search. You could restrict the search to closer relatives or test the entire file.
• Choose a census year for the UK, US, or Canada.
• Click the button labeled Show Not Found on Census.

A new window shows you who should be in the census you selected, but is missing that census citation. You can download the results as a spreadsheet and work through them.

The report works very well except when you have no mention of a country for someone. I have some English people in my tree, so I wanted to see the report for who's missing the 1881 UK census. It included a bunch of Italians for whom I have no country entered. I need to give them Italy as a place of birth even if I don't know their town. That's another project that can add value to your family tree and mine.

As for missing or incomplete dates, you have two good options. Option 1: If you use any type of desktop family tree software, sort your index list by birth date. Now you can see who has no birth date (they'll be at the bottom of the list) and who has an incomplete or estimated birth date.

I always enter an estimated birth date if a document isn't available. My rule of thumb is this:

• If you know their spouse's year of birth, give them about the same year (e.g., Abt. 1886).
• If you know the year their eldest child was born, subtract 25 and make that their estimated year of birth. This will prevent you from confusing two people with the same name who were born many decades apart.

Option 2: If your family tree is online only, go to the website where you keep it and download your GEDCOM file. Then:

• Use Family Tree Analyzer to open your GEDCOM file.
• Click the Facts tab.
• Choose the Relationship Types you want to search. (Choose them all.)
• Next to the long list of fact types, click the button that has a right arrow on it. This opens up a second long list of fact types.
• Click to select Birth in the second list.
• Click the button above that list. It's labeled, Show all Facts for Individuals who are missing the selected excluded Fact Types.

I'm happy to see that no one in my 84,044-person family tree is missing a birth date. I try to check each day to make sure I didn't add someone and forget to enter their year of birth.

I hope you're feeling inspired to choose a project or two to fortify your family tree. Here are some other value-packed projects to try:

• Another Way to Find Errors in Your Family Tree
• How to Find Distant Cousins on Facebook
• Taking the Time to Take Care of Our Own
• Work in Sprints to Strengthen Your Family Tree

Divorce Laws and Your Family Tree

How many divorces are in your family tree? It isn't an easy question to answer if you haven't entered divorce dates.

My 83,974-person family tree has 40 divorce facts for 39 individuals. To find your numbers:

• Open your GEDCOM file in Family Tree Analyzer.
• Choose the Facts tab.
• Selected Divorce.
• Click "Show only the selected Facts for Individuals".

Was divorce even possible for the people in your family tree?

I know the real number is higher. I don't have a Divorce fact for many of my cousins' divorces.

The number is also low because the vast majority of people in my family tree were born in Italy before 1916. (The birth records available online end in 1915.) Have you ever heard of the 1961 Italian movie "Divorce Italian Style"? Divorce wasn't legal in Italy until the end of 1970. But there was another law on the books that Marcello Mastroianni's character tried to use in the film.

The very idea of this law is shocking. Up until 1981 it was allowable to kill a woman (and only a woman) for being unfaithful. To kill her! They called it an honor killing. In the film, Mastroianni's character tried to lure his wife into being unfaithful. But she refused to do so.

The lack of legal divorce in Italy before 1970 means two things for an Italian family tree:

• If a person remarried, you can assume their 1st spouse died, even if the death record is unavailable.
• There were children born out of wedlock each year. Divorce wasn't legal, but affairs were okay—especially for men.

Let's take a look at when divorce became legal in several countries. Some of the dates are later than you might think, and some are way earlier than I expected. Religious institutions imposed many of the restrictions on divorce laws. There's also a distinct trend toward giving men all or most of the power.

More interested in marriage facts than divorce facts?

• How to Understand Your Ancestors' Marriage and Remarriage Customs
• Report Finds Marriage Mishaps in Your Family Tree
• Did Your Ancestors Have Arranged Marriages?

Two definitions first:

• No-fault divorce means you don't have to provide proof of your spouse's fault.
• Unilateral divorce means one spouse can end the marriage without the other's consent.

Which of these dates affect your family tree?

• Argentina: Separation became legal in 1888; divorce 99 years later in 1987. An updated 2015 law removed the required separation period.
• Australia: The Family Law Act of 1975 went into effect in January 1976 legalizing divorce.
• Brazil: Divorce became legal in 1977. An updated 2010 law removed the required separation period.
• Chile: Divorce became legal in 2004.
• Denmark: Divorce became legal in 1969 with a required six-month separation period.
• England and Wales: Divorce became legal in 1857, but there were limitations. There had to be proof of infidelity, cruelty, rape, or incest. In 1923, a woman could sue for divorce, but she faced a higher burden to provide proof of fault. The process became much easier in 2020.
• Finland: Divorce became legal in 1988 with no required separation period.
• France: Divorce had a bumpy road in France. It was legal in 1792, repealed in 1816, reinstated in 1884, and overhauled in 1976.
• Germany: Divorce became legal in 1977 with a required separation period.
• Greece: No-fault divorce became legal in 1979. In 1983 Greece allowed unilateral divorce with a required separation period.
• Ireland: The Family Law Act of 1996 was the first significant law allowing divorce. Before that, the country's 1937 Constitution barred divorce.
• Italy: No-fault divorce became legal in 1970. Unilateral divorce with a required separation period became legal in 1975.
• Mexico: Divorce became legal in 1915, but it is still not common. In the 1950s and 1960s, many Americans traveled to Mexico for a "quickie divorce".
• Norway: Unilateral divorce became legal in 1993 with a required separation period.
• Portugal: Unilateral divorce with a required separation period became law in 1976. In 2008 the country abolished fault-based divorce making the process easier.
• Spain: Generalissimo Francisco Franco (still dead) overturned the divorce laws of the early 1930s. Divorce was illegal from 1938 to 1981. In 2005 the country instituted unilateral divorce with no required separation period.
• Sweden: Fault-based divorce became legal in the 1600s. The country passed mutual agreement divorce in 1915, and unilateral divorce in 1973.
• Switzerland: Unilateral divorce with a required separation period became legal in 2000.
• United States: In 1629 the Massachusetts Bay Colony created a judicial tribunal for divorce. Laws vary by state throughout the country.
• Uruguay: Divorce by mutual consent became legal in 1907; divorce by the sole will of the woman in 1913. That's unique!

If you have people in your family tree with more than one marriage, take another look at them. Depending on the place and year, you may be able to infer the death of the first spouse before the 2nd marriage.