How To Complete an Indexing Project

AI Generated

This past winter I spent many hours indexing the Johnson Funeral Home and Furniture Store records that I acquired at a local online auction in November 2023. The funeral had been in operation since 1901 and the collection contained many loose documents, such as burial transports and tombstone orders, to eight Daybooks that recorded funerals and items sold from a furniture store that the family also ran through 1991.

This blog article is the How To from begin to end of an indexing project.

Obviously, the first step is to determine if a document is important to preserve. Ask yourself if it contains a:

record that states names, relationships, and/or

dates of residence in a location, and/or

mentions a particular community event.

If so, then this is a record worth preserving. Think about it, there may not be another record available that shows the named individuals in that location on that date. City directories and phone books are important but they don’t narrow down a family’s location to a particular date.

Next determine who owns the rights to the record. If it is a family, will they provide you, in writing, that you may scan, index, and share the information? If it is an archive, will they house not only the record but also have technology available to make scans and the index available to patrons?

Once permissions are received it’s time to appraise the documents. Are they in fragile condition? Are they moldy? Are they dirty/dusty? Do they have a funky smell (seriously!)? If so, then you will want to speak with a preservationist about containing the damage before proceeding.

In my case, there were no funds available locally to hire a specialist so I reached out the Transitional Genealogist Forum and asked for advice.

It was recommended that I spray a microfiber towel with Lysol, peroxide or rubbing alcohol to prevent possible mold from spreading. This was done outside on a warm day, allowing the books to dry naturally.

I then placed each book in an individual plastic bag and  froze them in my freezer for 48 hours to kill any mold spores. Some of the books had water damage and smelled moldy. They were housed in a building that showed visible signs of mold on the walls. I did not want to spread the mold in my home and later, the archive where I was going to be donating them.

The books were then defrosted in my garage which was 60 degrees Fahrenheit for 24 hours. I then took a microfiber towel and again wiped down the covers, spine, and each page. The books were ready for scanning.

I decided with my local genealogy library to use their oversized scanner as the books were large and would not fit completely on my home scanner. I brought along a thumb drive. Working with the librarian, I adjusted the scanner setting to their recommendations and saved each page, cover and spine that had writing on it to the thumb drive. I had to use more than one thumb drive as the images were large and there were many. After each scanning session I saved the images from the thumb drive to my desk top computer and to a stand-alone hard drive and a cloud. I didn’t want to lose the hard work I had invested in scanning!

It took me a month of scanning four full days a week to have all the records recorded. I placed individual papers in acid free sheet protectors as soon as they were scanned. The books were taken home and housed in case I discovered, while indexing, that the scan was incomplete or blurred. There were two scans that needed to be redone.

Next up was indexing the records. I used Microsoft Excel to set up a database. Since each record book and the individual papers contained varying information, I selected the following headings to keep them consistent as I wanted to combine all the information into one database eventually. First, though, I indexed each book to its own tab. The headings were “Original Name,” “”Book Name,” “Page No.” (if any,) “Image No.”, and “Date”(if any). I later added two more columns – “Verified Name” and “Notes.”

I opened each scan and recorded all the information I could find under the heading names, noting anything interesting under notes. For example, sometimes a marriage date or a spouse’s name was given.

I did try using AI to index but the yellowed pages, written with pencil in poor handwriting and with varying spellings was not something AI I had available could handle. It took me another four weeks to index all the information.

Verifying the indexed information is just as important as recording it the first time! I wish that there were others who could have checked my work but unfortunately, due to family situations others who had volunteered could not assist at the end. So, I had to find a different way to double check my work.

It became apparent that names for the same individual were spelled differently throughout the documents. Sometimes a person would be recorded as Mrs. John Smith and later, Mrs. Betty Smith. I wanted family to be able to find their ancestors quickly so I combined all the individual tabbed databases into one filtering the name column so I could find separate records for the same person. I then used online sources, such as death certificates, public trees, census records, city directories, church records, marriage records, and yearbooks to validate that the individual was the same person. Was Mrs. Betty Smith the same person as Mrs. John Smith? Only thorough research could answer that question.

This is where the note column came in handy. In my Smith example, I could record how many people in the area during that time had the same name. This means I was not always verifying a particular individual made the record but that there were several people with that name in the area at the time the record was made. It will be up to the researcher to analyze the information further to determine exactly which Betty Smith had made the record.

