Excel Video #2: Collecting FamilySearch Information

Building a surname database can take quite a bit of time. Entering the information that you see in books or microfilms can be tedious, especially when all you want to do is KEEP SEARCHING! But it can be so rewarding when you begin to see connections that you hadn’t seen before because your information in Excel is formatting to help you see items that are easy to overlook when reading documents individually.

While adding information one line at a time will be very helpful, it can be even more helpful if there is already data in the document that you can begin to compare with. When I begin to research a new family – or when I look for information on a family that I haven’t researched in a while – I always turn to FamilySearch first. The search form on the website is easy to use and the format of the information is perfect to transfer into an Excel document. Keep in mind that this type of searching will only return results from data that has been indexed within FamilySearch – not necessarily from each microfilm that is available using the technique discussed in the last video – which you can watch in the “Video Tutorials” tab at the top of the blog.

In this video tutorial, I will show you how to search a specific database for a specific surname and then to download the information directly into Excel. Depending on your search terms, this can provide you with information on every person with a specific surname over a specific time frame to begin filling your database with very little typing on your part!

I will also show you how to quickly get rid of rows and columns of information that you don’t need and then how to combine different Excel files into one combined database. Finally, I will show you how to quickly adjust the width of the columns to make the page more readable.


Looking for Russell Co Marriages?

When you get on the FamilySearch website and look at the list of available marriage records for Kentucky, you might get excited. And then you click on the link and scroll down to the link that says “browse through images”, you’d expect to see a list of counties to click on. Instead, you see a screen full of numbers.


But which one is Russell County? You might click on a few numbers to see if you can get lucky, but there are a LOT of numbers and pretty soon, you just give up.

Recently, I was able to find some marriage records for one of my ancestors so yesterday, I took the time to make some notes so that I’ll be able to find these records easier the next time. I thought you might find the list helpful as well. The following links are the first 10 marriage books specifically for Russell Co, Kentucky.

v. 1 – 1826-1854 (Begins with Image 6)
v.2 – 1854-1860 (Image 62)
v.2 -1861-1867 (Image 5)
v.3 – 1867-1875 (Image 358)
v.4 – 1875-1787 (Image 5)
v.5 – 1876-1880 (Image 146)
v.6 – 1880-1883 (Image 480)
v.7 – 1883-1886 (Image 5)
v.8 – 1886-1889 (Image 348)
v.9 – 1889-1892
v.10 – 1892-1895

If you aren’t familiar with the microfilm viewer on FamilySearch, take a look at the video “Finding Information on FamilySearch” in the Video Tutorials tab at the top of the blog.


Surname Collecting

I am a name collector, I’ll admit it. When I first started doing genealogy research, I would look through a book or a microfilm and only copy or save information that I knew belonged to my ancestor. But sooner or later, I’d read something and think to myself, “where have I seen that name before?”. Of course, I would spend hours trying to location the information that I had not bothered to copy down originally.

So then I changed my plan to begin to copy EVERYTHING that had my ancestor’s surname in it. I had an index card with all of the surnames in my tree and if I was looking at a new book or microfilm, I would copy everything I could find from any of the surnames on my list. Clearly, that was not the best plan either as my piles grew larger, but I would still be saying, “where did I see that?”

So I turned to Excel once again. I began building a database for each surname. Every time I found a mention for a certain surname, I would enter the basic information into the Excel document, along with some indication of where the information came from. It was slow going because it was not unusual for me to decided to add the information “later” – which sometimes never came around unless it was the specific surname I was looking for at that time.

But then….the internet! The amount of genealogy information to be found on the internet is growing by leaps and bounds. For some surnames, it’s difficult to keep up with all of the new information out there! But there are ways to collect the information fairly easily and I’d like to show you how.

I’m beginning a new video tutorial series. This time, I’ll be showing how to build a database using Excel. As before, my purpose is to show how to use a variety of features in Excel but to do it in such a way as to allow you to follow along and to create something helpful to your genealogy research by the time we are done. I’m going to show how to collect all of the information that I can on one surname in a specific place and to organize the information in a way that will allow us to find information that we might have missed otherwise. It will show us different ways that a person’s name might have been spelled or nicknames we might never have thought of. It will show us relationships that we might never have considered before – or give us the proof that we’ve been looking for to confirm a relationship. The goal is to have all of this kind of information available in one document and to be able to view it in different ways to find matches among the people in the database.

For this series, I’m going to concentrate on collecting data from FamilySearch. If you’ve never used FamilySearch before, you are in for a treat! And even if you are very familiar with FamilySearch, I hope you’ll learn some cool features in Excel that you will find very helpful.

In this first video, I’m going to show you how to find out if microfilm images might be available for viewing online without ordering the film. I spend time showing how to find the images and how to use the viewer and image controls on the FamilySearch site. You might be surprised at how much you can find from home!



