Feed on

Gary Minder of Poulsbo, WA  has created and offers for free incredibly useful spreadsheets for some of the most important genealogical data we will find  in our research. He requests a small donation, but the utility far exceeds any cost. His work can be found at http://www.censustools.com/

Gary says: Ever try entering extracted census data into your genealogy program’s primitive text editor? The mess and frustration led me to create my first spread­sheet in 2001 so I could elec­tron­i­cal­ly preserve my data in an easy to view format. 40+ free genealogy spreadsheets later, CensusTools continues to grow, providing researchers with quality creations to electronically record, preserve and archive family history data.

Record and Analyze
Using a spreadsheet is a great way to record your genealogy data in a format similar to the original source. All of my census spreadsheets faithfully reproduce actual census document formatting, providing you with a professional appearing product suitable for printing or including in your published family history. CensusTools spreadsheets are also valuable analysis tools. The Tracker series allows a researcher to analyze all available census data for an individual on a single worksheet! At a glance and in a very professional appearing report, you can trace the important aspects of your ancestors’ lives. Your pile of census data, difficult to analyze and evaluate scattered about in a pile of extraction sheets, comes alive when properly organized!

U.S. Federal Census
Starting with just a 1790-1920 U.S. Federal spreadsheet, the CensusTools collection expanded to include 1930, available separately and included in the 1790-1930 file, and several U.S. special census records. Complimenting the Federal spreadsheet files are the 1850-1860 Slave Schedules, 1850-1880 Mortality Schedules, 1883 List of Pensioners, the 1890 Surviving Veterans and Widows Schedule and Dawes Roll.

State Census
Often overlooked as a genealogical resource, many individual states conducted their own census operations, usually at 10 year intervals between federal enumerations. Of particular interest are records from 1885 and 1895 which can help bridge the 1880-1900 federal gap caused by the loss of most of the 1890 records. CensusTools currently offers state spreadsheets for Iowa 1836-1925, Kansas 1865-1925, Massachusetts 1855-1865, Minnesota 1849-1895, New Jersey 1855-1915, New York 1825-1925, Rhode Island 1865-1935 and Wisconsin 1836-1905. Each set collection features the main spreadsheet as well as a Tracker and Checklist.

International Census
CensusTools went international with the release of spreadsheets for Canada 1851-1901, England 1841-1901, Ireland 1821-1911 and Scotland 1841-1891, all similar to the U.S. Federal in design.

Cemetery Data
The CensusTools Cemetery Data spreadsheet enables a researcher to record data in two generic formats. The “Cemetery Listing” worksheet is formatted to record multiple burials in a single cemetery. By using the “Family Listing” worksheet, family members buried in different cemeteries can be grouped together.

Passenger Manifest Data
Though there is no standard format for passenger ship records, the CensusTools Manifest spreadsheet includes common, genealogically significant data fields to record your immigrant ancestor’s arrival in America. This spreadsheet also includes two worksheets, a “Ship Listing” and a “Family Listing”, similar in purpose to the Cemetery spreadsheet.

Research Log
The CensusTools Genealogy Research Log is a tremendous resource which allows the user to check off data types researched for any person in their database. There are over 125 data types listed, from the obvious like birth certificates to the obscure such as tombstone rubbings. In addition, there is a column listing 40 online data sources with links provided for easy access. Say goodbye to the frustration of forgetting what data types and sources have already been reviewed for an ancestor!

Family Group Report
The CensusTools Family Group Report can be used in place of commercial genealogy software. Finished worksheets can be shared with family and friends via e-mail, printed for hard copy records or book projects, or exported from Excel in HTML format for a web page presentation.

All CensusTools spreadsheets were created with MS Excel and saved in Excel 97 format. A version of MS Excel for PC or MAC at least as recent as 97 is required to use the spreadsheets. My compatibility page provides more details. PDF versions of all worksheets are available for anyone without access to MS Excel or to those who just want high quality extraction sheets.

Gary Minder
2051 Marina Vista CT NE
Poulsbo, WA 98370

One Response to “Spreadsheets for Census Data”

  1. Lindsey says:

    You have to pay for these now, any other ideas where I can find something like that?

Leave a Reply