The U.S. Census Records are a very valuable source of genealogy information for your family. Click on one of the underlined links listed below to download the file. Each census has a different format because of the questions asked by the census enumerator.

File Format for Entering U. S. Federal Census Data - [Excel97] Data can be directly entered into the workbook and printed for each family with a listing on the first sheet for the head of household for each family. Copy the form (Sheet Z) by clicking the Z (as shown in the example) and selecting Move or Copy Sheet, and check Create a Copy to preserve all of the formatting within the form. Place the new sheet before Sheet Z and rename to A. Repeat for the second sheet renaming it as B and the third sheet as C etc. Add the name of the sheet and the Head of Household to the List sheet so that you can quickly determine what sheet to select to locate your information when you return to the workbook later.

The name of the Street was included in the Census for 1880-1940. The second column below identifies the cell to enter the street name. The street name will display vertically.

1940 U.S. Federal Census (61KB)* B10 Excel Snip
1930 U.S. Federal Census (41KB)* B7
1920 U.S. Federal Census (42KB)* B7
1910 U.S. Federal Census (40KB)* B5
1900 U.S. Federal Census (31KB) A6
1880 U.S. Federal Census (29KB) A5
1870 U.S. Federal Census (31KB)  
1860 U.S. Federal Census (28KB)  
1850 U.S. Federal Census (28KB)  

*Note: If 2 columns are contained under 1 heading (when the left and right portions of the census are stacked) all information is entered into the left column since the spreadsheet has been formatted to center the data across the columns.

The text on the census forms for the 1940 census are so small because on an 8.5" x 11" sheet the page displays at 52% of original size. Also the digitized census forms are excellent so you may decide not to use this year even if you use find the other years beneficial.