Excel Family Tree Maker V2

Excel Family Tree Maker (VBA Auto Generator)

Turn your Excel data into a complete, visual Family Tree automatically — no manual drawing, no complex connectors, no wasted time.

Just enter your family data → click one button → your full multi-generation family tree is generated instantly.

🚀 Key Features

• Auto-generate Family Tree from Excel data
• Supports 10+ generations
• Handles large datasets (100+ family members)
• Auto layout calculation based on relationships
• Fully editable after generation (drag & adjust)
• Auto-updating connectors (no broken links)
• Custom layout options (Top-Down / Bottom-Up)
• Curve or Elbow connectors with color control
• Adjustable spacing, thickness, and structure

📂 Smart Data Structure

Simple Excel table:

• Name (required)
• Father / Mother (relationship logic)
• Spouse (optional)
• YearInfo (optional)
• Notes (optional)

Everything is generated directly from your data.

🧰 Advanced Controls

• Horizontal & Vertical spacing control
• Layout direction (Top-Down / Bottom-Up)
• Process Time tuning for performance stability
• Multi-style text formatting inside each node
• Settings sheet for full visual customization

📤 Export & Print

• Export to high-quality PDF (poster-ready)
• Direct Excel printing (A4 → large posters like 16x20 inch)
• Copy to PowerPoint / Word for further editing
• Export without text” option for design flexibility

💡 Perfect For

• Family history documentation
• Genealogy research
• Archiving family records
• Creating printable family posters
• Visual storytelling of ancestry

📂 Requirements

• Excel Desktop (Offline only)
• Macro / VBA enabled
• Not supported on Excel Online