skip to Main Content

Automatic Family Tree Maker Excel Template

4.64 (33 reviews)

Unique Excel template to create your Family Tree from your data with a button click! Photo upload feature. Fully printable. Works on Mac & Windows.

Learn more about License Types

Someka refunds icon


Someka one time payment icon


Someka direct download icon



Family Tree Maker by Someka is an automatic Excel template which helps you visualize your familial relations easily. Thanks to this tool, you will see your roots clearly and get a snapshot of multiple generations; as a whole family. Furthermore, this Excel template helps you to create your family tree in an easy way, with 1 click only.


Basically, just input the members and create your tree. You can include the connections such as spouse or parent. Optionally, add extra information od ex-spouse per person. Simply, to make use of the additional features, you can use the control panel to customize your chart too!

Automatic Family Tree Maker Excel Template Features


In just 3 basic steps, you will be able to create your family tree:

1. Fill out the data input table,also please follow the below order:

  • Person Column: First add all the people in your family that you want to see in the family tree. (After you input all the names go to the next steps)
  • Spouse Column: Select all the spouse and/or ex-spouse connections to existing family members (from dropdowns).
  • Parent Column: Select all the parent connections to existing family members (from dropdowns).
To make things easier for yourself, please do not use duplicate names. Otherwise, it will be challenging to differentiate people in the selection menu. If there are people with the same name, put a little indicator like dots, commas, numbers to differentiate.

Optional data areas: Information & Ex-Spouse

2. Define settings and insert photos from the control panel (optional)
3. Click the “Create Family Tree” button and your genealogy tree is ready within a few minutes

Note: After creating the chart each of the elements can be moved, reshaped, or deleted.

Family Tree Maker Control Panel


Finish inputting all your data before you check the messages. Until all data is in the table you can see some temporary messages because of unfinished input.



Here you may find the basic settings and advanced settings to customize your family tree. You may input these cells to change them, when possible, you can you the dropdown to select a predefined option.

Below are the basic settings options:



The fold option will be helpful if your family tree is very wide. If you decide to fold the chart in all the possible cases, siblings will be drawn one under another. This way the final tree will be more compact.

After you complete the basic settings options, you may move on to the advanced settings options:


On the other hand, the information column is optional. In settings, you can select to show or hide information according to your needs. In addition, you can change connector colors and choose different types of connectors from the dropdowns.

Automatic Family Tree Maker Color Options

In addition, the colors of the family tree template are fully customizable. You can format cells and change the colors that will be used later. But, just change the color name and cell fill color.

Export Button

Above all, you can export your family tree into 3 formats:


Moreover, the new version of this template gives you a lot of cool features:

    • Add Photos; you can add, delete or also update the photo with a new one.
    • Export both the input data table and the chart into one of 3 formats: PDF, PNG, or JPG.
    • Change the photo layout, colors, font and text box size, colors, distances, and many, many more.
    • Add and actually see on the chart, your spouse, cousins, and their close relatives.
    • Build the tree in both directions; from the root to the crown of the tree and the opposite: from the crown to the roots.
    • Finally, if any of the calculated spots won’t suit you, you can always move the elements and place them according to your preferences.


Automatic Family Tree Maker Excel Template Features Summary:

  • Works both on Mac and Windows
  • Unique product for auto-generation of family tree chart in Excel
  • No installation needed, ready to use
  • Photo upload feature
  • Extra info also may be added optionally
  • Clear on sheet instructions (with turn on/off function)
  • Easy to use and nice design
  • Customizable box (shape) design and colors
  • Export to PDF, PNG, JPEG feature
  • Shapes editable in PPT
  • Print-ready
  • Compatible with Excel 2010 and later versions

Family Tree Maker is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.


Watch the video below to see the template in action! Presentation also includes usage notes, explanations and tips & tricks about the template.


Family Tree Maker Product FAQ

Is there any limit to the number of generations?


There is no limitation for the number of generations in our template.

However, we recommend you to add up to 500 people. More than this may result some performance issues on your end depending on the Excel version that you are currently using.

What if I have re-married (e.g. death/divorce), is it possible to show this?

It is possible to show multiple marriages as we have Information and Ex-Spouse columns that you can easily add information to. You may add one current and one ex-spouse.

I have created my family tree using your software, but when I came to print it, it is completely unreadable.

As for displaying more than 100 people, it would be extremely impractical and difficult to render what you want. That’s why it would be better to print out 40-50 members of your family at once.

