Charts & Forms » Spreadsheets

Airtable Research Log by Carolyn Guntur

This is the research log Carolyn uses in her work as a professional genealogist. It is also used in an e-course she teaches.

Airtable Research Logs - Family Locket

Nicole Dyer has designed several Airtable Workspaces for Genealogy. They are summarized in the blog post at the link, which contains links to the templates. They are useful for research logs, cluster genealogy and DNA matches.

Census Tools Electronic Spreadsheets $

The CensusTools Spreadsheet Pack includes census spreadsheets for the US, Canada , England, Ireland, and Scotland as well as state spreadsheets for Iowa, Kansas, Massachusetts , Minnesota, New Jersey, New York, Rhode Island, and Wisconsin.

CensusMate - Census Worksheet For Genealogy and Family History

Easy Genealogy Forms

Easy Genealogy Forms

Pedigree charts and family group sheets to download and print from your word processor or spreadsheet programs. Available in Macintosh or PC formats.

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.

Excel-ling Genealogists (Facebook) New!

For those of us who couldn't solve our genealogy brickwalls without the diligent and tenacious use of Excel.

Family History Fanatics - Using Spreadsheets for Genealogy Research

Family Tree Template - Google Sheets

Google Family Tree Template allows to collect GEDCOM-style data as linked sheets. You can walk it through by clicking links to parents, marriages and children. Such complete view on family tree members might be sometimes helpful and convenient.

Free Family Tree Template | Printable Blank Family Tree Chart

Create and print a multi-generational family tree or horizontal pedigree chart using a spreadsheet. Multiple designs and formats available, including portrait and landscape orientations.

Genealogy Research Log in AirTable

Genealogy Research Log Template by Relatively Curious.

Golden Channel Publishing - Early Federal Census Worksheet $

Take the pain out of attempting to extract meaning from the early federal censuses from 1790 to 1860. Enjoy either the Premium Edition for Microsoft Excel

How to Create a Timeline in Excel

Create a historical timeline using the Excel Timeline Template.

Office.com Templates - Search results for family tree

Microsoft offers free family tree templates and invitations that are perfect for your next family reunion.

The Shy Genealogist - New Group Sheets – Word and Excel

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

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

Timeline Grid Templates

U.S. Census Returns and Blank Forms for Recording Returns ^FREE

1790-1930, downloadable spreadsheet forms.

USGenWeb Free Census Project Help, Census Templates and Spreadsheets

MSExcel Spreadsheet, MSWorks Spreadsheet, and Tab Text Templates for transcribing the U.S. census from 1790-1940.