Family Land Sheet – Final Touches

This is the 6th and final tutorial video for the “Family Land Sheet”. My goal with the videos has been to show various functions within Microsoft Word while creating a genealogy form that you won’t find anywhere else. It’s really about how to use Word, but with a fun example to work with.

In this video, I’m showing how to change how often Word automatically saves your document as well as showing how to add an automatically updating date in the header and the file path for your document in the footer. No more looking at printouts and trying to remember what you named the file or where you saved it on your computer!

I also show how to add an “object” within the Family Land Sheet. Inserting objects is a way to add a document within a document and have it update automatically. In this case, I’m adding a Family Group Sheet to the Family Land Sheet so I can quickly see relationships for the subject. When an update is made to the original Family Group Sheet, the information will automatically be updated within the Family Land Sheet. (Did you notice that this video is all about letting Word do work automatically?)

My plan for my next video series will be showing how to collect information from FamilySearch and use the information to build a database within Excel. Once again, the purpose will be to show how to use Excel, but hopefully, you’ll have a helpful database full of information on your family once you are done.

Stay tuned for that!


Now Where Did I Put That Again?

As I’ve been working with my own Family Land Sheets, I’ve been amazed at the number of documents that I can tie into my sheet.  Not just deeds, but transcriptions, court records, marriage records, probate records, and even group sheets and maps. And it doesn’t matter how organized I am with my file naming or folder organization, sometimes, it just takes time to drill down to the correct folder to open a file to double check exactly what it said. That’s where hyperlinks come in. Once you’ve hyperlinked a document to some specific text or image in the Land Sheet, it only takes a single click to open the document or web page.

In this video, I’ve shown how to add hyperlinking within the body of the document, in the endnotes and in the comments. I also show how to add a hyperlink with your email address if you want to share your document with other researchers as well as how to add a bookmark so you can add a hyperlink to jump to a specific place within the document.

I’m only planning one more video using the Family Land Sheet as an illustration. After that, I’ve got some ways to use Excel coming up!

Unexpectedly Emotional

My husband gave me a wonderful birthday gift this past week. We rented a houseboat for a few days and traveled around Lake Cumberland, specifically to see the area where John M. Smith and his family lived. Most of his land is now under the lake, but I had been able to map with pretty good precision one piece of land and we were able to tie our boat to a portion of that land and spend the night there. As I walked on the land that we were able to get onto, I picked up rocks and fossils and collected a few leaves to press and found I was surprisingly emotional about being there. John died in 1835, but to know that I was on land that he had to have worked so hard to obtain gave me feeling of closeness that I would not have expected to feel.


We picked an excellent week to go! The weather was lovely – not too hot during the day (but hot enough to swim and float!) and chilly enough in the evenings to make wrapping up in a blanket feel extra cozy. I loved hearing the sounds of nature that John and his family would have heard. In the evenings, we would sit and look up at a gorgeous display of stars, unhampered by the lights of any town and wonder how often he and his wife had gazed up at the night sky. We heard owls and perhaps a fox yipping and it was almost too much to take in. Later in the week, we even saw 2 eagles flying over one of the channels as we cruised our way around the lake.

In the mornings, a gentle mist would rise from the water and my husband was able to do a little fishing as the sun came up. It was so peaceful, I never wanted to leave!


It was a beautiful area, but I was amazed at how steep the hillsides were. How would you farm such an area? At the end of the trip, we drove a little to find a couple of cemeteries and I noticed that unlike where we live, which is flat…flat…flat, the corn fields we saw were smaller and were almost like puzzle pieces to try to fit into areas that were flatter.

At the Jamestown Cemetery (where most of the cemeteries that were below the the water line of the Lake had been moved) I was able to find the grave stones for my ggg-grandparents – George and Talitha Smith.

img_2843George was the oldest son of John M and even though I had seen pictures of the stones on Find-A-Grave, it was even better to be there and to touch the stones. There were a couple of “empty” spaces next to George and I have to wonder if that might be where John M. and perhaps his wife were moved to – without a stone. George was the longest surviving child of John M’s. I think I have glossed over him in my research because of my zeal to find the parents of John M. I will be expanding my research for George now.

The trip had been promised on my birthday in July, but it was a last minute decision to hit the road. Being late in the season, we just about had the lake to ourselves – at least, that’s the way it felt. But how I wish I had taken the time between my birthday and the actual trip to think about things I would want to do while there. I would have taken time to look at the Russell County library website to see if there would books that I could have taken a look at. I would have used the addresses I had found for my great-grandparents in the later census records and driven out to see that area. I would have done more mapping of land parcels to see what I could find. I would have created a database on cemeteries to visit – especially now that I know how incredible if feels to be there rather than just to see pictures that others have taken. Looking back now (a whole day after returning home!) I see that I could have done those things while there (we did have internet access through our phones) but it just didn’t occur to me!

