Thank you for TWO lessons in one: How to find someone in a census, and how to use Excel for record extractions! I am grateful that you are willing to share your knowledge and experience. God bless you.

@GenealogyTV

10 ай бұрын

Thank you.

@familyhistoryenthusiast

4 ай бұрын

I needed a refresher in Excel. I haven't hardly used it since the 90s. I forgot all the cool little tricks you can do with it.

📍TIP: in standard search within Ancestry, you were using full names “Henry” or short names “Gus”. Try using the asterisk * as open parameter extension. G* or Gu* or Hen*. This asterisk can also work before, as well as both before and after (no spaces). * en * for all named that contain EN (Henry, Henly, Henley, etc.); or * us * returns Gus, Gustav, August, Gustavus, etc. - Asterisk is a very old school, hard code used almost everywhere. Asterisk is programming language built into nearly all systems. I had to put spaces in the above examples because asterisk is so heavily part of programming that it wouldn’t show in this message because it means something different in programming than the visual character itself.

@GenealogyTV

10 ай бұрын

Good point for the comment readers... I have used that trick many times. In this case, it was more about demonstrating the extraction and filtering using Excel. Thanks for sharing Kirk.

@sandyr1789

10 ай бұрын

Excellent point! When I have a surname variation I use this technique but you have to be sure to use the spaces: "surname / surname"

@chieffamilygenealogyoffice621

10 ай бұрын

I found in the NC digital archives a “William Hendley bible”. Is he in your family?

@johnlaws5231

10 ай бұрын

Thanks for 'How to find someone in a census, and how to use Excel for record extractions! I am researching 'LAWS' in the UK. My Gt-Gt-Gt Grandfather Henry Laws 1800-1880 a Master Mariner 7th child of 15 of John Laws Rope-maker of London gu-estimately 1741-1818 all a bit vague prior to Henry's marriage in 1825. been at this game 50 years collected a huge database of Laws worldwide to no avail

@soozieevans7222

9 ай бұрын

This will be very helpful for me. I still have my big brick wall that I have to work on breaking

You are a genealogy tek genius presenter who draws us into the details effortlessly bravo!!!

@GenealogyTV

10 ай бұрын

Thanks

Great lesson! I have paged through many, many censuses but I never thought to extract the data that way. I disagree about making the correction and I'd love to hear what Ancestry has to say. I would have changed it and chosen as a reason INCORRECT IN IMAGE. You aren't actually changing the original transcription; you are adding an alternative search term. This means that other people who are searching for Gus will be able to find him even though the surname and given name were switched. Notice that the boy above him was also switched. I would have corrected his name as well.

@SparkeyCox

10 ай бұрын

I just made my own comment about this and agree with you. I amm interested in the answer as well. I understand that corrections are to make finding the person easier. --- thanks

@On3man

10 ай бұрын

You are absolutely correct. She is dead wrong (pardon the pun) in stating that changing the index changes the original record as she does at 16:03. A “correction” to any Ancestry index does not change the original record, it only changes the index. Neither the Ancestry digital image of the census record, nor its index is the original record. It is a digital copy and although it can be thought of as a primary source, it is only so because it includes the image. The original record is the original piece of paper from which the image was taken. Obviously, it will not be changed, since nobody is going to rush down to the National Archives with pen in hand, assuming the paper copies even exist any more. The index is simply a finding aid and has no effect whatsoever on the original record or on Ancestry’s digital copy of it. The idea that changing the finding aid to a set of records changes the original record is pure nonsense since the index is not the record source, the record is. When a “correction” is made it adds a new entry (record) to the index table which supplements the original entry. It does not replace it. In the example she uses, the original incorrect index record (Gustavus, Henly) would have remained and in addition there would now be an index record with the name entered correctly (Henly, Gustavus). In other words, there would now be two index records pointing to the same entry in the image of the census record. As you have rightly pointed out there is the “incorrect in image” choice in the "Why is this being added?” box along with a number of other choices and an option to provide a freehand explanation (sourced of course) for why you are making the change. In this case she could have added the information pointing to the other family entries in this collection and perhaps another source showing the family together. That way, when the next researcher comes along, they see find the individual, plus the information proving the relationship. Any “corrections” made to indexes (which, as any experienced genealogist will tell you, can be notoriously full of errors) makes it easier for the next person looking for that record. My own opinion is that not adding a correction to an index, when the ability to do so is there, is either a symptom of selfishness or ignorance of the difference between an index and its corresponding record, or how the addition really affects the index. (In this case, I believe, judging from her dialog, that it is the latter). However, I find it really disappointing that an obviously experienced KZreadr genealogist with almost 100K subscribers would put our such a great tutorial and then ruins it with complete nonsense about indexes and records. I can only hope that she might re-record this video with the error corrected, and the index corrected. Otherwise I fear that there are probably more than few less experienced genealogists out there who will get the wrong idea that the index is somehow the record and should not be changed, which, of course, will make things harder for the rest of us who know better.

