Home › Import from Excel

Import a family tree from Excel or CSV

Many families already have their tree in a notebook or a spreadsheet. Family Tree Circle turns that sheet into a private family tree your relatives can view and add to.

The short answer

Admins open Admin → Import / Export, download the Excel template, fill in one person per row, then choose Import Excel / CSV. You see a preview of the rows before anything is added. Father, mother and spouse are connected by name automatically. Photos aren't part of the import; you add them afterwards.

Step by step

  1. Download the template. In Admin → Import / Export, choose 📥 Download Excel Template. It has an orange header row, three grey sample rows in your family's style, and a "How to fill" sheet.
  2. Fill in one person per row. Keep the header row as it is. Only Name is required. The columns are: Name, Nickname, House name, Gender, Born, Died, Alive/Status, Place, Father, Mother, Spouse, Children, Description and Notes.
  3. Connect people by name. In Father, Mother and Spouse, type the person's full name exactly as it appears in their own row (or as it already appears in the tree). List children's names separated by a semicolon (;).
  4. Delete the sample rows. Rows marked SAMPLE are skipped on import anyway, so nothing breaks if you forget.
  5. Import the file. Choose 📤 Import Excel / CSV and drop in an .xlsx, .xls, .csv or .tsv file, or paste rows copied from Excel or Google Sheets.
  6. Check the preview. Recognised columns are marked, unrecognised ones are skipped, and the first rows are shown. Then choose Import. People with the same name and house are updated, not duplicated.
  7. Add photos and invite the family. Upload profile photos, then invite relatives to check and fill in their own branches.

Formatting tips

Moving from another family tree site

Export a list of people from your current site or program into a spreadsheet, rename the columns to match the list above, and import it. Family Tree Circle imports Excel and CSV files; it doesn't read GEDCOM files directly. See how we compare with Ancestry, MyHeritage and FamilySearch.

Common questions

Are photos included in the import?

No. Import and export cover people, relationships and details. After an import, add photos by uploading them to each profile.

What if my spreadsheet has more people than my plan allows?

On the Starter plan the tree holds up to 50 people. Rows beyond that aren't added, and nothing already in your tree is touched. Unlimited and Lifetime have no limit on people.

Who can import?

Admins and the Super admin, from Admin → Import / Export. Relatives can fill in the template and send it back for an admin to import.

Can I export the tree to Excel again later?

Yes. Admins can export everyone as Excel, CSV or a full backup file at any time. Photo files aren't included in exports.

Related guides

See an imported family in action

The live sample shows every feature with no sign-up.