Genealogy Tracker, Family History Organizer, Ancestor Research Log & DNA Match Tracker, Family Tree Template (Google Sheets)

Finally, one place for your entire family history search — and a spreadsheet that
tells you what to research next.

The Genealogy Tracker is a complete research system for Google Sheets. Enter a fact
once and it flows everywhere: your family tree draws itself, your census checklist
updates, and your dashboard rewrites your to-do list automatically.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
WHAT'S INCLUDED — 7 CONNECTED TABS
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📋 INSTRUCTIONS + SETUP
Three-step quick start, a plain-English guide, your editable dropdown lists and a
real FAQ.

📊 DASHBOARD
KPIs, a 12-month research activity chart, records-found-by-type, plus "Needs
Attention" and "Most Wanted" panels that tell you exactly what to do next.

👤 ANCESTOR INDEX
The master list that powers everything. Type an ancestor number and it names the
relationship for you ("2nd great-grandmother"), scores the records you've found,
and flags the gaps.

🔍 RESEARCH LOG
Every search with its source citation — logged as Found, Partial, Negative or
Planned. Recording your dead ends is the habit that stops you repeating a search
next year.

🧬 DNA MATCHES
Type the shared cM and the likely relationship range appears automatically. Track
platform, side, common ancestor and whether they've replied.

🧱 BRICK WALLS & TO-DO
Three lists in one: the questions you're stuck on, your prioritized research tasks
with due dates, and the certificates you've ordered and are waiting on.

🌳 FAMILY TREE
A five-generation pedigree that draws itself from your index. Nothing to design,
nothing to drag.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
WHY IT'S DIFFERENT
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

✔ ENTER IT ONCE — everything updates. No tab is an island.
✔ THE TREE BUILDS ITSELF from standard ancestor numbering (you're 1, a father is
always double, a mother double-plus-one).
✔ EVERY GOLD CELL IS A RESEARCH LEAD. The census grid covers 1850–1950 and marks
which censuses each ancestor should appear in based on their birth and death
years — then highlights the ones you haven't found.
✔ NEGATIVE RESULTS ARE A FEATURE, not an afterthought — the discipline professional
genealogists actually use.
✔ DNA RELATIONSHIP ESTIMATES follow the published Shared cM Project ranges.
✔ NOTHING IS LOCKED. Dropdowns suggest, they never block you. Type your own values
any time, and edit every list yourself without touching a settings menu.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
WHO IT'S FOR
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

• Hobbyist and serious family historians who want one organised research hub
• Anyone juggling Ancestry, FamilySearch, MyHeritage and a pile of paper notes
• DNA testers drowning in matches with no system
• Beginners — the guide assumes zero spreadsheet knowledge

Not the right fit if you want automatic syncing with Ancestry or FamilySearch, a
GEDCOM importer, or a printable wall chart. This is a research workspace, not a
tree-hosting service.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
WHAT YOU NEED
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

• A free Google account (Google Sheets only — this is not an Excel file)
• Best used on a desktop or laptop. It works on the Google Sheets phone app, but a
research spreadsheet this wide is far easier on a bigger screen.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
HOW IT WORKS
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

1. Buy and download instantly — you'll receive a PDF containing your template link
2. Open the link and choose File ▸ Make a copy
3. Add yourself to the Ancestor Index and start building

Your copy is yours forever, private to your own Google Drive, with no subscription
and no ongoing fees.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Your template arrives empty and ready for your family, with starter lists of record
types, repositories and DNA platforms already filled in so you can begin
immediately.

Questions before or after you buy? Message me any time — I'm happy to help you get
set up.

⚠ This is a digital download. No physical item will be shipped.
© Prospera Lab. For personal use only. Please don't resell, share or redistribute.