Extract U.S. Census Data into Excel to Find Your Ancestors in Your Family History Fast

Learn how to use MS Excel to extract your ancestors in the U.S. Census to help find other family members living around your target ancestor. Even if you have never used Excel before, this is a step-by-step guide to how to import census data into Excel so you can filter by surname, filter multiple columns, insert rows and columns, freeze and split rows. This is a great technique to help you break down brick walls and analyze your census records quickly.

OTHER VIDEOS
🔴 Extract Ancestors from City Directories Using Ancestry or FamilySearch into Excel Spreadsheets
https://youtu.be/MXLDjp4W0YY

🔴 How to Use Excel for Genealogy
https://youtu.be/eONcu9lTbYY

🔴Organizing DNA Cousin Matches using Excel Spreadsheets
https://youtu.be/mlzAoiwSWIE

❤️ GET STARTED - JOIN the GENEALOGY TV ACADEMY
https://genealogytv.org/about-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. 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/Community.

📝 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. https://www.patreon.com/GenealogyTV

TIMING
0:00 Intro
1:30 Starting with a research question
3:00 Open up transcription of census
3:51 Extract data from transcripted section
4:26 Paste Special
7:33 Adjusting headers in columns
8:56 Locking/freezing headers on the worksheet
10:20 Insert rows for source citation info
12:05 Splitting the worksheet
13:00 Creating filters
15:50 Narrowing down likely father
18:33 Bastardy bonds
20:45 Reminders
21:31 Three ways to get the handouts
❤️BECOME A GENEALOGY TV CHANNEL MEMBER and help support Genealogy TV - see perks!
https://www.youtube.com/genealogytv/join

👉 Subscribe to Genealogy TV
https://www.youtube.com/channel/UCcvpi8XvOScBogIxmarmADw/Subscribe

🛍️ 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
https://www.facebook.com/Genealogytv/

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

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

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

❤️ TIP JAR - If you like the videos, please consider becoming a Patreon member.
https://www.patreon.com/GenealogyTV

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

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

▶️ SUBSCRIBE to NC ANCESTRY (North Carolina Ancestry) at
https://www.youtube.com/ncancestry

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. Learn genealogy for free and how to research on Ancestry.com, FamilySearch.org, MyHeritage.com, FindMyPast.com, FamilyTreeDNA, AncestryDNA, 23andMe, WikiTree, Geni, National Genealogical Society, National Archives, National and State Archives, genealogical & historical societies, genealogybank.com, Chronicling America, Newspapers.com, Newspaper Archives.com, Fold3, Archive.org, Internet Archive, Wayback Machine, Digital Public Libraries, Google, Google Books, Google News, Facebook genealogy groups, and the very best genealogy websites and resources.
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/by/3.0/

Видео Extract U.S. Census Data into Excel to Find Your Ancestors in Your Family History Fast канала Genealogy TV