This tutorial takes you step-by-step through creating a four-generation family tree in Google Sheets. A four-generation tree goes back to eight great-grandparents. This tutorial builds a tree that prints on a single landscape page. If you’re too busy for the twelve steps in this tutorial, jump down to the end to grab our “done for you” Google Sheets template bundle. … Read more
A word cloud is a visual representation of text. The size of each word in the cloud is proportional to its frequency. When we use word clouds to represent our family tree, we are usually making one from either: In this tutorial, I show two ways to make a word cloud based on last names … Read more
Do you want to convert a GEDCOM file into a spreadsheet with every person nicely formatted in rows? This tutorial walks through how to do this for free. You’ll be working with a script or piece of code, but don’t worry if you’re not familiar with programming. I’ll provide the script in a way that … Read more
This article explains the basics of the GEDCOM file format that is used copy family trees between different platforms and software. I answer all the basic questions, with a gentle introduction to some of the more complex topics. What Is GEDCOM And How Does It Work? Suppose that you download your family tree from Ancestry.com … Read more
A six-generation tree goes up to 32 great-great-great-grandparents. Our layout in Google Sheets prints on a single landscape page. That’s perfect for bringing to libraries and archives. If you’re too busy for the twelve steps in this tutorial, jump down to the end to grab our “done for you” Google Sheets template bundle. What The 6-Generation Pedigree Tree Looks Like … Read more
A seven-generation tree goes up to 64 great-great-great-great-grandparents. Our layout in Google Sheets prints on two landscape pages that can be easily taped together. If you’re too busy for the fourteen steps in this tutorial, jump down to the end to grab our “done for you” Google Sheets template bundle. What The 7-Generation Pedigree Tree Looks Like The picture below … Read more
An eight-generation tree goes up to 128 great-great-great-great-great-grandparents. Our layout in Google Sheets prints on six portrait pages that can be easily taped together (three pages across and two deep). If you’re too busy for the thirteen steps in this tutorial, jump down to the end to grab our “done for you” Google Sheets template bundle. What The 8-Generation Pedigree … Read more
If you’ve copied your family tree between different genealogy sites and software, then you’ve probably dealt with a GEDCOM file. Have you ever wondered how the GEDCOM format came about? This article delves back into history to it origins. I also take a quick look at why the genealogical data standard seems stuck in time. … Read more
A nine-generation tree goes all the way up to 256 great-great-great-great-great-great-grandparents. Our family tree layout in Google Sheets prints across multiple portrait pages that can be taped together. If you’re too busy for the sixteen steps in this tutorial, jump down to the end to grab our “done for you” Google Sheets template bundle. Table of Contents The 9-Generation Pedigree Tree … Read more
This tutorial shows you how to create a very large family tree in Google Sheets. A 10-generation tree goes back to 512 great-great-great-great-great-great-great-grandparents. This version prints across three A4 portrait pages wide and eight pages deep. If you’re too busy for the sixteen steps in this tutorial, jump down to the end to grab our “done for you” Google Sheets template … Read more