Today we're going to talk about how to extract US Census information from the 1940 and the 1950 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.

There is a handout for the Information Access level channel members (YouTube) and the Happy Dance level Patrons on at Patreon.com/GenealogyTV.

OTHER VIDEOS
🔴 1890 US Census Substitutes + 300th Episode Contest Giveaway!
[ Ссылка ]

🔴 Extract U.S. Census Data into Excel to Find Your Ancestors in Your Family History Fast
[ Ссылка ]

🔴 U.S. Census Records, 1790-1840, Part 1 of 3 (How to Research Your Family Tree)
[ Ссылка ]

🔴 U.S. Census Records 1850-1940, Part 2 of 3: (How to Research Your Family Tree)
[ Ссылка ]

🔴 U. S. Census Records Genealogy Research Strategy. Prior to 1850, Part 3 of 3
[ Ссылка ]

❤️ GET STARTED - JOIN the GENEALOGY TV ACADEMY
[ Ссылка ]

📝📝📝THREE DIFFERENT WAYS to find the HANDOUTS!

📝 1) Become a CHANNEL MEMBER at the INFO ACCESS level $9.99 per month. This gets you all the handouts. [ Ссылка ].
As a Channel Member, find the handouts by scrolling through the blog posts on the Community tab at [ Ссылка ].

📝 2) All handouts can be PURCHASED INDIVIDUALLY ($5 and up) at [ Ссылка ]. Here you will get a redirect and an email to download the handouts.

📝 3) Become a monthly PATRON at the HAPPY DANCE level ($15/Month) or more. You will get early release of the videos and the handouts are emailed to you, when they become available. [ Ссылка ]

❤️BECOME A GENEALOGY TV CHANNEL MEMBER and help support Genealogy TV - see perks!
[ Ссылка ]

👉 Subscribe to Genealogy TV
[ Ссылка ]

🛍️ Genealogy TV’s AMAZON STORE full of Connie’s favorites. [ Ссылка ] (Amazon Affiliate)

✅ Genealogy TV WEBSITE
[ Ссылка ]

✅ GTV on FACEBOOK
[ Ссылка ]

✅ SIGN UP For GTV’s NEWSLETTER
[ Ссылка ]

🌳 Subscribe to Ancestry.com (affiliate) [ Ссылка ]

📰 Subscribe to Newspapers.com (affiliate)
[ Ссылка ]

❤️ TIP JAR - If you like the videos, please consider becoming a Patreon member.
[ Ссылка ]

🌳 Subscription to ANCESTRY.com (affiliate) [ Ссылка ]

📰 Subscription to NEWSPAPERS.com (affiliate)
[ Ссылка ]

▶️ SUBSCRIBE to NC ANCESTRY (North Carolina Ancestry) at
[ Ссылка ]

TIMING
0:00 Intro
0:53 Trouble extracting from these censuses
2:28 Demonstration with 1940 Census into Excel
5:36 Why do this?
8:33 Building one from scratch
10:22 Headers for spreadsheet
12:38 Paste special as text for extracted data
13:03 Formatting and filters for headers
15:33 Make sure to note information at top
16:10 Adding a hyperlink
17:40 Instructions review
20:28 Keep in mind people began to spread out

I am a fanatic for genealogy, family history and DNA to research my American ancestors. I create the best free genealogy videos and webinars on YouTube. Learn genealogy research skills to help you with your family tree and family origins. I am a professional genealogist; I teach research skills and records research. The best videos on “Genealogy TV” (YouTube) are about learning research notes, logs, staying organized, genetic genealogy, finding missing ancestors, and where to find family history records.
Best YouTubers for genealogy are Genealogy TV, The History Guy, Aimee Cross Genealogy Hints, Family History Fanatics, Geneavlogger, Legacy Tree Genealogy, , Ancestry, FamilySearch, Useful Charts, Dear Myrtle, Genealogy with Amy Johnson Crow, and 23andMe.
#Genealogy #GenealogyTV #FamilyHistory
Music Credits for Song on Word Tree Open
Circus Waltz Kevin MacLeod (incompetech.com)
Licensed under Creative Commons: By Attribution 3.0 License
[ Ссылка ]

свернуть