Skip to content Skip to footer

Download ThruLines as CSV File

A ThruLines page for John Eckert, 3rd great-grandfather, with his descendants and matches below and the Download CSV button at the right of the bar above outlined in red.

What problem does Download ThruLines as CSV File solve?

Download ThruLines as CSV File adds a Download CSV button to an ancestor’s ThruLine on AncestryDNA. It saves every DNA match in the ThruLine to a CSV file for Excel, Numbers or Google Sheets. Ancestry has no way to export ThruLines, so keeping a record means copying each match by hand.

How does Download ThruLines as CSV File work?

The button sits at the right end of the header bar, and stays there whether you are looking at the tree or the list. Clicking it saves the file without changing your view or opening any groups, so you carry on where you were.

While it works, the button reads Preparing with a percentage. A ThruLine with a few dozen matches takes seconds, and one with a thousand takes about three minutes. The filename includes the tester’s name and the ancestor’s name, so you can tell the downloads apart.

Each row is one match, with their predicted and tree relationships, shared cM and segments, tree size, a link to the match and the family line they descend through. Rows follow the family lines from the earliest born child, and each line’s matches by shared cM, highest first.

How do I use Download ThruLines as CSV File?

  1. In the Genealogy Assistant pop-up panel, make sure Download ThruLines as CSV File is turned on.
  2. Open ThruLines from the DNA menu on Ancestry.
  3. Click the ancestor whose ThruLine you want to save.
  4. Click Download CSV at the top right of the page. When it finishes, the CSV file is saved to your downloads folder.

CSV Columns

Match Name, DNA Relationship, Tree Relationship, Shared cM, Shared Segments, Tree Size, GUID, URL, Family Line, Relationship Range, Confidence, Meioses, Age Range, Location, Gender, New, Viewed, Path, Tree Name, Tree Owner, Tree Private, Source Tree Name, Source Tree Owner, Ancestor

Family Line names the ancestor’s child the match descends through. Path traces the line from the ancestor down to the match, person by person, and shows Private for a match whose name Ancestry keeps hidden.

Relationship Range and Confidence give Ancestry’s range of likely relationships for the DNA you share and how sure it is. Meioses is Ancestry’s estimate of how many generations separate you and the match, counted up to your common ancestors and back down.

New and Viewed read Yes for matches Ancestry marks as new or already viewed. Tree Name, Tree Owner and Tree Private describe the match’s own linked tree, and Source Tree Name and Source Tree Owner name the tree ThruLines used to build the match’s path.

NOTICE: CSV DOWNLOAD TOOLS ARE FOR PERSONAL RESEARCH ONLY.

Related features

  • Automatically Expand All ThruLines: Opens every collapsed group of DNA matches in a ThruLine as the page loads, so all the matches descending from an ancestor are ready to review or capture.
  • Preload Number of ThruLines Matches: Load the match count and shared cM range for every ancestor on your ThruLines card view at once, so the large clusters and the gaps stand out.
  • Download Matches Pages as CSV File: Download your Ancestry DNA matches to a CSV file, as many pages as you choose, following the filters and sort order you have on screen.

Download ThruLines as CSV File is a feature of Genealogy Assistant.

Genealogy Assistant is an extension for Google Chrome, Mozilla Firefox, Microsoft Edge and Apple Safari which supercharges your family history research by adding over 100 custom features to popular genealogy websites like Ancestry, MyHeritage, FamilySearch, FamilyTreeDNA and more.

Install Genealogy Assistant for Google Chrome | Install for Mozilla Firefox | Install for Microsoft Edge | Install for Apple Safari