I first wrote about using a genealogy Document Tracker in January 2017. It's an efficient way to track your progress and guide your research. At a glance, it shows which documents you have and which you're missing for each person. But I haven't mentioned it in a long time.
Why? It became impractical when my family tree got too big. Today my tree has 86,566 people. About 83,000 of those people lived and died in Italy. I'm lucky to have access to many of their birth, marriage, and death records, but I can't expect to get anything else.
Filter the List As Needed
If I can reduce that list to people were in the United States, I know there will be documents to gather. Here's how I can filter my list of people to show only those with a birth, marriage, or death in the United States.
- Each day I work on my family tree in Family Tree Maker, I export a GEDCOM file. I opened the latest GEDCOM in Family Tree Analyzer.
- I clicked the Export menu and chose Individuals to Excel. This created a spreadsheet I saved to my desktop.
- After converting the file from CSV format to Excel format, I deleted many of the columns, leaving only:
- Surname
- Forenames
- BirthDate
- BirthLocation
- DeathLocation
- MarriageLocation
- I went to the Data menu in Excel. I filtered the spreadsheet to show birth locations that included "United States". This hid all the other lines. I selected the visible rows and gave them a yellow color.
- I removed that filter and showed death locations that included "United States". Many of these lines were already yellow because the person was born in the U.S., but I made them all yellow.
- Once more, I removed that filter and made a new one. This one showed marriage locations that included "United States". I made them yellow and removed the filter.
| Here's how you can create a genealogy research guide that's custom-made for your family tree. |
When I sorted the spreadsheet to show only the yellow cells, I had a list of 3,034 people who had been in the United States. Yes, there will be some people that this process misses. I expect to discover them as I work to fill in in the spreadsheet.
Here are my past articles on the document tracker:
Populate the New Document Tracker
To create my new, ready-to-use document tracker:
- I downloaded the master document tracker file I keep online to share with my readers. (Make yourself a copy of it. Don't request Edit permission as this is the master file. Make your own copy and edit that.)
- I deleted a couple of columns I don't want to track (baptism and burial).
- In my filtered spreadsheet, I sorted the results by last name, then first name. I displayed only the yellow cells.
- I copied the last name, first name, and birth date of these lines and pasted them into my new document tracker. The birth date is important because way too many people have the same name.
Salvage Past Efforts
I spent a ton of time on my old document tracker before abandoning it in late 2018. So I want to salvage the old file's contents. I opened the old and the new spreadsheets side by side. Now I can copy the pertinent tracking information from the old file to the new. Yikes. This is gonna take a while.
My passion project for the past two years has been creating my missing source citations. That's still my top priority. But when I do spend time working on people from my tree who lived in the U.S., I will consult and update my document tracker.
If you have access to a decent amount of records from your country, consider using a document tracker. With your document tracker, you can make your in-country research as complete as possible.











