Extracting 1940 & 1950 U.S. Census into Excel Using Ancestry.com

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!
   • 1890 US Census Substitutes  &list=UULFcvpi8XvOScBogIxmarmADw

🔴 Extract U.S. Census Data into Excel to Find Your Ancestors in Your Family History Fast
   • Extract U.S. Census Data into Excel to Fin...  &list=UULFcvpi8XvOScBogIxmarmADw

🔴 U.S. Census Records, 1790-1840, Part 1 of 3 (How to Research Your Family Tree)
   • U.S. Census Records, 1790-1840, Part 1 of ...  &list=UULFcvpi8XvOScBogIxmarmADw

🔴 U.S. Census Records 1850-1940, Part 2 of 3: (How to Research Your Family Tree)
   • U.S. Census Records 1850-1940, Part 2 of 3...  &list=UULFcvpi8XvOScBogIxmarmADw

🔴 U. S. Census Records Genealogy Research Strategy. Prior to 1850, Part 3 of 3
   • U. S. Census Records Genealogy Research St...  &list=UULFcvpi8XvOScBogIxmarmADw

❤️ GET STARTED - JOIN the GENEALOGY TV ACADEMY
https://genealogytv.org/about-genealo...

📝📝📝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. https://www.youtube.com/genealogytv/join.
As a Channel Member, find the handouts by scrolling through the blog posts on the Community tab at https://www.youtube.com/GenealogyTV/C....

📝 2) All handouts can be PURCHASED INDIVIDUALLY ($5 and up) at https://genealogytv.org/handouts/. 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.   / genealogytv  

❤️BECOME A GENEALOGY TV CHANNEL MEMBER and help support Genealogy TV - see perks!
https://www.youtube.com/genealogytv/join

👉 Subscribe to Genealogy TV
   / @genealogytv  

🛍️ Genealogy TV’s AMAZON STORE full of Connie’s favorites. https://www.amazon.com/shop/genealogytv (Amazon Affiliate)

✅ Genealogy TV WEBSITE
https://genealogytv.org/

✅ GTV on FACEBOOK
  / genealogytv  

✅ SIGN UP For GTV’s NEWSLETTER
https://mailchi.mp/a0862c6473aa/genea...

🌳 Subscribe to Ancestry.com (affiliate) https://prf.hn/click/camref:1101l4aFW...

📰 Subscribe to Newspapers.com (affiliate)
https://www.anrdoezrs.net/click-91101...

❤️ TIP JAR - If you like the videos, please consider becoming a Patreon member.
  / genealogytv  

🌳 Subscription to ANCESTRY.com (affiliate) https://prf.hn/click/camref:1101l4aFW...

📰 Subscription to NEWSPAPERS.com (affiliate)
https://www.anrdoezrs.net/click-91101...

▶️ SUBSCRIBE to NC ANCESTRY (North Carolina Ancestry) at
   / ncancestry  

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
http://creativecommons.org/licenses/b...