Skip to content Skip to footer

Save All People in Tree to CSV File

The top of an Ancestry tree's list of all people, with the Download CSV button and its settings gear outlined in red, beside + Compare and View Surname Comparison Tool.

What problem does Save All People in Tree to CSV File solve?

Save All People in Tree to CSV File adds a Download CSV button to the list of all people in any Ancestry family tree. It saves everyone in the list to a CSV file for Excel, Numbers or Google Sheets. Ancestry’s own export is a GEDCOM file, which needs family tree software to read.

How does Save All People in Tree to CSV File work?

The button sits at the top right of the list of all people, with a gear joined to its right. Beside it are + Compare and View Surname Comparison Tool. The file holds the people the list shows, with your search, sort and filters applied, starting from the page you are on.

Each row has the person’s birth, death and first marriage, with the places split into county, state or province and country. It also has their parents, spouses, number of children and notes. On a tree you own it also holds the extra columns Ancestry shows you there, such as hints and sources.

A progress window counts the people read, with a Cancel button. The finished file is saved to your downloads folder, named after the tree. If you cancel, or Ancestry stops answering, the people read so far are saved.

The Downloading Tree CSV window over the list of all people, with a progress bar, the number of people read so far and a Cancel button.

When Ancestry limits requests, the download waits and tries again on its own, and the progress window says how long it is waiting. The gear opens Download Settings, where a slower Download speed (Walk or Crawl) helps if Ancestry keeps limiting you. It is the same setting your match list downloads use, so changing it affects both.

The Download Settings window over the list of all people, with Download speed set to Standard and a Close button.

+ Compare adds every surname in the list to the Surname Comparison Tool under the tree’s name. You can then line this tree up against your DNA matches’ trees. View Surname Comparison Tool opens the tool in a window over the page, without leaving the tree.

How do I use Save All People in Tree to CSV File?

  1. In the Genealogy Assistant pop-up panel, make sure Save All People in Tree to CSV File is turned on.
  2. Open the list of all people in an Ancestry family tree.
  3. To save only some people, search, sort or filter the list first, and go to the page you want to start from.
  4. Click Download CSV. When it finishes, the CSV file is saved to your downloads folder.
  5. To change the speed, click the gear beside Download CSV.
    1. Choose a Download speed. Standard suits most trees; choose Walk or Crawl only if Ancestry still limits your downloads.
    2. Click Close. Your choices are saved as you make them.
  6. To compare surnames, click + Compare, then View Surname Comparison Tool. The tool opens with this tree’s surnames added.

CSV Columns

Surname, Given Names, Birth Date, Birth Date (ISO), Birth Place, Death Date, Death Date (ISO), Death Place, URL, Person ID, Gender, Alternate Names, First Marriage Date, First Marriage Date (ISO), First Marriage Place, Spouses, Birth County, Birth State/Province, Birth Country, Death County, Death State/Province, Death Country, Father, Mother, Children, Created, Last Modified, Notes

The ISO columns hold the same dates as year, month and day, for example 1888-09-23, or just 1888 when only a year is recorded. They sort correctly in a spreadsheet. URL links straight to the person’s profile page, and Person ID is Ancestry’s own number for that person.

Spouses lists every spouse in marriage order, and Children is the number of children in the tree. The county, state and country columns split each place into its parts, so you can sort or filter by them. Created and Last Modified are the dates the person was added to the tree and last edited.

When the file holds only part of the tree, because you searched, filtered or started past the first page, a parent or spouse is named only if they are in the file too. To name them all, download the whole list. On a tree you own, part of a list leaves parents, spouses and notes blank; for those, use Ancestry’s own GEDCOM export, which holds them.

On a tree you own, these columns come before Notes: Relationship to You, Direct Line, Line, End of Line, Age at First Marriage, Age at Death, Hints, Record Hints, Photo Hints, Story Hints, Member Tree Hints, Record Sources, Family Tree Sources, Other Sources, Geneanet Sources, No Sources, Only Tree Sources, Possible Errors, Possible Duplicates, Tags, ThruLines, Linked DNA, Possible DNA Match, Profile Photo.

NOTICE: CSV DOWNLOAD TOOLS ARE FOR PERSONAL RESEARCH ONLY.

Related features

  • Save Public Member Trees to CSV: Download every public tree a person appears in from the View all window in your search results, one row per tree with the facts, family and links each tree holds.
  • FamilySearch: Save Family Tree as CSV or GEDCOM: Save a person’s descendants, ancestors or close family from the FamilySearch Family Tree as a CSV, GEDCOM or ahnentafel file, with full dates and places if you want.
  • Copy Surnames from Family Tree: Copy every surname in a match’s tree to your clipboard, comma-separated, with one button on the trees tab.

Save All People in Tree to 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