@martast.john-anders6448

10 ай бұрын

@@On3man That was really harsh. I don't appreciate your using my comment as a springboard to voice your criticism.

@On3man

10 ай бұрын

@@martast.john-anders6448 sorry you feel that way.

This was Great Connie! Thank you. For those of us that are visual learners, the detailed step by step was perfect.

@GenealogyTV

10 ай бұрын

Awesome. Thanks for supporting the channel.

@loiscarson5526

10 ай бұрын

Maybe Gus was living with kin

While you've addressed this topic in other videos I found this one most helpful. Taking your search beyond the name opened some ideas for me on finding one of my relatives who doesn't show up on the expected census. Thanks Connie!

@GenealogyTV

10 ай бұрын

Glad it was helpful!

@GenealogyTV

10 ай бұрын

... and thanks for supporting the channel!

Great tips on census researching! I just went to my missing people (in 1870 also) and after 4 hours, the mystery for one is still a mystery... But, I figured out two people were moving out of state at the time!

@GenealogyTV

10 ай бұрын

Interesting. I'm wondering if your mystery person followed them (those who moved out of state).

Great vid, never thought of exporting to Excel (or manually exporting... ie copying). One thing, I also try searching with names reversed, Mistakes happen. I'm not sure I agree though about not fixing it. You're not destroying the original info, you are adding aliases, and there is actually a choice for incorrect in image. I do change these types of mistakes because there may be other researchers with less experience out there looking for the same record. What I do not add though, is nick names, or commonly used names, gritting my teeth here, like Nonno. One of my biggest pet peeves when I'm helping people is when they are looking for "Nonno something". Yes I'm very excited his your Nonno, but that helps exactly zero. Also, I only update the info when I'm certain of birth names. I might have even corrected the spelling of the last name as incorrect as well, or error in transcription if that was the case. I don't see a reason to keep bad meta data. Maybe you disagree? Would be interested in your reasoning. Regardless, great trick, too bad Ancestry doesn't make an extraction like this easier to do... one button. Thanks again!

@GenealogyTV

10 ай бұрын

Well Ancestry pays for those records and platform, so I kind of understand why they don't allow a lot of extraction. I'm kind of on the fence about whether that name should be edited in the index, but I hear you.

@garylhaas2005

10 ай бұрын

If you can see it on the screen, you can extract it. Excel VBA and Power Query AND Microsoft Power Automate Desktop can do magic.

@kareno8634

9 ай бұрын

@@GenealogyTV Hi, Nice Work! To me it takes quite a bit of patience, ideas, and organization, to point either Excitement or Anxiety takes over. Companies may have stocked their Database with our info, (thus charge) but no reason why We couldn't search from Government site, [either]. A matter of Public Record: re: "Pay" - I find it 'Odd' that Anyone should Have to Pay for Records OF the people. Our government has these records PAID for BY the people. _just a 'thought',_ - most likely correct. - Our governments, (and the BAR) have Usurped our Rights, Constitutions, and Laws, in effort to ConTrolled the people.^ Didn't mean to get all political 'karen'. lol The more *We Read and Learn, We Stand and Take back.* ^ We must Learn we have Unalienable Rights, and holding All political Power, and Use them. *Nice to see Gus was with his Dad,* any chance William went to his? (name switch too?).2:37 *Thanks* for your info, will pass it on. Cheers!