Lastly, I wrote a brief explanation of:

                How the books were acquired

                The businesses address, owners, and years in operation

                How the collection was prepared for indexing

                The condition of the books

                Who to contact if errors were found and needed to be corrected

Then, I was ready to contact the archive and schedule a day/time to turn over the materials. Per their request, I sent the images and index via email.

Now it was time to share the resource with the general community. Otherwise, how would researchers find the index? I spoke with a local newspaper reporter who published an article. The local genealogical society will publish an article in its newsletter. I’ve updated the county resource guide to include the new index. Getting the word out is your important last step.

Preserving Your Records – Do It Now!

June 1982 Flood, St. Petersburg, Pinellas, Florida

Was watching the news and saw a drone image of the Shore Acres neighborhood of St. Pete., Florida after Hurricane Idalia went through. Looks like my old stomping grounds flooded again.

The photo above is me with our dog, Misty. The flood was unexpected and not due to a hurricane, though hurricane season had begun. It was the result of heavy rainfall and a high tide. Luckily, the water stopped before entering our home.

Hurricane Elena, September 1985

We weren’t so fortunate three years later when Hurricane Elena decided to sit offshore for two days. We lost all furniture (shown above) except for the crib, which was on high casters, and our kitchen table and chairs which were made of solid wood. Every appliance was shot – refrigerator, stove, dishwasher, washer, dryer, water heater, and air conditioner. All the flooring had to be replaced. So were the baseboards and lower part of the wallboard. That meant walls that had wallpaper had to be all redone and other walls needed to be repainted. A window had broken when a branch hit it, letting water in, and slashing the drapes. The wind whipped through the house and knocked mirrors and pictures off the walls. We had no phone or electricity for 3 weeks as we had to let the lines dry out. I don’t even like to think about the yard cleanup – dead fish, snakes, and insects hiding under the sea grass, branches, and assorted debris blown in from who knows where.

The pic below is from a different storm, Hurricane Frances. By then we had moved to Tarpon Springs. Our home was spared but a large branch of an old oak in our backyard wiped out our neighbor’s fence as it fell. Insurance didn’t cover it so we took turns with the chainsaw to cut it up, and lug it to the front, for the city to pick up. They weren’t really happy about it, either.

11 Sep 2004

My heart goes out to those who are rebuilding once again. As I mentioned above with Elena, Idalia didn’t even make landfall in the Tampa Bay area but it caused widespread damage there. That area is overdue for a 100-year storm which makes the likelihood of another disaster on the horizon increase.

I’m not trying to invoke fear; I’m trying to point out that one day the big one will arrive.

If you don’t live in Florida don’t get a smirk and think this doesn’t apply to you because it unfortunately does – fires, floods, tornadoes, derechos, hail storms, snow storms, and the list goes on, can affect you wherever you reside.

If you haven’t already planned for preserving your records you must make that your priority.

I’ve blogged about it previously and now would be a good time to review that.

In an emergency, you aren’t likely going to have time to collect and save all your items. Sometimes, all you can do is grab your keys, wallet, and phone.

Rebuilding after a loss is stressful, exhausting, and mentally painful. There’s so much to do it’s hard to know where to begin. Genealogy is not going to be your priority.

Now is the time to make sure your genealogy collection is preserved.

If you have already scanned your documents check to make sure they are all preserved. Read this blog to see why and this one to get them organized. Need help on using the Cloud? Here’s how.

Sure, things can be replaced but your lifelong work of collecting photos and records would be lost. Take the time NOW to digitize. From someone who has experienced too many hurricanes to county, you’ll be thankful.

Genealogy This and That

Courtesy of 123rf.com

Last week was the first time I skipped posting a blog; it was so hectic in my part of the universe I just couldn’t find the time. If you were looking for me, my apologies!

Today’s blog will be short and sweet as I have my area’s historical society’s annual picnic to set up for in a few minutes. The weather here is frightful so we’ll be picnicking INDOORS. Sigh.

I’m happy to announce I did complete the organizational project I mentioned two weeks ago. It’s hard for me to recycle my paper files but I’ve already found how much more useful and quick those files are to recover once they’ve been scanned.

