

For example, when I find a person in the census, I might make a note of "NY,51" indicating I found them in the New York census at age To add more information as pop-up notes in Excel, right-click on a cell and select Insert Comment. The columns labeled can provide a simple way to show when and where relatives lived. I use the link column the one next to the ID column to create a link that will take me directly to the person's profile in my family tree on ancestry. Using a spreadsheet in Excel or Google Sheets allows me to add notes and comments and keep track of whatever information I feel like adding to the spreadsheet. I use spreadsheets to help me keep track of different family lines, because as my family tree grows I need a way to keep track of what I've done, especially if it's been a while since I worked on a particular line. You can record basic information about individuals and make a simple timeline, but the primary purpose is to keep track of which individuals you are working on. This simple spreadsheet provides a convenient way to organize your family history research. License : Personal Use not for distribution or resale. It lets me add notes and comments, add links to ancestry. The free template on this page is an example of how I keep track of ancestors and their descendants. When I do genealogical research, I use a spreadsheet to keep track of my progress because I work sporadically and need a way to quickly see where I left off.