Connie - Congratulations on breaking through a brick wall! Thank you for your thorough explanation and the way to be utilizing Excel to extract the information. Your explanation to use the newest version of Microsoft Excel was very important!

Love this! What a great find. Thanks for the refresher on extracting census data into Excel

@GenealogyTV

10 ай бұрын

My pleasure!

It would be helpful to the next person looking for him to have it corrected on the census. Ancestry lists all the alternate names that have been given. I amend names wrongly indexed like this just to make life easier for the next person. Those wrongly indexed people create a terrible quagmire. I would have used "apprentice" as key word and searched from that. There would likely be very few apprentices.

@RandHall

10 ай бұрын

You beat me to it! I love the screen scraping and all, but once you know the magic word...just toss it in the Keyword field. THAT is an under appreciated trick. I love trawling censuses, directories, and phonebooks by street address in the keyword field.

Great reminder! You've inspired me to try this with some church records that I am compiling. Thanks for the clear and straightforward instructions. Much appreciated. 👍

@GenealogyTV

10 ай бұрын

Thank you and thank you for supporting the channel.

That was really cool. Our elderly ancestor and his wife had moved to Texas and we lost track of one of his adult daughters. We found out through someone elses research that she was 4 pages ahead living with her husband. Her first name is unique so if I had done this I could have found her on my own. Thanks.

That is some crazy sh**! A great example of how intensive, time-consuming, and in-depth the process can become when trying to dig through old records. Certainly also shows how dedication and persistence can be your best friends (and also why some people get a few extra wrinkles when trying to find "lost" records)!

Can't wait to try this for one of my problem ancestors. Thanks!

@GenealogyTV

10 ай бұрын

Good luck. Thanks for supporting the channel.

This is why my dream career is time-traveling genealogist. I WANT to see the stories behind the data.

@GenealogyTV

10 ай бұрын

Me too!

@jilldowding-walker8066

10 ай бұрын

😂❤

As an IT professional of 40 years and a genealogist for 31, that was EXCELLENT work! Kudos!

@GenealogyTV

10 ай бұрын

Wow, thank you!

Congratulations, Connie! I can imagine your joy in the moment.

Great use of the Excel trick. I have used the extraction of census info into Excel several times since you first did a video on that. It even works for foreign censuses- like Norway censuses!

@GenealogyTV

10 ай бұрын

Oh good to know. Thanks for supporting the channel Richard.

Absolutely awesome! I could not find my own grandfather’s family for years! I finally gave up and unsubscribed from Ancestry because I was frustrated. Your work here has recharged me and I’m seriously considering going back at it. Evidently there are all kinds of tricks to use for these things! Also…another relative finally found my grampa. Just gave up too soon. Thank you!

@GenealogyTV

10 ай бұрын

Thanks for the compliments

I have been doing genealogy here in the UK for over a decade now, and also thought I was competent in Excel, but have learnt several new things in your short video. Thanks! I'll watch them all now!

@GenealogyTV

9 ай бұрын

We all learn from each other.

WOW, what a wonderful method you have given us to use in our genealogy research!! Thank you so much for being willing to share your genealogy research knowledge.

I found him quickly by searching for occupation apprentice (exact), born 1862 in NC, lived in Randolph Co, NC (exact). He popped right up as Henly Gustavus.

