Charts & Forms » Spreadsheets

CensusMate - Census Worksheet For Genealogy and Family History

Easy Genealogy Forms

Excel Ahnentafel Workbook Tool

This is a workbook tool to help manage an ancestor list (ahnentafel) and to generate trees drawn on an Excel grid from that list. Some features: Manage Ahnentafel/ancestor list--calculates numbers. Numbers are calculated as strings so there is no limit to the number of generations. But, this is Excel, there practical limits. Handles same person appearing in more than one place in the tree. Macros generate a tree from the ancestor list, color coded by country. This can be filtered based selected ancestors. A tree once generated, can be "shrunk" to show fewer generations more easily. Creates formatted ahnentafel output. Shows a breakdown on names and where they appear across generations.

How to Create a Timeline in Excel

Create a historical timeline using the Excel Timeline Template.

The Shy Genealogist ~ Researching Russell Co, Kentucky - Archives: Excel

A series of blog posts for using Excel to create genealogy research forms.