How to Download Your AncestryDNA Match List | Export Ancestry DNA Matches

Here’s how to download your AncestryDNA match list when you want to export your Ancestry DNA matches.

Downloading your DNA match list can help you explore endogamy on your family tree. Some people also do this to organize their DNA matches from across multiple DNA testing websites.

The following hack for exporting your AncestryDNA matches was shared by Greg Clarke of Ontario, Canada when he was a student in our DNA Skills Workshop. We’ve created this video tutorial with his permission

Want to expand your Ancestry DNA knowledge?

Sign up for our AncestryDNA Tour with Your DNA Guide:

At Your DNA Guide, we teach people how to make family history discoveries using their DNA. Subscribe to our channel and learn to DO the DNA!

Watch our other tutorials on downloading your DNA match lists:

Don't stop your DNA learning at just this channel, make sure to check out our other resources!

Downloadable Guides:

Monthly Newsletter:

Follow us on Social Media:
Facebook:

Twitter:

Instagram:

[uptergroveGreg]

I have just updated the Ancestry spreadsheet - it now recognizes Both sides / Maternal / Paternal / Parent 1 / Parent 2 - whatever Ancestry or the user has pegged a match (if one has been pegged). You will have to re-download the spreadsheet - but - you've probably got some new matches in there by now anyways - right ? Enjoy!

[lj_wolfe]

Confirming that the sheet doesn't play well with Firefox, and I think I can see why -- when you Select All on FF, it doesn't select the "xth - xth cousin" and "x cM | x% shared DNA" parts of the page. Just a bit of important data there! On Chrome, Select All actually selects _all._ :-)

[brianschuck]

I used a process like this many times, but really appreciate that this shared file fixes the formatting! Used to take me a long time to get that all straightened out.

[MidlandTexan]

Thank you! I have been frustrated regarding this issue. You have helped me out!

[pinwheelgrl]

Thank you for the more up to date version!

[garrywright]

@UptegroveGreg: Can you tell me where to find the latest version of the Ancestry DNA Match Maker spreadsheet and answer a question? I have watched the how to video several times to try to copy my Ancestry DNA matches into the spreadsheet. I always end up with all the matching people, their data and even profile photo, copied into Column A from Cell A6 down for the entire list of matches. The data never spreads to the right across the Cells from Column T(Category) and continuing to the right. What am I doing wrong? Garry Wright

[carolweldon]

It isn't pasting into the format in the spread sheet but pasting everything into column A. I'm using Chrome per previous comments as I usually use Firefox. I'm making sure I'm in the 'yellow box'. I've even re-copied and saved a new master.

[uptergroveGreg]

Hi folks! Thanks to a fellow user, Tammy, we discovered that it turns out - when you turn on DARK MODE on your tree in Ancestry (now), somehow that also affects what you see on your DNA Matches page - AND - there is extra text added in Dark Mode that is not there in Light Mode - and that trips up the formulas. Also - to add more confusion - if you SORT your matches, that also can add extra text that messes up the formulas. SO ... do NOT use Dark Mode - and do NOT sort your matches before you do the copy & paste to the spreadsheet. If you've suddenly been having problems since the introduction of the Dark Mode feature - see if turning it off fixes the problem.

[sonyalazanya]

this is thank you so much. tremendous time saver.

[julieburnett]

Can you tell me where I download the spreadsheet

[SamsungGalaxy-vwgy]

Where is the link to the spreadsheet?
You said there is a link "below"?
I don't see the link.
Please provide the address to the link in a clear way

[thislittlemissis]

I have tried this in Firefox and Chrome and I am seeing absolutely no matches in the spreadsheet. 🤷🏻‍♀️

[LifeStirredUp]

Thank you so much! This is just what I was searching for. Subscribed!

[janekirkwood]

Hi I've tried all these steps and the text is just lumping all the matches info into the A6 column and not moving it across and I've tried several times from the start, someone please help!

[beeurd]

To anybody else stuggling in Firefox like I was - switch to Chrome to copy and paste the information. I don't think the macro that parses the data likes Firefox.

[brogdontsypko]

Is it possible to download the list of trees as well? Or would I have to do that one by one after clicking on each one?

[richardwalker]

How can I use this Downloaded “Your AncestryDNA Match List” to benefit me?

[robdav]

Unfortunately, I get an error when attempting this process. Something about a bad address.

[jrcgjhughes]

How do you add more rows? I tried to do this but noting happens.

[jerrisamuel]

I am having a problem with the pasting because all my notes are off centering everything. Is there a secret to correcting that?