GTV Extract Census - Ancestry and Excel

Extracting Census into Spreadsheets to Find Your Ancestors Fast: How to Use Ancestry & MS Excel

Genealogy TV
Click image for link

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.

Related Posts

This GTV 2 channel lesson is now available on the Academy dashboard. Be sure you’re logged into your account and use this link to watch now, ad-free. https://genealogytv.org/courses/gtv2-youtube-videos-2026/lessons/genealogy-organization-done-right-find-anything-in-seconds/

<div class="sharedaddy...

AncestryDNA has updated how it predicts certain close-family relationships. Instead of relying primarily on the total number of centimorgans you share with one DNA match, Ancestry can now examine patterns...

Follow Us