Convert DNA Matches To Sheets
Transform your exported DNA match CSVs into an organized, prioritized Google Sheet to track relationships, shared DNA, and contact history.
Tags
DNA Match Organizer And Priority Tracker
You took a DNA test. You got hundreds of matches. Now what?
That match list from AncestryDNA or 23andMe contains the keys to your family history, but it is overwhelming. Who are all these people? Which ones are your closest relatives? Who have you already messaged? Where do you even start?
This workflow transforms your exported match list into a simple, organized system that helps you actually make progress.
How It Works
- Upload your match export: Just upload the CSV file you downloaded from AncestryDNA or 23andMe. Both formats work automatically.
- We organize everything: Your matches are sorted by shared DNA (closest relatives first), grouped into relationship categories (Immediate, Close, Extended, Distant), and highlighted with priority flags for matches over 150 cM.
- You get a clean spreadsheet: A brand new Google Sheet is created containing all your matches in order, contact status tracking, notes fields for your observations, date contacted fields to track follow-ups, and priority flags showing who to reach out to first.
What You Will Receive
| Column | What It Helps You Do |
|---|---|
| Match Name | Identify who they are |
| Shared cM | Know how closely related you are |
| Relationship Category | See if they are Immediate, Close, Extended, or Distant |
| Contact Status | Track who you have reached out to |
| Notes | Record surnames, locations, and useful details |
| Date Contacted | Remember when you messaged them |
| Priority | Focus on matches over 150 cM first |
Works With
- AncestryDNA (free CSV export, no membership required)
- 23andMe (free CSV export)
- MyHeritage
- FamilyTreeDNA
Perfect For
- Genealogy enthusiasts overwhelmed by hundreds of matches.
- Adoptees and birth family searchers trying to identify close relatives.
- Anyone who has stared at their match list and thought, "Where do I even start?"
Privacy First
Your data stays secure. The workflow processes your file and creates your spreadsheet automatically, ensuring a completely private data transfer.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
