Extract Ancestors from City Directories Using Ancestry or FamilySearch into Excel Spreadsheets

In this video learn how to extract ancestors from city directories using Ancestry or FamilySearch into Excel. Here we demonstrate this family history strategy using Ancestry, but can be done from any online genealogy website that has city directories, such as MyHeritage too. This can also be done using Google Sheets instead of Excel with a similar procedure.

There is a handout for Information Access level Channel Members and patrons at the Happy Dance level or higher. The handout has step by step instructions for extracting ancestors using Ancestry and Excel spreadsheets. See below for information about how to get the handouts.

OTHER VIDEOS
🔴 Find More Ancestors by Extracting Census Data into Google Sheets
   • Find More Ancestors by Extracting Cen...  

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

🔴 Ancestry and FamilySearch Combined for Genealogy Research
   • Ancestry and FamilySearch Combined fo...  

🔴 Obituaries: Finding Facts, Clues, Leads, Sources, and Research Questions in an Obituary
   • Obituaries: Finding Facts, Clues, Lea...  

TIMING
0:00 Intro
1:24 Previous Episode Overview
2:12 Using City Directories for Genealogy
3:19 Tip: Use the Last Name First
3:56 Possible Alternate Spellings
4:50 What’s our goal?
5:24 Creating an Excel Sheet
5:48 Viewing the Transcript
6:12 Difference between census and directories
7:02 Pasting to Excel
7:35 Using Paste Special
8:25 How often are City Directories made?
9:46 Adding the next year
11:09 What if the directories have different publishers?
12:00 Resizing the Columns
13:14 How to filter in Excel
15:31 Viewing your results
16:07 Searching for variations
17:00 Applications
17:33 Searching by street
18:25 Searching by gender
18:45 Can I do this on FamilySearch?
19:03 Handout Info
19:58 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, 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, Wiki Tree, Geni, National Genealogical Society, National Archives, National and State Archives, genealogical and historical societies genealogybank.com.

#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...