The past week I had a rush project; trying to find a descendant of a female pioneer from my area so a tombstone could be placed on her grave. You know how it is when you email someone for info and you wait and wait and wait for a response. This time, the lovely woman wrote back within an hour. The city approved the project on Monday but rescinded its decision on Friday. They wanted to connect with a descendant so I’ve just finished providing them with my contacts with the caveat that I haven’t fully researched those kinship claims.

I attended an interesting in-person local conference on preservation on Wednesday. I thought it would be about preserving buildings; instead, I learned some disturbing (to me!) information about my county’s “plan” in the event of a weather disaster. The plan isn’t a plan of prevention, it’s of how they plan to spend the federal and state dollars once the area is obliterated. I think I’m going through the stages of grief. I seem to have been the only attendee that was bothered by the slides presented. I came home and did further research and I understand where they were coming from – Florida lies on limestone so there is no way to prevent saltwater intrusion. Dikes aren’t going to work here. I discussed this with my family and we’re making our own plans. My thoughts are with the oldest genealogy book in existence, the Bible. Noah and his ark are definitely on my mind!

Heirloom Preservation

I have been so busy the past week! My family and I attended an archaeology camp all week and today is my local genealogy society’s annual conference. I’m blogging today on a previously written article that an organization had no space for as a sidebar. Enjoy!

Without a doubt, heirlooms are loved. Some are valued because they are a tangible connection to a deceased loved one. To others, the object reflects a simpler time or awe that the item survived a specific event. Heirlooms are important to us because they belong to our personal past, marking our family’s social group and reminding us of those caring individuals who came before us. Holding a book that your grandfather used to read to you can ignite a sense of security. Using your great-grandmother’s recipe can provide your whole being comfort. Heirlooms deserve to be treasured! 

Here’s how to keep your priceless object preserved for future generations:

Research the item:

  • Gather and place in chronological order all stories that have been written about the object. After reading each account, list discrepancies, noting who made the claim. Tales written closest to the time of the event may be slightly more accurate as memories can fade. Keep in mind that eyewitnesses aren’t always credible. A very young child may not understand the situation they are observing; an adult may embellish or fill in what they can’t clearly recall.
  • If no stories have been written, write it down! Ask family members for their memories; record or have them write down their version of the item’s history. 
  • Research names, dates, and places associated with the item as you would while researching your family tree. Think of the heirloom as an extension of your family history. 
  • Know that some items cannot be fully researched. My great grandmother’s hurricane lamp, purportedly bought in the summer of 1913 at Marshall Field’s in Chicago, had been passed to me with no receipt. I can pinpoint my family to Chicago, have personal knowledge that my grandmother shopped at the store and have the lamp appraised to identify a time range of its origin but it’s unlikely I will ever know for certain where the item was purchased.

Store your item safely:

  • Items last longer when stored in climate-controlled conditions that monitor temperature (60-70 degrees Fahrenheit) and humidity (not to exceed relative humidity of 75). In Florida, this likely means don’t store your precious belongings in your garage, attic or shed. 
  • For paper, photographs, or fabrics, store items in acid free containers.
  • Use cotton gloves when handling items that may be damaged by skin oil, such as old photographs, film, or metal. For other items, make sure your hands are clean before touching.

Have an emergency plan:

  • List your most irreplaceable items and their location. In an emergency evacuation, your list will be invaluable in making sure you don’t forget a priceless item in your panic. Keep the list with your important papers that you would take with you so you can easily remember what to pack.
  • If your item is too bulky to take, have a backup plan to keep it as safe as possible. Place your smaller items in durable plastic storage containers. Wrap larger items in a waterproof tarp. Elevate objects to avoid flood damage. Place them along an inner wall away from windows and doors.
  • Make sure items you want passed to the next generation are identified. Keep a copy of your evacuation list with your will, noting the name of who you are bequeathing the object. An alternative is to place a label on the bottom of the object with the name of the original owner, year it was acquired if known and who you’d like the new owner to be. When your loved ones are cleaning up after you, they can easily identify a family memento from a tchotchke. In the meantime, your treasure can be kept in its usual location where you may continue to enjoy it.

Memorial Day – Record Preservation


Memorial Day Weekend is here in the States! As many reflect on their deceased loved ones I’m pondering those loved ones’ records. Why? In my area, we’re under the first Tropical Storm warning of the year (and Hurricane Season doesn’t begin until June 1st) and a flood watch.