Loved this 'doing genealogy' trick /'hack' :) Also really appreciated seeing Excel used as the excellent tool it can be - it is the one programme I have always avoided using or learning to use. I guess I have a love hate relationship with it - I do wish I understood how to use it better! I am defo going to try this method even if it is just to consolidate those Excel user tips (I didn't know how to freeze panes - this will help me at work too!).

Wow! Your navigation through the data extraction process is stellar! And you obviously have done this for some time. Thank you for sharing part of your journey and showing us how to drop history into Excel. This ancestress and her children definitely have a story waiting to be told!

@GenealogyTV

10 ай бұрын

LOL.. Yes they do.

Awesome Connie. What a handy helpful tip and procedure. Thanks.

@GenealogyTV

10 ай бұрын

Glad it was helpful!

Simply Brilliant! I don’t know why I didn’t think of this myself. I have done searches page by page before but never thought to grab the transcribed data and put it into Excel to manipulate. Word of caution sometimes I’ve found people have been missed in the transcription. But wow this is a time saver. Thank you!

GAME CHANGER! Connie, thanks so much for this. I do have a version of Excel that allows me to do this. I'm so excited to try it out - I've got a couple of missing kids too!

@GenealogyTV

10 ай бұрын

You're so welcome!

That was some serious digging!! I didn't realize we could extract census info, thanks for the great tip and thinking outside the box!

DING DONG! How exciting. Your work paid off!

I think that the census recorder for that district was consistently putting the hired hands/apprentices on the role First Name, Last Name. The average person transcribing the data reasonably going to assume that all of the names are Surname / Given name. Excellent job teasing that one out of the grass and weeds.

What a wonderful video-tutorial. I did not know you could do all of that with Census and excel. I was so happy and excited for you when you found him!

Thank you very much for showing how you searched for that. I’ve used your trick to download census records, but never thought to sort it by the age, gender, etc - or thought about maybe a transcription putting first name last :). Thanks for all your help.

This is life changing! Thank you so much. I’ll use this now regularly. My brain works like yours and I had hit that same searching barrier so many times after hours of image viewing! It’s wonderful to have this new tool to break through. Many thanks!

@GenealogyTV

10 ай бұрын

Glad you liked it.

Great information Connie!! Thank you for sharing.

@GenealogyTV

10 ай бұрын

Glad you enjoyed it.

Great information. Just a shout out to you. I am a FamilySearch consultant and I told a new patron to our centre all about you and your KZread channel. She had now started following you. I love your videos.

@GenealogyTV

10 ай бұрын

Awesome! Thank you!

I loved this video. Using MS Excel in this manner has so many applications in family history research, especially with establishing extended family units found in DNA results. My mind is bursting with ideas. Thank you for sharing.

@GenealogyTV

10 ай бұрын

Glad it was helpful!

Great video. I'm glad you showed us the process of how you went through it. Following your other videos, I put some census records in Excel and it is miraculous how it can do these power searches. I have a bit of a brick wall with my grandmother and not finding her in a 1900 census. I tried this with her and couldn't find her, so the search goes on. However, it is a great technique.

Wow! My head is still spinning. Great work.

Connie, another solid video. This method did not find my 1850 missing ancestor... BUT did allow me to find Transcription Errors that I have corrected. I do follow the Transcription Protocol (only trascribing as seen not assumed). Thanks again for this video.

What a treasure trove of helpful information. Thanks SO much!!

Score! Again!! You are amazing! Thanks for sharing, Connie.🥰

@GenealogyTV

10 ай бұрын

😊 thank you

Wow. Very helpful and appreciated!! Thank you!!

Thank you so much, Connie, I have learned a lot in just this one lesson. Thanks also for all the time and effort you put into bring us these videos, much appreciated.

@GenealogyTV

10 ай бұрын

You are so welcome! Thanks for supporting the channel.

I saw you do this before with the 10 pages before the census and 10 pages after, but this is totally awesome! Thank you for sharing! Can't wait too try this!

@GenealogyTV

10 ай бұрын

Awesome! Thank you!

This is GREAT information!! I've been trying to locate my great grandmother using 1910 - 1950 census and haven't had any luck. Hopefully now, I can find her!!

I ❤ your step-by-step to Excel!!! 💥🏆💥. Esp. that you show the steps more than once. Awesome tips! THANK YOU!

@GenealogyTV

10 ай бұрын

Glad it was helpful!

This is great! Thank you for sharing!

@GenealogyTV

10 ай бұрын

My pleasure.

Awesome!! You are so helpful!!

@GenealogyTV

10 ай бұрын

I try.

Thank you for all of your helpful hints with Genealogy Research.

@GenealogyTV

8 ай бұрын

Glad you like them!

