HR & People Management
Automatic Family Tree Maker for Excel
$15
Download. Open. Done.
Build a complete family tree in Excel in under 5 minutes. Enter your family members in a simple table, click one button, and the chart draws itself.
Buy on Etsy · $15 →
Secure checkout via Etsy · Instant download after purchase
Windows only (VBA macros)
Excel 2016+ supported
Instant download
Lifetime free updates
✦ What it does
Automatic Family Tree Maker for Excel.
Build a complete family tree in Excel in under 5 minutes. Enter your family members in a simple table, click one button, and the chart draws itself. Designed for amateur genealogists, family historians, and anyone who wants to map their family without learning specialized software.
✦ Features
Everything included.
Built for professionals who want a tool that works without setup or learning.
✓
Generate a printable family tree with one click, no manual layout
✓
Handle multiple generations, couples, and children automatically
✓
Customize the family name displayed on the header banner
✓
Print on A3 paper or save as PDF, sized to fit on one page
✓
Validate your data before drawing, with clear error messages
✦ In your download
What you get.
What's inside
- Familly_Tree_Generator.xlsm (Excel for Windows, 2016 or later)
- User Guide (PDF, 16 pages, with troubleshooting and FAQ)
- 30-person sample family pre-loaded so you can see how it works
- Reset button to restore the sample anytime
Specs
FormatExcel (.xlsm)
CompatibilityWindows only
VersionExcel 2016+ / Microsoft 365
DeliveryInstant download
MacrosRequired (VBA, Mac not supported)
✦ Quick answers
FAQ
Designed for Excel for Windows desktop. Mac Excel is not officially supported because the VBA macros that power the automation may not run reliably. Excel Online and mobile are not supported either.
Yes. The family name is editable directly on the Guide sheet. Colors per generation are editable in the Settings sheet (hex codes).
Up to 53 family members in a single tree. Larger trees may exceed standard A3 print size and require larger paper or splitting by branch.
The tool handles classic family structures. For remarriages, the User Guide explains a workaround using duplicate entries. Complex blended families with shared children across multiple marriages are not visually linked, by design.
