Home › Excel and Google Sheets template

Free family tree Excel and Google Sheets template

A blank spreadsheet you can fill in the browser and download as CSV. Columns match Family Tree Circle's import, and it opens cleanly in Excel or Google Sheets.

Each row is one person. The columns match Family Tree Circle's import template, so you can fill this in now and import it later without renaming headings. Download a CSV for Excel or Google Sheets. Nothing you type is uploaded.

How to open the file

A simple order to fill it

  1. Add yourself, then your brothers and sisters, then your parents.
  2. Add grandparents. Put their names into the Father and Mother columns of your parents' rows.
  3. Work outward to uncles, aunts and cousins, or send a copy of the sheet to the relative who knows that branch.
  4. When you are ready for photos, stories and invites, import the file into a private tree.

Common questions

Is this Excel family tree template free?

Yes. Download the CSV as many times as you like. There is no email gate.

Can I use it in Google Sheets?

Yes. Import the CSV, share the Sheet with relatives who are helping, then export it again as CSV when you want to import into Family Tree Circle.

Does this draw a tree diagram?

No. It is a data template. For a diagram you can print, use the printable charts or the chart maker.

Will Family Tree Circle accept this file?

Yes, if you keep the header names as they are. Admins import it from Admin → Import / Export. See the Excel import guide.

Related guides

Import the sheet when you want relatives to help

Preview the rows, then invite each branch to add photos and stories in a private tree.