Ancestry's Index Panel: I'm Trekking Through the 1850 Census Faster Than Ever

Census records are a goldmine of information. As I've mentioned before, I like to mine all the details. This takes time. For a big family, it can be quite a bit of time. Often, I find myself zipping past census hints, in favor of something I can work on more quickly. 

Recently, I decided to set out on the task of getting through some of those census records. They're important, and I need to stop glossing over them. I'm starting with the 1850 census. Using the Ancestry Hints By Specific Record Collection I previously wrote about, I'm able to see all the hints I'll be working with - only those hints (so I'm not tempted to bypass them). My only current goal is to make it through all the 1850 census hints I have. Then, I'll move on to 1860. Wash, rinse, repeat. 

I'm not worrying about how many other hints this is adding on my main hints page. I'm simply plugging away at a concrete goal I've set for myself. While I'm making progress, I haven't been spending as much time checking out new features, updates, tools or websites. However, I was reminded recently about a handy feature on Ancestry I either never really paid much attention to, or forgot about - and it's a big time saver for my census journey. Let me explain the backstory...

I use a spreadsheet to transfer all the data from a given family on a census record. I like a standard way of formatting (using the concatenate function to string data together). Then I copy this data into a document before I begin updating each person in Ancestry. It leaves me with a list of all the facts I need to add, and a full summary to paste into my transcription field in the citation for each person. This is the simplified version. I have a few other steps in the process to get it to work just so, but you get the idea. I'm more than a little OCD about how I work with a census record. Certainly not everyone would want to go through my whole process, but I'm betting some of you have a process you like to follow.

In order for my spreadsheet to do its magic, I need to list each family member in their own column, not rows as a census is presented. I can't tell you how much time I've spent diligently transferring the contents of each row into the necessary columns (flipping back and forth endlessly between tabs as I entered the data in columns). And here's where I can't believe I've dedicated (but not wasted) so much time I didn't need to! 

If you open the image of the census record, at the bottom of the screen is a little toolbar. We've probably all used the filmstrip view at some point. And I'd imagine everyone has used the arrows on the sides of the image to move forward and backward through pages....but how often do you use the index panel? Here's where to find it:

You might recall, I work on a small screen, so this next screenshot is not all the data. But it gives you the general idea of the format you'll see. Each line of the census is already transcribed!

The hard work is already done! Because I already have all the headings for each field in my spreadsheet, I just need to highlight, copy and paste all the family members into my spreadsheet. I do spot check fields like occupation, attended school, etc, just to be sure all the data is there - but most of the time it's very complete. I occasionally find a name transcribed incorrectly like "Susah" instead of "Sarah", but all in all, this saves me a ton of transcription time.

Now, if you've followed along this far, you might say..."Uh, Doris, you said you put each person in a column. You just copied rows." And you'd be right! I plop the copied data in my spreadsheet below where I want it. Then I right-click and copy it from within my spreadsheet, navigate to the first column for the data, and I paste-special (Excel) transposing rows and columns. This gives me exactly the layout I want to make my spreadsheet provide the specific formatting I use - all without having to do any (or very little) transcription myself. I'm going to hazard a guess and say this is saving me at least 50% of the time I spend working with census records. 

I won't bore you with any more of the details on my personal process. But if you'd like to see a little more on how to grab all this information, I found this video very helpful. (I've added it to my Genealogy Toolbox under "Articles, Tips/Tricks, Guides". 

While I still have to tweak a little for my own process, this is a huge timesaver! And as always, verifying is important. This isn't a substitute for making sure the transcription is correct (but it sure makes it a lot faster and easier to do). This feature is available on other images as well. And while I can't say for certain if every record set is as detailed as census records, you can be sure I'm going to start checking....right after I've finished my 1850 census project (and hopefully a few more years as well). Let me know if you already use this feature, or if you think it's going to help you in your own research. 

Image by Gerd Altmann from Pixabay