Genealogy TV

How to Extract 1940 and 1950 U.S. Censuses into Excel or Google Sheets to Filter Surnames to Your Ancestors Using Ancestry.com

Genealogy TV

Today we’re going to talk about how to extract US Census information from the 1940 and the 1950 U.S. census into Excel spreadsheets so that you can filter them quickly by surname to help find more family members. 

In previous episodes, I had been using this little trick I created where you can copy and paste U.S. Census transcriptions out of Ancestry or FamilySearch and put it into Excel so you can use the filters in order to find other family members. Some of the comments came back saying that they could not do this trick on the 1940 and the 1950 census. Yes you can. I’m going to show you how to do that right now.

Related Posts

Can You Spot the Same Signature Over Time? In this episode of Genealogy TV, we explore how comparing signatures across historical documents—like World War I and II draft cards and...

Upcoming Livestream: Ancestry Power Plan – Search Strategies That Work! Premiere Date: April 17, 2025Time: 3:00 PM Eastern (US)Where: Right here on Genealogy TVFree Handout: Available to everyone during the...

Follow Us