FamilySearch - Analyze Search Results in a Spreadsheet
4.6 هزار بار بازدید -
7 سال پیش
-
Analyze Search Results in a
Analyze Search Results in a Spreadsheet
Learn how to easily sort, tag, and analyze your search results by exporting them to a spreadsheet. This advanced search feature on FamilySearch is a helpful way to keep track of your findings in your genealogy research.
Watch Robert Kehrer's full presentation, "Finding Elusive Records in FamilySearch" - http://goo.gl/fokbhU
TRANSCRIPT: FamilySearch-Analyze Search Results in a Spreadsheet
OK, moving forward, let's analyze results in a spreadsheet. This is a really advanced feature. And we noticed that users often want to do things with their search results that we can't easily support on the website. They want to go through each search result and maybe tag them as being of interest or not, a yes, no, maybe. They want to sort the search results in all different kinds of ways and do various advanced analyses on them.
Rather than try and build all that into the website, we allow the users to export the set of search results into a spreadsheet. And that's done like this.
I'm going to do a very broad search just to get a bunch of records back. I said, "Show me all of the records where the surname is Allor and the birthplace was St. Clair, Michigan, in a 20-year time range." I only want records from the United States, in Michigan. And it's a pretty broad search.
All the Allors from St. Clair, probably my family. So I get 472 of these records. I can do 75 per page. And if I'm logged in--this is a feature that's only available if you're logged in to FamilySearch--but if I'm logged in, I will see this button over here at the top of my search results, on the right-hand side, that lets me export my search results into a spreadsheet.
If I click that button, it's going to pop up a dialog. It'll let me give that file a name; it will save it out to my hard drive. And opening up that file in my favorite spreadsheet program will show me all the data that was on those records. It will have the score, the full name, the gender, birth date. In fact, these data columns keep going out to the right because we break each piece of data out into its separate column.
At the top, I have the search string. People often come and say, "Hey, I did a search yesterday. I came back and did it today. I got all different kind of results."
And the answer is "Well, yes, we publish new records every day." But it's very likely, if you didn't get pretty close to the same results, you did a different kind of search. So we gave you a link to keep the searches identical.
We also tell you when you did it. So you can do a search today; come back in a couple of months; do the new search; take the two files; subtract them from each other in Excel, for instance; and find just the new stuff that's been published. There's all kinds of cool analyses like that that you can do.
Anyway, people often ask, "Why did you dump it out in the '.xls' or Excel file format?" And the answer is "Because almost every spreadsheet application in the world will open up Excel files." We're not shilling for Microsoft. But it's a very common spreadsheet format that everybody can open up.
Visit the FamilySearch website: https://www.familysearch.org
For more from FamilySearch, follow us:
Facebook: Facebook: familysearch
Twitter: Twitter: FamilySearch
Instagram: Instagram: familysearch
Pinterest: Pinterest: familysearch
Learn how to easily sort, tag, and analyze your search results by exporting them to a spreadsheet. This advanced search feature on FamilySearch is a helpful way to keep track of your findings in your genealogy research.
Watch Robert Kehrer's full presentation, "Finding Elusive Records in FamilySearch" - http://goo.gl/fokbhU
TRANSCRIPT: FamilySearch-Analyze Search Results in a Spreadsheet
OK, moving forward, let's analyze results in a spreadsheet. This is a really advanced feature. And we noticed that users often want to do things with their search results that we can't easily support on the website. They want to go through each search result and maybe tag them as being of interest or not, a yes, no, maybe. They want to sort the search results in all different kinds of ways and do various advanced analyses on them.
Rather than try and build all that into the website, we allow the users to export the set of search results into a spreadsheet. And that's done like this.
I'm going to do a very broad search just to get a bunch of records back. I said, "Show me all of the records where the surname is Allor and the birthplace was St. Clair, Michigan, in a 20-year time range." I only want records from the United States, in Michigan. And it's a pretty broad search.
All the Allors from St. Clair, probably my family. So I get 472 of these records. I can do 75 per page. And if I'm logged in--this is a feature that's only available if you're logged in to FamilySearch--but if I'm logged in, I will see this button over here at the top of my search results, on the right-hand side, that lets me export my search results into a spreadsheet.
If I click that button, it's going to pop up a dialog. It'll let me give that file a name; it will save it out to my hard drive. And opening up that file in my favorite spreadsheet program will show me all the data that was on those records. It will have the score, the full name, the gender, birth date. In fact, these data columns keep going out to the right because we break each piece of data out into its separate column.
At the top, I have the search string. People often come and say, "Hey, I did a search yesterday. I came back and did it today. I got all different kind of results."
And the answer is "Well, yes, we publish new records every day." But it's very likely, if you didn't get pretty close to the same results, you did a different kind of search. So we gave you a link to keep the searches identical.
We also tell you when you did it. So you can do a search today; come back in a couple of months; do the new search; take the two files; subtract them from each other in Excel, for instance; and find just the new stuff that's been published. There's all kinds of cool analyses like that that you can do.
Anyway, people often ask, "Why did you dump it out in the '.xls' or Excel file format?" And the answer is "Because almost every spreadsheet application in the world will open up Excel files." We're not shilling for Microsoft. But it's a very common spreadsheet format that everybody can open up.
Visit the FamilySearch website: https://www.familysearch.org
For more from FamilySearch, follow us:
Facebook: Facebook: familysearch
Twitter: Twitter: FamilySearch
Instagram: Instagram: familysearch
Pinterest: Pinterest: familysearch
7 سال پیش
در تاریخ 1396/11/09 منتشر شده
است.
4,635
بـار بازدید شده