US Census Spreadsheets
Date: 01/24/2001 7:14:31 AM Eastern Standard Time
(Edward H. Gaulin)
Here's something to take a peek at - a very useful US Census spreadsheet. See URL and explanation below.
Subject: [GM-L] Census Spreadsheet Website
Mon, 22 Jan 2001 20:32:19 -0000
From: "Gary Minder" firstname.lastname@example.org
Last week I posted a note offering to share a U.S. census spreadsheet that I developed so that I could get out from under my unruly mountain of census
data paperwork. The response was overwhelming.
To date I have e-mailed over 600 copies of my spreadsheet and I can't keep my inbox empty for more than a few minutes! I have also received scores
of kind e-mails with glowing praise of the spreadsheet. I knew I was tired of
not having a good way of organizing census records but I had no idea that so many others were in the same boat.
To reduce the load and to allow me to get the word out to more genealogists, I have created a web site where anyone can go to download the
spreadsheet. The URL is:
and you can also get look at some screen shots of the spreadsheet and read a Frequently Asked Questions list that I created to answer common questions. To top it off I
created a discussion forum where users can ask questions and get answers (a much more efficient way of getting info out than answering individual
In less than 24 hours online, the website has gotten over 900 visits. If you missed my notice the first time, please stop by the website and take a
Gary Minder email@example.com
I checked out the web site, and clicked to view the Microsoft Excel workbook:
Note the worksheet tabs for each of the US Federal Census
years. As you can see from these two screen shots, Gary has provided CLEAR,
accurate census extraction forms.
The forms for other census years are clearly labeled at the bottom of the
first Excel worksheet as shown below:
You may RIGHT CLICK on the web screen to save the census worksheet, though
you'll need Excel97 or greater to view and use the file.
I recommend when opening the
file (worksheet) that you IMMEDIATELY rename the file to preserve the original
blank worksheets. You can rename by clicking FILE on the Excel menu
bar, then selecting SAVE AS, and providing a new name for the file. If I were
doing the work on Ferd GOERING's family throughout the four census years I've
discovered him, I'd call the file GOERINGf. Where I have an entry for
his son as head of household, I save the file as GOERINGch for Charles Henry
Those new to Excel will recall that to see other worksheet tabs
(1840-1920), you'll want to click the "NEXT" button found in the
extreme lower left of the Excel workbook (circled in red above.)
Happy family tree climbing!
Your friend in genealogy