Find More Ancestors by Extracting Census Data into Google Sheets: Filter by Name

Learn how to FIND MORE ANCESTORS! In this episode Connie shows her techniques to filter U.S. Census records by surname using Google Sheets and Ancestry. This is one of her best Brick Wall Buster strategies. This also works on FamilySearch, MyHeritage, and online genealogy services. This works on just about any record that has been indexed.

OTHER VIDEOS
🔴 #1 Way to Break Down Brick Walls: Updated (2020)
   • #1 Way to Break Down Brick Walls: Upd...  

🔴 #1 Way to Break Down Brick Walls - Trick to Making Cluster Research Faster
   • #1 Way to Break Down Brick Walls - Tr...  

🔴Organizing DNA Cousin Matches using Excel Spreadsheets
   • Organizing DNA Cousin Matches using E...  

🔴 AncestryDNA Grouping Cousin Matches: Clarified
   • AncestryDNA Grouping Cousin Matches: ...  

TIMING
0:00 Intro
1:31 Overview
2:49 Why use Google Sheets?
3:10 Filtering the FAN Club in Google Sheets
4:00 Why use the FAN club?
5:30 How to read census records
7:11 Open the Transcript on Ancestry
7:44 How many pages to copy?
9:32 How to copy the transcript
10:03 Pasting into Google Sheets
10:53 Insert a Column in Google Sheets
12:03 Freeze a Row in Google Sheets
12:45 Capturing more pages
15:46 Is it worth adding all pages?
16:59 Freeze and Bold headers
17:22 Adjusting Column Width
18:29 Adjusting multiple columns
19:17 Word Wrap
20:16 Adding Word Wrap to All Cels
20:57 Filtering by Surname
23:20 What to do when you need more data
26:50 Working Backwards
27:32 Cite your Source
28:02 Filtering the 1870 Census
30:10 Renaming a tab & Adding new sheets
31:02 The 1860 Census
32:10 Filtering the 1860 Census
35:50 Finding Different Spellings
36:55 Combine Results
38:05 Wrap up
38:35 Handout Info
39:26 Outro


❤️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 WEBSITE
https://genealogytv.org/

✅ GTV on FACEBOOK
  / genealogytv  

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

❤️ NEED HELP? Get coaching.
https://genealogytv.org/virtual-priva...

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

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

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

📝📝📝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  

❤️ TIP JAR - If you like what you see and wish to help support Genealogy TV or NC Ancestry, please consider becoming a Patreon member. Thank you!
  / genealogytv  

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

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

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

▶️ SUBSCRIBE to NC ANCESTRY (North Carolina Ancestry) at
   / 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. I teach the 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, 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, Wiki Tree, Geni, National Genealogical Society, National Archives, National and State Archives, genealogical and historical societies.

Best YouTubers for genealogy are Genealogy TV (of course), The History Guy, Ancestral Findings, Family History Fanatics, Geneavlogger, Legacy Tree Genealogy, Ancestry, FamilySearch, Useful Charts, Dear Myrtle, 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...