That was an awesome tip!! Thank you for always teaching us.

@GenealogyTV

9 ай бұрын

You are so welcome!

Really good use and demonstration of how to use the filter function. I practically made my career on knowing how to use filters when nobody in the organizations where I was knew about it. Even when I showed them how to do it, they came to me to find spurious information. So, yes! It is a secret out there in plain sight.

Wow! Just came across your channel and just subscribed. You are so compelling. In a few short minutes you've revived my interest in my genealogy search. Looking forward to a fun winter project with you. ❤

@GenealogyTV

9 ай бұрын

Awesome! Thank you!

Thank you! I have copied and pastred special into Excel before BUT I didn't know how to do more detailed filters that you explained. GOLD!

@GenealogyTV

10 ай бұрын

Glad it was helpful!

Woah, this was amazing info! Thanks a ton! My Great Grandmother is a Henley and it has been nearly impossible to find information on her. Everything that was ever told to us growing up was in secret so to speak lol You have gained a new follower in me! I look forward to more research tips!

@GenealogyTV

10 ай бұрын

Glad you enjoyed it!

Wow, that was cool! What great info! And I so appreciate your demo on copying and pasting into Excel!

@GenealogyTV

7 ай бұрын

Glad it was helpful!

You are amazingly helpful. Thank you for both verbal and visual direction. Onward you go!!

@GenealogyTV

9 ай бұрын

Glad it was helpful! Thanks for the compliments.

Best video on research that I've seen in a long time, thank you!

@GenealogyTV

10 ай бұрын

Wow, thanks!

Wow! I just HAD to subscribe! I've always had an interest in this, but you're an amazing teacher too! A great lesson in Excel AND how to in Geneology tracking. Thank you! 😊

@GenealogyTV

10 ай бұрын

Wow, thank you!

I don't know how often I will use this tip, but this was one of the best tips I've seen. I went to Excel and practiced and I can definitely see how useful this would be. Thanks, Connie.

@GenealogyTV

10 ай бұрын

Glad it was helpful!

Thank you for sharing! You are amazing at finding information.

@GenealogyTV

10 ай бұрын

You are so welcome!

I have a pair of brothers, missing from 1916 Western Canada Census and am using your method right now to try to find them!

@GenealogyTV

10 ай бұрын

Good luck!

Thank you! Never knew we could download that data. This will help SO much 😊

@GenealogyTV

10 ай бұрын

Happy to help!

That was awesome, I'll be using this!

WOW! Wonderful tip and great detective work on your part. What fascinating family and the untold stories.

@GenealogyTV

10 ай бұрын

Thank you!

OMG! Can't wait to try this. I too have relatives who were farmed out around 1870, in Illinois. Trying to discover why. This video is a godsend. TYVM TYTYTYTY. ❤️

@GenealogyTV

10 ай бұрын

OMG... I can't wait for you to try it too! LOL. You're welcome several times over.

Awesome!! Thank you, I would never have known this was possible.

@GenealogyTV

9 ай бұрын

Glad I could help!

Great use of the Excel spreadsheet, well done!

@GenealogyTV

10 ай бұрын

Glad it was helpful!

Congratulations on your find! And thanks for the excel tip!

@GenealogyTV

10 ай бұрын

Glad it was helpful!

Thank you so much! I've been doing much the same approach copying & pasting transcribed tables into Excel, but I never knew the 'paste special' option, and I was stuck transposing enormous columns of data -- you've just saved me hours on future work! Another Excel filter trick I use a lot: some of the surnames I search for were very often misspelled, so filtering isn't always as effective as doing a Find with * and ? wildcards. I highlight in yellow any hits the Find turns up, and then filter by color to see only a list of the possible matches.

@GenealogyTV

10 ай бұрын

Yes and I filter surnames in Excel with just partial names. For example Hen will get me all Henly’s and Henley’s. Plus you can select from the drop-down menu in the surname column multiple names to compare family names.

Genius!!! Thanks, Connie.

@GenealogyTV

10 ай бұрын

Thanks.

Wonderful! It is a challenge to do what we do, but we keep going. Working angles and names variations and even trying them backward and forward!