I will certainly begin creating that list now as we are in love with the area and will certainly be back!

Word Comments and Endnotes

I have to admit, this is one of the videos for using Microsoft Word that I’ve been most excited to create! I see so many applications for using comments and endnotes in my research process that help me figure out my research puzzles and I couldn’t wait to share!

I’ll be the first to tell you that my brain is not what it used to be! I tell my husband that it’s because my brain is so packed with important information there’s just no room for anything else! But with our busy day-to-day schedules, I don’t always have the time to devote to genealogy that I’d like.  Being able to add comments – what was I thinking here, why does this name sound familiar, what record was I going to follow up with next – is a necessity if I want to avoid always having to retrace my steps to figure out where I left off last.

But just having a monster list of comments isn’t as helpful as it could be. In this video, I show how to categorize comments and how to hide certain categories so that only specific comments are showing at a time.

I also use endnotes quite a bit – but not just for citations. For a project like this, when I’m not certain which records apply to my ancestor, I use them to remind myself of relationships or dates or other tidbits of information that can help me prove that a person is related to me and how that relationship branches to me.

This video is longer than I was hoping it would be. Around 20 minutes. But the topics are so interrelated, I didn’t want to split it into 2 videos. The features covered in this video are a little more advanced so I hope you’ll learn something new when you watch!

Using Color to Analyze Data

We’ve been building a “Family Land Sheet” in order to collect and analyze information from a lifetime of land transactions for an ancestor. I wanted a form that would be similar to a Family Group Sheet so that I can be certain that I’ve collected all of the clues from each transaction that same way that a Group Sheet collects clues from the children.

This time, I want to show you 4 different ways to use color within your FLS to help you analyze the information that you have collected and to see patterns at a glance.

I had originally planned to do one video covering adding color, comments and citations, but I want to keep these videos short, so the new plan is to make 2 shorter videos to cover all three concepts. I hope you enjoy it and find it helpful in your research!

Filling in the Family Land Sheet (FLS)

In my last post, I created a video to show how to use Microsoft Word to create your own Family Land Sheet. The great thing about creating your own forms is being able to include the information that YOU think will be most helpful in your research. The FLS is my own personal research buddy that helps me see patterns that I probably wouldn’t see just by reading and even transcribing documents and it remembers everything for me because my brain sure isn’t what it used to be!

As I begin to enter information into the FLS, I’ve stated that the goal is to collect information from every land transaction involving any John Smith in Mercer County. Then, I’ll analyze the information to see if I can determine a way to tell different men with the same name apart.

Once again, I’ve created a video showing all of the steps involved in getting information into the form as well as ways to make the information as readable as possible. In the video, I use an Alt code to enter a £ and I mentioned that I’d include a link to other Alt codes in the blog, so here it is!

Alt Code Cheat Sheet

I’ll take the time now to say that there are ways other than using Alt codes to make these symbols, but I personally am partial to keyboard shortcuts so that’s what I normally use.

Family Land Sheet – Word

Introducing – Video Tutorials!

Yesterday, I wrote about why I decided to create a new form to track a lifetime of land transactions for my ancestors. Digging deep into the lives of our ancestors often means looking at land deeds. Deeds can help us determine family relationships

Deed 1 and the names of neighbors.

Deed 2If an ancestor is selling his land, the wife’s name is usually included in the deed.

Deed 3Dates of deeds can tell us when a person has died or moved away from an area. Clues in deeds can also help us distinguish between men with identical names.

Deed 4

But sometimes, reading those deeds can get confusing, especially if your ancestor had a lot of land transactions or if the land was described with metes and bounds.

Deed 5

For all those reasons, I decided that I wanted a form that is similar to a Family Group Sheet, but to have the focus be on all of the land records instead of all of the children. So I created a “Family Land Sheet” to help me organize my information and to help me look for clues that are so easy to overlook.


Today, I’d like to show you how to create your own Family Land Sheet in Microsoft Word. I started trying to type out the instructions, but it was getting rather lengthy, so instead, I decided to try my hand at creating a video.

I have been thinking for quite awhile about making a series of videos on how to use Word and Excel, but I kept getting tripped up by thinking of what to show in each video and how many videos to create. I know that some people would have very little experience and would like to see “beginner steps” and others would be bored with seeing videos showing basic skills. So I’ve decided that I will show how to create specific items within Word (Excel examples are coming as well) and over time, a variety of skills will be covered.

I’ve created a YouTube channel and I plan to add videos there as well as embedding them within my blog. I’ve added a page to the blog (see the top tabs) that will keep all of the videos without the extra blog text. This is an evolving plan, so I don’t want to over promise, but I am excited to build a “library” of videos geared specifically to genealogists for you to watch whenever you’d like. I hope you find it helpful!