Records loss happens to all of us. That misplaced paper receipt to prove the warranty is still valid, the disappearing paper estimate that the roofer left or the W2 that you never received in the mail from a former company is frustrating. We’re fortunate that today there’s technology to help us with work arounds to obtain the missing document. Unfortunately, that’s not the case with records of past generations.

You’re probably tired of hearing the importance of preserving your acquired ancestral documents. Backing up my data is as fun as going to the dentist. Although I love my dentist and his staff, I don’t love the dental experience. I know that it’s important to keep my teeth and gums healthy so I continue to make and keep my appointments. So why do I have such a hard time with keeping my genealogical records updated and safe?

If you’re like me, scanning and saving those documents are just not as fun as hunting down the record. I have to admit that I have, on more than several occasions, had to refind a document that I needed and that definitely wasn’t fun. I thought, if I got into a routine like I do with brushing, flossing, and gargling, I’d be set with my record saves. I just realized that my genealogical process still needs refinement as I tried to locate a death certificate I could have swore I had placed in the Cloud and it just isn’t there.

I want my records to be readily available when I need them. Standardizing my File Name system helps, as does the lovely Search function on Dropbox and OneDrive. Yes, I use both. Paranoia may destroy ya but I believe putting my tree in one and my records in another protects the information in case one of the company’s system fails. (I used to use CDs, DVDs and thumb drives but I’ve abandoned those for Clouds since my latest technology doesn’t have those functions available).

Now my plan is all good until the weather takes a turn for the worse like today. Late last summer, I had no electricity for several days. Granted, accessing my genealogy was not my priority at that time, but when the power goes out and there isn’t impending danger, I still want to continue with my genealogical work. I’m thinking that I should be making a hard copy of online finds so I can work off the computer in times like those. I also need to recheck my existing hard copies and make sure that I’ve scanned and saved every document so if disaster strikes, when life returns to normal I can pick up where I left off. To insure I do this, I selected a line a month to check on. I’ve penciled a day on the calendar to make it official and hopefully, I’ll not cancel that appointment.

Top 10 Genealogy At Heart Posts from 2017


Happy New Year! Out with the old and in with the new but before we do that, let’s take a look back at the most read Genealogy At Heart posts from last year in descending order and a tie in 4th place:

10 VivaVolunteers! A Unique Opportunity for You

9 More on Accessing Records

8 Saturday Serendipity

7 Access to Preserved Records is Being Threatened!

6 My Grandfather’s C-File Has Finally Arrived!

5 Improving Your Genealogy Skills Semester II

4 Perseverance Amidst Adversity – The Ancestry of Three George Harbaughs

4 Genealogy Resolutions

2 Privacy and the Genealogist Part 2

1 Privacy and the Genealogist Part 1

If you’re on the east coast of the U.S., get a cup of cocoa, stay warm and enjoy re-reading these blogs.

Next week, I’ll rank articles that I did for other publications in 2017.

What Would You Do?


Happy Labor Day Weekend and the last long weekend of summer. It’s my 40th wedding anniversary, too. On a not so happy note, it’s our 32nd anniversary of losing everything in Hurricane Elena. We spent that wedding anniversary camping out at North East High in St. Petersburg, Florida with our oldest child and my mom. Like Hurricane Harvey, the mega rain maker, Elena decided to park herself offshore where she rotated away for several days. It was the rain that did the most damage.

That life experience made me relate to a recent Washington Post article that asked victims of Harvey what they took with them when they evacuated. One woman had time to grab her lipstick, another, just his medicine. For people who have been fortunate enough to not have to evacuate quickly from a life threatening situation those answers might seem ridiculous. I can assure you they aren’t.

I overheard someone in the checkout line yesterday decline to donate for hurricane relief because he said the people should have taken precautions. I interjected that the initial recommendation had been to stay put and not evacuate. He considered that and then replied that they should have put together items they needed when they realized the severity of the situation. Clearly, this man never lived through a disaster.

In our case, we had sold our first home the Sunday before the storm. With the pending contract, we spent the following days looking for a new one which we found late Friday afternoon. We placed a contract on it and went out to dinner to celebrate. We had heard weather reports of a disturbance in the Gulf of Mexico but like so many others in late summer, the fickleness of the tract didn’t cause us to worry. We had lived in our home for 7 years and experienced minor street flooding but nothing more serious than that. We went to bed early, skipping the late weather report.

