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
- Microsoft Excel: File → Open and choose the CSV. If accents or Indian language names look wrong, use Data → From Text/CSV and pick UTF-8.
- Google Sheets: File → Import → Upload, or open Google Sheets and choose File → Import. Sheets usually detects UTF-8 correctly, which matters for names in Malayalam, Hindi, Tamil and other scripts.
- Only Name is required. Add Father, Mother and Spouse using the person's name exactly as it appears in their own row so relationships connect.
- Children can be a list separated by semicolons.
- Dates: a year (1955) or a full date (mm/dd/yyyy). Gender: Male or Female. Alive/Status: Alive or Late.
A simple order to fill it
- Add yourself, then your brothers and sisters, then your parents.
- Add grandparents. Put their names into the Father and Mother columns of your parents' rows.
- Work outward to uncles, aunts and cousins, or send a copy of the sheet to the relative who knows that branch.
- 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.