{"product_id":"family-tree-genealogy-tracker","title":"Family Tree and Genealogy Tracker Spreadsheet","description":"\u003cp\u003eThis family tree spreadsheet keeps every branch connected by choosing each parent from a list instead of typing the name. It is for anyone recording their family history over years, who does not want one misspelled name to quietly detach a whole branch.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eParents as dropdowns, not typing\u003c\/h2\u003e\u003cp\u003eA family tree is a table where every person points at a mother and a father. If those links are free text, one typo breaks a branch without anyone noticing, and in a file you will add to for years that is the failure that matters. Here, Mother and Father are dropdowns of the names already in the file, so a person can only point at someone who exists. Add the oldest generation first and the list fills downward.\u003c\/p\u003e\u003ch2\u003eRoom for the whole family\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e120 people, each with born, died, place and notes\u003c\/li\u003e\n\u003cli\u003eAge calculated, stopping at the year of death rather than counting on\u003c\/li\u003e\n\u003cli\u003eNotes for the facts that are lost first, such as years at sea or the language someone spoke at home\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eThe shape of the tree\u003c\/h2\u003e\u003cp\u003eThe file reads your family records and works out the figures for you, which makes it a simple generation tracker.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eLiving relatives counted\u003c\/li\u003e\n\u003cli\u003eEarliest birth year\u003c\/li\u003e\n\u003cli\u003eGenerations estimated from the span of birth years\u003c\/li\u003e\n\u003cli\u003eDeceased rows greyed, so the shape of the tree shows in the table itself\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eFor the research itself\u003c\/h2\u003e\u003cp\u003eGenealogy research is a long list of things to look up, so a Tasks tab keeps track of what to find next, and a dashboard reads all of it. The five connected tabs are Start Here, Setup, Family Tree, Tasks and Dashboard, and the Start Here tab walks you through setup in a few minutes. It works as a genealogy template and a place to keep ancestry records in your own file.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016 or later, on Windows or Mac\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros and no add-ins, so it behaves the same on Excel 2016, 2019, 2021 and Microsoft 365 and in LibreOffice. No Microsoft 365 subscription is required.\u003c\/li\u003e\n\u003cli\u003eNo subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel files: five generations of one family with the gaps left in, and a blank one ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. The file is for your personal use, so please do not share or resell it. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. The Excel files run on Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to make your own copy of the Google Sheets versions.\u003c\/p\u003e\u003ch3\u003eHow many people can I add?\u003c\/h3\u003e\u003cp\u003eUp to 120 people, each with born, died, place and notes.\u003c\/p\u003e\u003ch3\u003eHow are parents linked?\u003c\/h3\u003e\u003cp\u003eMother and Father are dropdowns of the names already in the file, so a typo cannot break a branch. Add the oldest generation first.\u003c\/p\u003e\u003ch3\u003eDoes it draw a family tree chart?\u003c\/h3\u003e\u003cp\u003eIt keeps the tree as a table. Living relatives are counted, generations are estimated and deceased rows are greyed so the shape of the family shows in the table.\u003c\/p\u003e\u003ch3\u003eIs there an example to start from?\u003c\/h3\u003e\u003cp\u003eYes. The filled copy has five generations of one family with the gaps left in, and the blank copy is ready for yours.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597866238046,"sku":"OPX-113","price":22.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/family-tree-genealogy-tracker-01.jpg?v=1790832572","url":"https:\/\/opxviashop.com\/products\/family-tree-genealogy-tracker","provider":"OPXVIA","version":"1.0","type":"link"}