Make AncestryDNA’s Clusters More Useful with Excel

Ready to make your AncestryDNA clusters more useful? In this video, I’ll show you how to transfer your clusters to Excel, format them for clarity, and even expand them with additional matches—so you can reveal patterns and uncover new insights!

⭐Want to jump straight to Excel? The step-by-step starts at 9:04. But I encourage you to watch the whole video—there’s important context and NEW content in the first 9 minutes!

This is the third video in my clustering series. Start here if you missed the others:

▶️ Start Here – "AncestryDNA’s New Clustering Tool Explained (with Examples)" 👉    • AncestryDNA’s New Clustering Tool Explaine...  
▶️ Is it Endogamy? "Ancestry’s DNA Clusters: How to Read Them and What Gray Cells Really Mean" 👉    • Ancestry’s DNA Clusters: How to Read Them ...  

In this video:
✅Why siblings may see very different cluster results
✅What to make of missing or inconsistent matches
✅How to export your AncestryDNA clusters to Excel

Ways to organize, manipulate, and expand your clusters for deeper analysis

📌 Timestamps:
0:00 – From Confusing to Helpful: What Clusters Can Do
1:05 – Are AncestryDNA Clusters Worth Using?
2:18 – Case Study Recap (from “Gray Cells” Video)
3:25 – Who’s in a Cluster, and Why?
4:33 – Inconsistent Clusters & Missing Matches
6:38 – Why Siblings May See Different Clusters
9:04 – Exporting and Formatting Clusters in Excel (Skip to here if you’re short on time)
10:57 – Cleaning and Manipulating Clusters in Excel
14:23 – Expanding Clusters: Adding More Matches in Excel
18:43 – What’s Next?

Want more DNA tips and tools?
➡️ Join my newsletter: https://danaleeds.myflodesk.com/

More Helpful Videos:
🎥"How to Do the Leeds Method with Your DNA Matches: A Step-by-Step Guide"    • How to Do the Leeds Method with Your DNA M...  
🎥"Analyze Your Leeds Method Clusters: Find How Matches Relate to You (and Each Other)"    • Analyze Your Leeds Method Clusters: Find H...  

🧬 Subscribe for more: @DanaLeeds