Before My Time is about the ancestry and extended family of my four grandparents: John Samuel Krentz (Indiana/North Dakota), Margreta Tjode Hedwig (Gertie) Buss (North Dakota), Rosmer Pettis Kerr (Pennsylvania/Michigan), and Evelyn Elvina Hauer (Michigan), and other topics in genealogy and family history.

Archives, Labels (tags), and other links appear at the bottom of the page.

Content at Before My Time is protected by copyright and may not be copied for publication elsewhere without permission. © T. K. Sand.

To follow by email, scroll to the bottom of the page.

Tuesday, April 24, 2007

Cool Tools for the Census-Challenged Genealogist

I was sorting through a box of unfiled genealogy papers the other day. I was amazed at the number of census printouts I'd made since the advent of online census searching, and there are plenty more on my computer that I may never print. It's no wonder I don't know what I have anymore. Twenty years ago when I started doing genealogy, I kept a little census chart. I soon outgrew it though, and chaos quietly slipped in to take its place.

But among the census sheets, I found a printout of something else I'd forgotten, a great little Excel spreadsheet called Census Tracker, which I'd filled out with the four U.S. census records of my great-great grandfather. My excitement was quelled, however, when I remembered I don't have Excel on my new computer.

Google keeps dreaming up great new tools. When I found out their free online application Google Docs and Spreadsheets (Beta) is compatible with Word and Excel, I was eager to give it a try. I was able to upload the Census Tracker spreadsheet and work on it online, without having any spreadsheet software on my own computer.

Using this program requires a high-speed internet connection. Even with high-speed, it's still considerably slower than working with Excel on your own computer. But the Google application has some neat advantages:

  • You can invite your partners-in-genealogy to collaborate on a spreadsheet with you. The only prerequisite is that each collaborator must have a Google account. You needn't work simultaneously, but if you do, there's a chat box in the same window so you can discuss changes. Those changes appear to all collaborators as they are made.
  • Documents and spreadsheets are stored online, so you can access them on any computer by logging into your Google account. You can also download them to your home computer, work on them in Excel, and upload them again.
  • It's easy to publish your spreadsheet to the internet. Google provides the space and tells you the URL. You can then share the link by email or use it in a blog. It's also easy to generate the HTML code to view the spreadsheet in a window within your blog post. Examples of both appear below. I wish the window were larger.
  • Each individual you want to track gets his or her own page in the spreadsheet. I can choose to display just one particular page or all the pages. I do wish there was middle ground here, as I would like to display more than one page, but not all.
  • When you make changes to the spreadsheet, the blog view can be easily updated from within Google Docs and Spreadsheets. No need to edit the blog.
  • You can also easily generate a PDF file to share.

Click here for a full-page view of Joseph Meyer Schulte in the U.S. census. When I add pages for other individuals in this family, you will see one family member at a time in the full-page view, with links to the others at the top of that page. In the scroll window, you will select a tab at the bottom of the window to see the page you want.

Click here for a PDF file of Joseph Meyer Schulte and Related Lines in the U.S. census. The PDF file can be saved to your computer. Printouts from this file are attractive and do not have the headers and footers typical of internet printouts. However, I haven't found a way to insert page-breaks where they would be most logical. As a result, page-breaks may interfere with proper presentation of the data.

After publishing a post with the spreadsheet window in it, I found I was unable to edit the post.* Despite that and my other complaints, however, I think Google Docs and Spreadsheets is an exciting innovation, and "free" is a very good price. I trust Google to work out the kinks.

Census Tracker has a variety of spreadsheet templates, also free. Others include some state and international census trackers, a research log and spreadsheets to aggregate cemetery and ship manifest data.


*The edit workaround is to select the entire text of the blog post from the published view of your blog, including the spreadsheet window, and copy it (Ctrl + C). Then create a new post, paste (Ctrl + V) into the Compose Mode window, and make your corrections in the new post. Add the title and labels, and publish it. Then delete the original post. Unfortunately, any comments on the original post will be lost.

May 1 Update: I was able to edit this post today in the normal way. However, republishing the spreadsheet in Google Docs and Spreadsheets to enable viewing of all pages, not just the Joseph Meyer Schulte page, did not alter the scrollable display in this post. To do that, I had to generate new HTML code to copy and paste into this post. All sheets are now viewable in the window above. Later, when I attempted another edit, I had problems again, which seem to be related to the spreadsheet widget and Compose mode. Publishing from the Edit Html mode rather than Compose mode seems to get around the problem.


Juliane's granddaughter said...

Fantastic post and great tools. I am anxious to start using these trackers. It makes a very useful genealogical tool and to have all the data on one sheet allows for comparison between years. Also points out the disparity in answers that the same people gave 10 years apart. Thanks for creating this.

T.K. said...

Thanks, Jul's, it'll be fun to try out the collaboration feature with you.

Jake Fletcher said...

That's really cool, wish I found that before.

T.K. said...

Hi Jake, thanks for stopping by. I see you are blogging genealogy also. You might want to check out the Genea-Bloggers group on Facebook. It's a great community! Best wishes!

Blog Archive


Our Family in Books: A Bibliography

  • My Ancestors in Books (a library of resources and notes pertaining to Reverend Samuel Stone, Major General Robert Sedgwick, Elder John Crandall, and other early Americans in the forest where my family tree was grown)
  • The Zahnisers: A History of the Family in America by Kate M. Zahniser and Charles Reed Zahniser (Mercer, Pa. 1906)
  • History of St. James Lutheran Church [full title: A little of this and a little of that in the 141 year (1861-2002) History of St. James Lutheran Church, Reynolds Indiana] by Harold B. Dodge, published at Reynolds, Indiana, 2002; 170 pages.
  • Lisbon, North Dakota 1880-2005 Quasuicentennial, published at Lisbon, North Dakota in 2005; 391 pages.
  • The Paschen and Redd Families of Cass County, Indiana by Alfred Paschen, c. 2005 (Gateway Press, Inc., Baltimore, MD); 322 pages.
  • Sheldon Community History: Sheldon Centennial 1881-1981, published at Sheldon, North Dakota in 1981; 376 pages.
  • Sheldon, North Dakota 1881-2006 - 125th Anniversary: The Queen of the Prairie, published at Sheldon, North Dakota in 2006; 498 pages.
  • A Standard History of White County, Indiana, written under the supervision of W.H. Hamelle, c. 1915 (The Lewis Publishing Company, Chicago and New York).
  • The Roots of Coventry, Connecticut by Betty Brook Messier and Janet Sutherland Aronson, c. 1987 (Coventry 275th Anniversary Committee, Coventry, CT); 206 pages.
  • "Elder John Crandall of Rhode Island and His Descendants" by John Cortland Crandall; New Woodstock, New York, 1949; 797 pages.
  • "The Descendants of Robert Burdick of Rhode Island." Nellie (Willard) Johnson, Pd.B.: H & L Creations, LLC.

Followers, Friends, Family, and Fellow GeneaBloggers:

Follow by Email

Where are you?