Close to midnight, we were awakened by the sound of a fire truck siren and a loudspeaker announcing, “Prepare to evacuate immediately.” This was pre-cell phone days and reverse home phone emergency contacts. Following the fire truck was a police car. We were told he needed the names of our next of kin in case we chose not to leave. We made the instant decision to go.

So what do you take? We grabbed a suit case and threw underwear, socks and a few changes of clothes. We didn’t even think about a toothbrush. I put a few books and toys in a grocery bag for our daughter. She went into the car seat first and was followed by the cat in a pillowcase which I held on my lap and our lab, who was the only one who was happy about a late night car ride. We drove to my mom’s and discovered she was also being evacuated so she crammed into the car and we headed to the high school. Mom had thought to pack snacks.

Did I take any insurance papers, family heirlooms, or cash? Nope. I had my driver’s license in my wallet with a couple of bucks. The car wasn’t even filled with gas and it didn’t occur to us that electricity was needed to operate gasoline pumps. Duh! When confronted with an emergency, fight or flight kicks in. All the long term planning in the world gets down to what can you take in an instant. If you’ve never experienced that I hope you never do.

We returned to our destroyed home 5 days later. The flood waters had receded leaving tell tale water lines on the walls, particle board furniture that had collapsed, broken windows from wind damage with curtains blowing outside, and soggy smelly carpet. Nothing is spared. Think of your kitchen and bathroom cabinets sitting in 3 feet of water for a day. Now imagine it for even longer. My husband’s grandmother’s wicker doll carriage was destroyed, along with my paternal great grandmother’s china sugar bowl that had fallen to the floor when the hutch collapsed. It’s not pretty.

Thankfully, the camera was high up on a shelf in the closet so we could take pictures for FEMA of the damage. Our important paperwork was also spared as it had been kept in the top drawer of a file cabinet in our home office. Pure dumb luck! We weren’t so lucky with the home sale, though. The buyer of our home cancelled the sale. FEMA lost our paperwork which included the pictures and we had to resubmit (hooray for negatives). We had no electricity for 2 weeks so my daughter and I stayed at my mom’s while my husband guarded the home with the dog as looters were coming out as bad as the critters. Disasters sure bring out the worse in humanity.

I swore I’d be better prepared next time. Technology has definitely helped as I’ve scanned every photo and document in case it doesn’t make it through the next time. Those items are saved in a cloud, on CDs that I’ve given to several individuals and on one that is in my plastic tub where I store important paperwork. If there’s time, I can take the plastic tote and if not, hopefully, the contents will be safe until I return. I haven’t been able to find a fireproof device but that would be best option.

Now that I think about it, it’s almost miraculous that any object survives to be past down for more than a generation or two! That thought makes me treasure what I’ve received and marvel at the historical events that have item has survived. If only they could talk!

Preserving Your Genealogy

At the recent National Genealogical Society conference, there was a lot of chatter about preserving your genealogical records after you’re gone. I have to disagree with those that say if you don’t cite your work it will be tossed. I don’t know about you, but my family could care less where I find what I find. Unless the finder has been bitten by the genealogy bug, no one will understand the importance of citing and analyzing sources.

That said, I’m definitely in favor of following the standards. I think you should do the right thing but that is not going to save your years of effort from other destruction by surviving family members. I firmly believe there is only 3 ways to make sure that your research is preserved but you must plan ahead:

Donate your work locally and/or electronically so that future folks you don’t even know can benefit. These are the people who will not value your work if you didn’t follow the standards soundly.
Publish now and get your work in as many hands as possible. It’s quite simple to publish an eBook or you can print from whatever word processing program you use and have copies made at one of the big box office supply stores. Just type “how to publish an eBook” in amazon.com’s search engine and many free books are available to get you started. The holidays are around the corner and who knows?! A recipient might just get interested.
Getting a family member hooked is not as difficult as it sounds. The idea here is to match the living person’s passion to an ancestor. My kids could care less about their Great Grandma Elsie’s china. I understand that; we’ve used it for years as they’ve grown so it’s not so special. Will it be preserved? Most definitely, but it’s just not that exciting to them. On the other hand, they’re into medicine and research so learning about the life of that great uncle doctor in the 1800’s and a 5th great grandfather who was a chemist really gets them listening. The old tool box is a draw for our son while the old thread is a tie for my daughter to her 2 x’s great grandmother. An attachment develops when you can relate so find the connection and you’re work is safe!