click to view original photo

Organizing as you Research

It's so exciting to do the research that we all sometimes forget about organizing so we don't duplicate our efforts. Here are some ideas that may help you organize as you research.


Content Details

Type: Article
Resource: GenWeekly
Prepared by:
Word Count: 1413 (approx.)
Labels: Census 
Short URL:

I know I have been guilty of it, and maybe you are too. I love the thrill of the hunt. I will start a family history research project and find all kinds of great information including, births, marriages, even a few skeletons, and then that gets me excited to look for more stuff. Pretty soon I've made a lot of copies of web sites, census lists, pedigree charts, and other documents. I neatly pile all of it somewhere and half-way forget about it; then start the process all over a week or so later because I haven't documented anything and forget what I have already found. It's so exciting to do the research that we all sometimes forget to organize it so we don't have to do it all over again. Here are some ideas that may help you organize as you research.

Utilize your Genealogy Database

As I research a family, I always keep open two windows on my computer. One is my active window with whatever web site I am researching, and the other is a window I have minimized with my PAF file. (To minimize a window just click on the first button with the little straight line _ on it on the top right of your browser). This way I can enter information into my genealogy program as I find it. Sometimes I am entering dates and places that I find as I research. This also allows me to add in the source fairly easily -- and while I can remember! It also provides me the option to "cut and paste" information that I find that I may want to check out later or read more about. By keeping two windows open on your computer, you are saving yourself time and you don't need to print out all your findings and then enter them into your database.

Utilize a Research Calendar

Some sort of research calendar, one that you like and will use, can help keep your research organized and help you remember what you have looked at and what you haven't yet found. You can find pre-made forms on web sites like www.familytreemagazine or from the web site for the BYU TV series Ancestors,

I tend to only use forms that I can type in and can use on my computer. A form that I use that I learned about from a presentation last year at the FGS conference, is to create a table (you can do this in Microsoft Word or another word processing program) with 4 to 5 columns. The first column is for a document number. This is a number that you assign to a document in your file, for your personal reference. The second column is for the date you searched the resource. The third column is the name of the resource. The fourth column is for the name of the repository and call number for the resource. Finally the last column is where you state the purpose for the search and the results of the search. So, for example:

Document # Date Resource Repository/Call# Remarks

1 15 June 2006 Legacy of Faith: the Life History of Mary Ann Smith McNeil… by Herbert A. Hancock Family History Library, 921.73 M233h Purpose: To find a list of Mary Ann's children.Results: Children are listed throughout text and include a picture of each on page 371.

2 16 June 2006 1910 U.S. Federal Census. Year: 1910; Census Place: Douglas Ward 2, Cochise, Arizona; Roll: T624_38; Page: 19B; Enumeration District: 18; Image: 1116. Purpose: To find a list of Mary Ann's children.Results: Census shows 4 of Mary Ann's sons living with her, Ephraim, age 34; Jesse, age 22; Frederick, age 16; and Don Carlos, age 14.

Now you can personalize this form in whatever way makes most sense for you. You could add a column to use as a timeline of the person's life. Also, I go to "page setup" found under my file menu in Microsoft Word, and I choose the landscape orientation so that the form "fits" better on the page. I also insert a header that gives the name of the family and the date. To insert a header in Microsoft Word, go to the View Menu and click on "Header and Footer".

Using Spreadsheets

Spreadsheet programs allow you to organize your family history in ways that can help you track the family through time. Spreadsheets can help you look at a family as they are enumerated in the various U.S. Federal Censuses, and you can even add the appropriate state census. With a spreadsheet you can create a timeline for an individual or a family. Spreadsheet programs also allow you to 'manipulate' your data, meaning you can sort the columns so they are alphabetical or by date. If spreadsheet programs such as Excel intimidate you, you can set up a table in your word processing program -- you just won't be able to sort the data like you can in a spreadsheet program.

Beau Sharbrough shows on his Roots Works web site how to organize your genealogy using Microsoft Excel spreadsheets, He provides examples of Excel spreadsheets and how they can be used to track land records, vital records, and the U. S. Federal Census. You can be inspired from his example to then create your own.

Another great site that provides downloads of Microsoft Excel spreadsheets that you can use to track everything from the federal census, state census, cemetery logs, passenger records and other data is found on the web site Census Tools, Census Tools. One of my favorite spreadsheets is the Research Log, which serves as a great checklist to remind you of what resources you have looked into and what resources you need to look at next. This web site is free, but you may consider sending a donation to keep this web site free and available.

Colleen Fitzpatrick's book, Forensic Genealogy, includes a chapter entitled "The Database Detective," in which she illustrates using tables and/or spreadsheets to document families and search for patterns. She covers everything from setting up a database to examples of spreadsheets that utilize primary record research and common genealogical resources like city directories. To find out about ordering Forensic Genealogy, check out Colleen's web site at, Forensic Genealogy.

I have been working with spreadsheets to help get a better perspective of the research I am working on. In one large scale project I am conducting which revolves around 100 women who are listed on a friendship quilt, I have created a spreadsheet that lists the women's names down the first column and then each column after that helps me track each woman in the 1880-1930 censuses; then I have included additional columns for resources including an online newspaper index, an online obituary index and an additional column for indicating relationships between the women and comments. So each woman is listed on her own row within the spreadsheet, with information about her. I can use this as a timeline for her life and to look at similarities and difference between the women in this community. For example, since I do not know who made the quilt, I am trying to see what the commonalities are between the women, hoping this will provide with a clue to the maker. The spreadsheet has allowed me to track how many of the women work at the same cigar factory and what their occupations are inside the factory. It allows me to get a visual representation of the research and the women involved.

Using Forms

Other forms exist on the Internet for organizing your genealogy. Cyndi's List provides links to charts and forms both free and for sale at Supplies, Charts, Forms, Etc.. A great form for using when researching deeds can be found at This web site, Do History, also includes a toolkit where you can learn more about 18th century writing, probate research, and "reading a cemetery." The goal of the site is "A site that shows you how to piece together the past from fragments that have survived." The case study used for this web site is that of Martha Ballard, a midwife whose diary was published by Laurel Thatcher Ulrich in A Midwife's Tale.

Another web site that includes forms to stay organized is Family Tree Magazine, Family Tree Magazine Free Forms. Forms are available for download as either a PDF file or a Text file include Research Repository Checklist, Note Taking Form, Research Journal, Statewide Marriage index, Research Calendar, and Deed Index Forms. With 38 forms in all, there should be at least one from on this web site that you can use in your own research.

Source Information: GenWeekly, New Providence, NJ, USA: Genealogy Today LLC, 2007.

The views and opinions expressed in this article are those of the author and do not necessarily reflect the views of Genealogy Today LLC.

*Effective May 2010, GenWeekly articles that are more than five years old no longer require a subscription for full access.

<< GenWeekly

<< Helpful Articles