If you want to change the font size and distances between the family members to fit better, you can use the Settings in the Control Panel.


33 reviews for Automatic Family Tree Maker Excel Template

  1. Tamela

    Nice product!!! I want to add family members’ careers/professions. I wish there was such a field.

    • Someka

      Hi Tamela,

      You can use the ‘Information’ column to add their profession.
      However, this is an optional column so do not forget to select the “Show” option for the ‘Information’ selection in the advanced settings.

      Hope this helps!

    • Tamela

      if you change the template in the future.
      My template will be old version. should I purchase again?

    • Someka

      Hello Tamela,

      All of our templates come with a bonus of lifetime updates.
      This means, when we make improvements and bug fixes to the template after your purchase, you will always have the right to get the newer version.

  2. L.Íñiguez

    It’s great to have an export to png/jpg button

  3. haars putra

    in my cases ;
    1. somebody has more than 2 spouses
    2. someone has been married more than 2 times

    • Someka

      Hi Haars,
      Thank you for your questions.
      This template does not allow adding more than 2 spouses (one current and one ex spouse) in a standard way.
      You can just write down in the main spouse information column all it’s spouses.
      If you wish to see separate boxes for those extra spouses you can try some kind of workaround. That kind of solution may work for you.
      You can list them one after another in the input table and add them as if they had the same parents as the spouse (like they were just brothers/sisters). So after the chart is created you can manipulate just the connector manually and connect them between each other.
      comment image

  4. Joseph T

    On the excel page (family data) when I start enter data i am getting red letter err massage in err box such as “parents”should exist in names column. Some body please help me.

    • Someka

      Hi Joseph,
      You nay simply select the parents from the related dropdown with one click. The error message means that the parent name is not included in the “Name” section. Please include the parent name and if this does not help send us your file at so we can assist you.

  5. josh

    It is easy to learn, simple and it is a better value than Visio and the others I have tried. I love the that you can edit the tree afterwards

  6. Kate

    I’m very happy with this tool! I could add 15 generations without problem!

  7. Elias Akiki

    Dear Sirs

    Please note that I am willing to purchase the family tree pro version, whereby my daily online limit purchase is only 25USD how can we manage to split the payment so I can purchase the template within two days.

    I really appreciate you can find me a solution ASAP, I really need this template

    Thank you

    • Someka

      Hi Elias,

      Thanks a lot for your interest in our template! You can have a look at our acceptable payment methods from this link: What forms of payment do you accept?

      You might also select a different payment method to purchase the template or you can talk with your bank to increase your online payment limit.

      If you have further questions please do not hesitate to contact us anytime.

      Kindly regards,

  8. Jenny L

    I copied and pasted the columns and got the #REF messages. Help!

    How can I create a second family tree without retyping all info

    • Someka

      Hi Jenny,

      You can create a copy of the Excel file and save with another name and keep on editing on this version. If this does not help send your file to us at and we will be hay to support

      Best regards,

  9. Yellowf

    Hi, I have just paid and downloaded. Would like to understand is it possible to have the spouses appearing together (each with a separate box), or at least allow the spouses to be able to take on two photos? The current setup only allows showing one (e.g. just the photo of the Queen but not Prince Philip is certainly not ideal given both spouses are clearly of the same level of importance.

    • Someka


      Now you can easily include your spouses and photos in the updated version of our Family Tree Maker!

  10. Michiel Van K.

    I have been trying out the Premium Family Tree maker which does seem to be a nice tool.
    However, there is something not working with regards to children: they are not shown in the family tree. Or am I doing anything wrong? Could you help me out please?

    • Someka

      Hi Michiel,
      Thanks a lot for your interest!
      Did you leave the “parent” column blank for those family members (children)? If yes, please select the parent from the dropdown list.
      We have shown how you should fill the data table on the product images and video above as well. If this can not help you to solve the issue, please contact us!
      All the best,

  11. Tammy Braun

    I have a chromebook and I cannot open the zip file and have it do anything except show as an excel file. I can’t make a tree with this??

    • Someka

      Hi Tammy,

      To be able to open the file, you need to unzip it first.

      Besides that, we have to stated that “Numbers” are not supported. So, you need to download Microsoft Excel for Mac to be able to use the template. You can have a look at this page to learn more: Do your templates work on Mac?


  12. Richard Vernon

    when I add my photos to my family tree & press Create, my photos don’t appear in the photo field. Help me please.

    • Someka

      Hi Richard,

      First of all, thanks a lot for your interest!

      You should check two points to make sure that you did everything correctly.

      1) Did you select the “No Photo, Left Photo, Top Photo, Corner Photo” option on the ‘Photo Option’ under ‘basic settings’? It should not be selected as “No Photo”.
      2) Did you upload the pictures for each person from the “Add Photo” button?

      Important! Please be careful about the size of the picture. If the image file size is excessive from the Excel file can load, this might be the reason why you don’t see the picture on the family tree. We suggest trying to upload the dummy image/photo first (small file size) to make sure that the template is working properly.

      Hope that helps!

    • Richard Vernon

      Many thanks for your email. I tried your recommendation and it worked. My files were too large.

      But, I am still having an issue. When I convert my file to PDF, I am missing quite a few family members on the right side.

    • Someka

      Hi Richard,

      The reason for missing family members might be related to the scale of the family tree. If it exceeds the size of the A5 page, you might not see the overall family tree. You should select a different page selection from the “Print” options. Moreover, you can set the print area again and enlarge it by yourself from the “Page Break Preview” option.

      Best wishes,

    • Richard Vernon

      Thanks a lot! It worked.

  13. Marie Kuehne

    Can I also add birthdays?

    • Someka

      Hi Marie,

      Of course! You can use the ‘Information’ column (optional) to add birthdays.

      Note! Please do not forget to select the “Show” option for the ‘Information’ selection in the advanced settings.

  14. Babak

    Hi, how your Excel macro generates a 250 person family tree with 13 first generation and then on and on. How is that produced in an output file to be printed? Thanks

    • Someka

      Hi Babak,
      There is no limit to the number of generations in our template. However, we recommend you add up to 500 people. We have already explained the reason in the FAQ section above.

      If you have further questions please do not hesitate to contact us!

    • Babak

      This is great. last question:

      – Will this also work on Mac OS version of Excel?

    • Someka

      The template works both on Mac and Windows (Please note that we are only able to test it for all Windows versions).

    • Babak

      GREAT! Thanks a lot.

  15. John

    I purchased PREMIUM FAMILY TREE MAKER with EXCEL TEMPLATE today. Very easy to use. However, I see that some individuals on my tree are and others are not including the INFO I’ve included. Do you why that might be?

    • Someka

      Hi John,

      First of all, thanks a lot for your interest! We are happy that you love it.

      Could you please make sure that you have selected “Show” option for the ‘Information’ selection in the advanced settings. This will hopefully solve the situation.

      Hope that helps!

    • John

      That works perfectly — thank you!

  16. Mutlak

    I’m subscribed to someka excel solution, i got an Automatic Family Tree Maker template.
    it’s working fine and i like it.
    I started filling up my family tripe members (around 300), i ignored the field (Spouse)
    i would like to omit the field (Spouse) completely from the dashboard and as well as printing.

    can you help me to customize the code to remove the spouse field?
    best regards

    • Someka

      Hi Mutlak,

      Thanks a lot for your kind feedback! We are happy that you like our template.

      If you do not want to fill in the “Spouse” column, we recommend that you enter the “-“ sign instead of leaving it completely blank.

      If you need customization on your reports or need more complex templates, please refer to our custom services.

      Hope that helps!

  17. Patty West

    It looks great. But, I have a question about the family tree. I’m wondering how it would handle 9 siblings and all of their kids on up to 5 or 6 generations. I’ve been working on a spread sheet myself and came across your template. I love the idea of being able to add pictures. I would love to have something that I could take to the family reunion to share with everybody so we can see how we are all related. Do you have a sample you could share with me? I seen the one of Queen Elizabeth, but my family is much larger.

    • Someka

      Hi Patty,

      First of all, thanks a lot for the time you spare to write a review.

      Unfortunately, we don’t have any samples but we have already explained all of the features of the template in the product video. You will probably understand how you can use the template to create your own family.

      We recommend that you add up to 500 people inside the template so you can also enter up to 5 or 6 generations as well.

      Hope our explanation helps you, if you have further questions please do not hesitate to ask.

      Kindly regards,

  18. Anil Shah

    I have a Mac computer. I could not find any software program which works on my Mac except this program. I am so happy to get this program. Also, the Program is very user friendly and cost effective.

  19. Casey segreto

    First is price. Easily affordable by company or individual.
    Second is no need learning curve.
    Lastly, being able to create chart very quickly and print them.

    Especially for someone like me who used Visio for many years. I love this spreadsheet so much!

  20. blythe

    Great value for money, it is always possible to update the chart anytime I want and it cuts the learning curve as they said.

  21. ayashe POWAQA

    The price is affordable for an individual and it is just one-time purchase. The support team was very responsive and seems to care about what you are having difficulty with doing.

  22. Lisa Whitewood

    I’m new to this program and have made an error. I’ve sent several email messages but not replies. May be the time zone is different to
    Australia, so will it take 24-48 hours or days (hopefully not weeks) to meet your time zone before I get a reply. I can’t use the program, HELP, HELP HELP someone in
    our time zone.

    • Someka

      Hi Lisa,

      Thank you for your feedback!

      Our customer support team always try to return to customer emails and reviews as soon as possible but as you said because of the time zone difference, the duration of support may be delayed max one day. Don’t worry, one of our developer team will assist you regarding your issue. Please check your mailbox, thanks!

  23. Erle

    Some drop down menu names from “parent” column is blank. Hmmm.

    • Someka

      Dear Erle,

      Thanks for reaching out and taking your time to leave a review for us! Appreciated!

      Normally in Parents column, there should be only one blank cell so if you see more than one, then your data might be corrupted and our tool will not recognize the names you input. Our development team would love to check your file and figure out what’s wrong. Just send us your file at

  24. Jorge

    After a few days of purchasing the premium version with password to unlock it, I’ve still not been able to do any changes to the downloaded file. I followed the instructions that come with it, but nothing happens. I contacted “chat with us” and they asked me to email contact support. I still waiting for their respond. Getting frustrated. I had tried other templates from them and they are not user-friendly at all.

    • Someka

      Hi Jorge,
      When the issue our users have is more complicated and needs technical support, we generally refer them to our tech guys to provide more professional assistance. Normally, after you purchase you can edit as you wish but you may accidentally corrupt the template structure or it can be related with your excel compatibility.
      Rest assured all cases will be addressed within 24 hours during working hours.

  25. Linda S.

    Incredible value! The Family Tree Makes is worth so much more than what I paid. Quality product all around. It works splendidly “right out of the box” and does everything as advertised. On top of that, the technical support team is the best I have ever worked with. Top notch support all around. I would give that group 6 stars if I could!

  26. philip

    Looks great. Only just started ‘testing it’ but how do you print out the tree? I tried printing from excel, then saving as a pdf and trying to print. Seems to print every page EXCEPT for the actual family tree. Help appreciated. Thanks Philip

    • Someka

      Hello Philip,

      The printing area of the family tree will be automatically setting after the creation of the chart. However, if you would like to adjust printing area, please follow these instructions: Printing Excel Workbooks

  27. Stephen

    Its nice and easy but disappointing that it only does up to 15 generations. 5/5 if it did more generations!

    • Someka

      Hello Stephen. Thanks for your feedback.
      Actually, there are no limits for generations. (it was 15 in the past but we’ve updated the tool later on. Now you should be able to put as many generations as you want)
      Please make sure you download the latest version from the link you’ve been provided in your purchase email.

    • Stephen

      For some reason it got cut off at the 29th generation. There was a weird error occurring due to a lowercase letter instead of capital. I got it all resolved now! Thank you!

  28. Yash Sanka

    Perfectly works but can’t import data, even if the requirements are met

  29. Paul Howlin

    Before ordering, I had a discussion in which they explained to me exactly what was included in the Premium version. They gave them a very accurate description and explanation.

  30. Jackie Caplan Wiggins

    AWESOME TOOL! I was looking for an easy tool to put together a simple family tree. I didn’t care about dates or photos, just a layout so my family understood who was related to whom. This is so easy to use. They were very responsive to my questions (always within a day). My family loves that I was able to provide them with this information. HIGHLY RECOMMENDED!

  31. Ha

    I needed to create a genealogy tree for my extended, multi-generation family. I was looking for something that is easy to use, and allows other family members to edit without all the fuss of account registration.
    Auto Family Tree Maker is a splendid match to my expectation. Being based in Excel, it is easy enough to use, even for my granddad. Creating entries is fast and simple enough, as I didn’t have to submit many forms (as the case of web apps).
    I highly recommended this template.

  32. PETER

    its ok software just a pity i couldn’t add spouse Sibling photos as well but had been advised that its a bit complicated to add that extra features as welL but hope they will work out somethingl

    • Someka


      Now you can easily include your spouses and photos in the updated version of our Family Tree Maker!

  33. Lawrence C.

    This software is quick and user-friendly! Also, thank you for speedy responses, return of your customer service is really prompt.

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.