Wow! Fascinating!

great lesson! great to hear your excitement!

@GenealogyTV

10 ай бұрын

Thanks Deborah and thanks for supporting the channel.

This information is absolutely vital. I can’t wait to do it myself. thank you 😁🙏

@GenealogyTV

7 ай бұрын

Glad it was helpful!

Thank you! This is one of the best videos I’ve come across, and not just for genealogy. I’ve spent many hours reviewing original census images, trying to solve similar mysteries. I had no idea I could copy the transcription data and paste it into excel. (That noise is my palm hitting my forehead.)

@GenealogyTV

10 ай бұрын

LOL. You’re too funny. Enjoy the journey.

Great job Connie! Awesome detective work!

@GenealogyTV

10 ай бұрын

Thank you!

What a great way to find missing family members. So much easier than going through every listing in a census. I can't tell you how many times I've reviewed complete censuses trying to locate those elusive people!

@GenealogyTV

9 ай бұрын

Agreed. When I started out (before computers, that dates me) I had to scroll for hours through microfilm reading each line until my head was spinning... hoping I didn't skim over the one person I really needed. Thank God for indexers and computers! :) Research is so much faster now.

Wow, love your work. You are great.

@GenealogyTV

10 ай бұрын

Thank you! Cheers!

Fantastic! I will make a spreadsheet like that for the census in my challenging areas and save it. Maybe someday Ancestry will have that as a feature.

OMG.....great find!!!! I have a similar story on my great-grandfather. The story goes when his mother remarried following the death of his father, the step-father did not like him. So, I have not been able to locate my great-grandfather. I need to use these tips ASAP!!! Thank you so much

Super helpful. Thanks!

Excellent tip. Thank you.😊

Fantastic! What a great lesson! Thank you!

@GenealogyTV

10 ай бұрын

Glad you liked it!

Absolutely brilliant!

@GenealogyTV

10 ай бұрын

Why thank you!

Brilliant! Thank you for sharing.

@GenealogyTV

10 ай бұрын

My pleasure!

Connie I know this is an older video but I still wanted to say thanks for teaching this trick originally so long ago. I have actually built a shortcut on the Excel toolbar that I click that does the paste special for me to save me from doing the right click then paste special then text only. I also wrote an Excel VBA script that automatically fills in the Image number column when I paste data into the sheet then it selects the next blank cell in column B so all I have to do is copy the census page from Ancestry then click my hotkey in Excel the go back to Ancestry. It has saved me so much time. Thanks again!

@GenealogyTV

5 ай бұрын

Thanks. I’ll have to figure out how to do that hot key function. I appreciate the comment.

Thank you for this. I've just bookmarked your GoogleSheets video to attempt this one of these days. I have family missing in the 1920 census I'd like to find.

Brilliant! I can’t wait to try this. Thank you so much 😊

@GenealogyTV

10 ай бұрын

Hope you enjoy it!

@TheZeebop2007

10 ай бұрын

@@GenealogyTV It is so useful. Thank you again!

Wonderful instructional video. Thanks so much!

@GenealogyTV

9 ай бұрын

Thanks

Thank you for sharing, I hope this trick works for me on a similar problem!

Wow, amazing work.

Wow! You’ve re-ignited my interest. 😁I’ve been stuck for YEARS on my great grandfather and grandmother (unmarried I think) but now I’m going to try again. Many thanks. 👍

@GenealogyTV

10 ай бұрын

Go for it!

Great work!

@GenealogyTV

8 ай бұрын

Thanks!

Wonderful work!

@GenealogyTV

10 ай бұрын

Glad you like it!

Fantastic research!

@GenealogyTV

10 ай бұрын

Thank you!

You are the best teacher! Bless your heart. You're my favorite genealogy KZreadr.

@GenealogyTV

4 ай бұрын

Ah thanks

I use Excel all the time to manage data at work. I love filters. You could also write a macro to automate some of the pasting and formatting. 👌

That was amazing. Thank you so much.

@GenealogyTV

10 ай бұрын

You are so welcome!

Wow that was amazing!