when doing genetic genealogy research sometimes you have a long list of data that you want to
get from a website onto your computer this data could be on Ancestry GEDmatch or any
other website well can this be done yes yes it can howdy I'm Andy Lee with families Fanatics
and today we're going to be talking about tables and getting information from tables from the web
I've had users that have asked me hey how can I download some of this information from GEDmatch
well there are some places where gedmat actually has a button to download that information but not
always what do you do when GEDmatch doesn't have an easy download button today I'm going
to show you what to do now on gen match tables can come in many different varieties but copying
and downloading that information is going to be relatively similar for any of them so here this
is from the one to many the original results and you can see here it's just a simple table
now one of the things I can do is just use my mouse and highlight everything that I want
once it's highlighted I can do control C to copy it and now I'm going to put it somewhere
start with a document a text document this could be in word Google Sheets and just in a blank
document I can do control V and that will paste it and you can see here this is actually pasted
everything in that table format and so it's really just a nice copy of what I had before
let me go back now another way I could paste it is without the formatting or really giving
it the formatting of whatever I am in so the formatting of this text document now to do that
I do control and then the shift key and then V again V for paste now you'll notice that this
paste was not the same it's not in this table format anymore although it does look like it
is deliminated by a tab so if I go from kit to this check mark you can see it I just have to
hit the arrow key once so there's not spaces there there's tabs there and so what this does
is this pastes it as a tab separated file so I could save this and then I could open this up
in a spreadsheet if I wanted but if we're going to get it into a spreadsheet eventually why not
just paste it in a spreadsheet so let me go over to my spreadsheet now again I still have that same
information and I'm going to just do the control V in the spreadsheet and we'll see how this looks
you'll notice here that I copied from a table and when I was in the text document and I pasted it
paste it as a table with all the lines and everything but in this spreadsheet when I
paste that table information you can see that it is figured out that this is a table and put it all
in the proper place there's no lines for the table like I see in the text document but it is still
all delimited out in columns and rows like I would be expecting and so this is a great way if you are
looking at a match list in GEDmatch or one of the other tabled formats that you want to save that
information and be able to manipulate it later or search through it in other ways you can copy that
all over to a spreadsheet in this manner now since I showed you what copying with all the formatting
does let's look what copying without the formatting does so remember control V is a copy
with the formatting control shift V is copying without the formatting so if I do that here
it almost looks the exact same the only difference let me copy it again is you'll see is the copying
with the formatting kept the same font size but it also kept the hyperlinks that are there within
that table so usually you want to copy with formatting if you're copying to a spreadsheet
because you can not only save that information but you can save the hyperlinks of where you're going
to as far as other searches other match lists whatever hyperlinks they have in there are going
to be preserved so here up top this is without formatting the nice thing about a spreadsheet
is it still puts it all in where you want it and at the bottom here is with formatting again with
a text document if you copy it with formatting you're going to get a table and if you copy it
without formatting you're going to get it as this tabbed eliminated file type now there's more than
one way to skin a cat and there's more than one way to copy and paste table information into a
file that we can use I just went and highlighted the parts that I want now let me show you one
thing that is important to note on some of the other tables this is the one to many but it is the
newer version now you'll notice here when I try to highlight everything this first row the title
row is not high highlighting but if I start down here I can actually highlight the information this
is important to know because if you're copying a table like this you may need to move that first
line around or you may need to put in the titles what each column represents so that is how you can
download the table information from GEDmatch onto a spreadsheet and be able to manipulate it however
you need to in order to do the research that you have now if you like this video then be sure to
give it a thumbs up and if you want to join FHF Xtra we have more webinars and live streams that
are available just to members each month as well as all of our backlog of the members only section