Hello again ... you guessed it ... Ancestry DNA matches page changed its format, and I have now been able to adjust the Spreadsheet to use the new format. This time, I've created TWO versions of the worksheet, one that works with the SHIFT + CTRL + V when you paste just the values, and the other worksheet that works with the regular CTRL + V which will paste the full comments, including the Live Links back to each DNA Match - and - this worksheet preserves those live links too! SO, you can use whichever version you prefer. A couple notes: * Both worksheets come with 4000 rows with the formulas filled in. There are more formulas in these new versions, so, the sheet takes a bit longer to process the data and go through each of the formulas after you do the copy & paste. Be patient. Of course this effect is magnified on older machines. * If you go BEYOND 4000 rows (yikes), you will have to manually copy the formulas from row 4000 (or so) downwards to the end of the sheet so that it continues to work properly. * The formulas are setup assuming that the DNA Match page is in its "natural state", sorted by RELATIONSHIP. If you sort it by DATE, the Category formula doesn't work right, and you won't get the results you want for names etc.. * I was able to properly separate Category / Name / Managed by - I think - finally, and, MOST of the Notes section will behave themselves now! * I've left a row for Groups - but - I can't grab that info for you (since it's not in text) , but if you want a place to manually add it yourself - it's there for you. Until the next time Ancestry decides to help us out with a new feature and format ... Enjoy! - Greg :-)
@@aprilgoldenberg429 - great question. The only way I've found is to just keep scrolling down to the bottom of your Ancestry DNA Matches page so that it is forced to load more and more matches. The way the page is (currently) programmed, it loads SOME but not all of your matches at a time, that way the page loads pretty quickly initially, and you're not left twiddling your thumbs waiting for a long list to appear. The down side, of course, is that you have to do this, scrolling down, to load more. I don't know of a way to force it to load ALL of your matches at once - and - I would also suggest that at some point, you'll probably want to cut-off the matches you're tracking because the # of cM that you share is so small, it's almost impossible to find the connection, it's so far back. I know completists will argue - and that's fine - go crazy! I just know that my match page is like a bottomless well - it never ends.
@@uptergroveGreg I used to agree about the small cM matches until I saw known relatives appearing in some of those. Of course those help me make the connection with some of the higher matches that I can’t figure out how they are related to me. I guess I’ll be at it for a few days. Thanks for the quick response!
@@aprilgoldenberg429 I've heard similar things from others - so go for it. In my own list, I have many maternal French Canadian matches, and anything less than 15 cM is inevitably so far back , and related in so many different ways, that it's impossible for me to detangle. If I find a paternal match in that range I rejoice... but then I've been fooled because I see an Irish lastname -yay - only to discover, the match's mother or grandmother was French-Canadian! Ahh .... fooled again!
Just to say that after many tries that didn't paste anything into my copy of the spreadsheet, something caused Google to tell me that I needed to I install Google Docs Offline as a Chrome extension. Then it worked! I hope this might be useful to someone.
Now it's working! Persevere everyone! Download that extension, and don't forget to refresh your pages... I also had particular problems with MY shared matches, but I didn't have any problems with my father's shared matches. At first it only gave me the top 55 matches, so I copied all the data from the top downwards and waited, and waited... I now have 500 or more. (Thinking my site didn't work because I just have TOO MANY shared matches from my mother's side)
If you have DNA from Ancestry, then you'll want to watch this video: czcams.com/video/_rE6EXQPlzQ/video.html Be sure to become an FHF Xtra channel member to access additional training with spreadsheets including: - Creating a Leeds Method Charts using GoogleSheets and MyHeritage czcams.com/video/EeeDva2wAWY/video.html - Genealogy Spreadsheets Tips and Tricks czcams.com/video/_NGdkLTwZ_I/video.html
UPDATE!!!! The Google Spreadsheet has now been updated to handle the latest version of the AncestyDNA matches format released in June 2024. If your AncestryDNA matches page now shows "square dots" with a single character in them, and you can only see 20 or 50 matches at a time, then use the updated version (see link above), and use the 2024 Raw Data tab. On the Instructions page of the spreadsheet is also a link to a CZcams help video I made about the update - including - how to now capture the Custom Dot Groups!
The UPDATED spreadsheet should work now. Do you still have the link? If not, sign-up again at this website www.familyhistoryfanatics.com/post/download-ancestrydna-matches-hack The problem was in the two versions of Ancestry's DNA match list. Keep sending in the tweaks!!! We'll make this work awesome.
Thank you so much! I really appreciate this, it was driving me nuts not being able to get the data into spreadsheet form as I'm trying to find out who my mystery great grandfather was and needed to compare my results between all the different tests :-)
UPDATE: I have tested a new version of the Google Spreadsheet which I believe will now work with either version of the Ancestry DNA Match list (the format I see here in my corner of the internet in Canada, and the version some of the rest of you are seeing in other parts of the world). Thanks to those who helped test out the new formulas. The new version has TWO worksheets - one if you have a VIEW MATCH button at the end of each row, and one worksheet if you do NOT have that button. I will make a post here as soon as I've updated the Google Spreadsheet. (IT IS NOT UPDATED YET - please be patient - I need to coordinate with Devon.) Thank you for your patience ... the fix is coming ... I'm keen to share it with you all ... thanks for the very positive responses so far from those that have used it successfully, and those testers who have tried the new version.
Hi Greg. So grateful for all of the hard work you are so willingly sharing with all of us. I noticed a couple of cell hiccups (at least I think they are) and wanted to know if you'd like to connect offline so I could share them. If you're interested, let me know how to reach you. I'm on Ancestry, 23andMe, FTDNA, WikiTree, Geni, FB, etc... Thanks again!
Hi all! I've heard from a number of you today - and there is a problem with using this spreadsheet if your Ancestry DNA Match list doesn't look like mine. Mine has a big VIEW MATCH button at the end of each row. If yours does NOT have that button, but instead the coloured dots at the end of each row, then the formulas won't be able to perform their magic. I'm working on a fix for this, and will post a comment here as soon as that is ready. Sorry for this - I didn't realize that they were changing the format of their matches page - and that the change was not consistently applied. My bad. - Greg :-)
Hi Greg, thank you for doing this and for clarifying why it isn't working for some of us. I'm really excited at finally being able to download my own data!
Greg Clarke, I have used your program in the past and it worked great! Good luck trying to keep up with the never-ending changes and variations. Thank you for developing it for all of us.
Thanks I still have the old view but I'm using ancestry.co.uk as thats where all my ancestors are but Maybe I'll log in vis .ca and see if I get the access
I just updated the Google Spreadsheet to include a column that will display Which Side a match is on, if you have taken the time to identify that using the "Do you recognize this match?" buttons. The column will either be blank, or have Both, Mother's, or, Father's in it - so - yet another way you can sort your results if you wish.
The macro to clear data from the worksheet is under "Extensions" in my Google Docs online app, not Under Tools. While I can cut and paste the results, whether as is or just values, the formulas are not populating columns G through P I think because as other person mentioned my list of matches is not laid out in the same way yours is. I can share a snapshot if you would like; basically, I have 3 lines of information for each match, where your view only shows 2 lines.
Please send a screenshot to Greg (email in the spreadsheet). And then send me a copy of the email using the form here. www.familyhistoryfanatics.com/contact
Greg has found the problem and we've updated the spread sheet. Will you try again? Do you still have the link? If not, sign-up again at this website www.familyhistoryfanatics.com/post/download-ancestrydna-matches-hack
It wouldn't work in Safari on my Mac. So having avoided using Chrome for years (I don't like change) - I bit the bullet and moved to Chrome........I can't get it to do a CMD A select but that's trivial - I'm happy to scroll down. BUT..... OH MY GOODNESS - THANK YOU!!!! This has absolutely driven me nuts for years. Hubby and I have tried all sorts - and the number of hours I've spent copy, paste, delete all the gunk. Urrgh!!! I could kiss you! Fab.
Have you sent Greg an email? His email address is in the Google Sheets file. There were some changes that Ancestry made to their match list that he has updated since we released version one of this tool. Greg is constantly trying to improve the tool, and users help him do that. Good luck and let me know how it goes.
So excited that this is coming. Worked on this with my hubby for 3 hours now and can't seem to get it to work. Found this comments list and it seems I am having the same hiccup with a different view. I'm in Canada. Tried Chrome, Edge and Excel and all browsers sort the Ancestry data so the grouping dots are at the end of the rows of matches. Also using Windows 10 if that matters. Will be waiting with excitement to see the 'tweaked' spreadsheet. :-) Thank you very much for your hard work!
@@FamilyHistoryFanatics I did receive the new updated spreadsheet but the NO BUTTON option is still not working. I cleared all the data, copied only a small number of Ancestry matches for a test, used Shift, Control V and the raw data drops into Column A but it does not auto populate the righthand portion of the spreadsheet. Any other suggestions with what I can do. Seems like a fantastic tool I would love to get it working.
Hi @@shannaandrews9807 - I've just updated the spreadsheet - my version (in Canada) changed its format this week - if yours did too, see if the latest Worksheet (NEW View Button) does what you want. The other issue I've heard is that not all browsers do the copy and paste the same way. I use Google Chrome on a Mac, and it works better than FireFox. Safari and Opera seem to play nice as well. I don't have a Windows to compare that too, but hopefully something will work out for you.
It stops filling in the data in columns T to the end showing 1. Add more family, U has Copy the last row that has formlas in columns T through AE, and so on. The data is in Column A but won't process
When I do the control a it does not select all the text. The most important data I want in my Excel file is the centigrams.. did ancestry change the display so you can't copy the text on the screen?
Same for me. I put my cursor in the "yellow box" and press SHIFT+CONTROL+V a little box with word "paste" appears on my screen and then I click it. Copied Text Only goes into far left column. Nothing to the right. Also, I did try to download your google spreadsheet in Excel. Now on Mac I go to downloads and then open it with Excel. The only problem is the "formula's do not transfer over. Here is what I get =IF(ISERR(FIND("shared DNA",A3:A50500)),"",ROW(A3:A50500)). I also open the Excel File and the top 3 rows left of 1st column do not line up correctly. The information actually appears below the line below the "Yellow Line" (oops not below the yellow line - to right but down a few rows. Greg, I'm sure that you may have to do a few "fine tuning" to the instructions. Clearly I/we must NOT be doing something correctly based on your verbal instructions. Await to hear back.
I get the same - what am I doing wrong, just noticed you have your dots on 2nd row, mine are at the end of first row, guess this is making a difference
As far as I have been able to figure, the cause of that could be because the formulas used are expecting the copy & pasted info to be a bit different than how Ancestry is displaying it for those of us in the States compared to how it does in Canada...or maybe the differences are because of which browser used to access ancestry...just something is definitely different. If you look at the initial info on the worksheet before we clear the creator's info out, you'll see his info includes a shared % and some fields include this symbol | ...I have no experience with how to adjust the formulas to match what we are getting from Ancestry, but I have at least figured out that is where the hiccup comes into it.
It's broken. I followed the directions exactly and it doesn't copy to correct fields and copies some of the names twice. I even tried all 4 of the different formats and none of them copy correctly. I have the "do you recognize them?" type match list.
That was the problem but yay!!! We should have it fixed. Do you still have the link? If not, sign-up again at this website www.familyhistoryfanatics.com/post/download-ancestrydna-matches-hack
Fantastic! I've been manually doing this using a few filters, but this is great, however, i have notes on a lot of my matches and this seems to mess up the sheet a little, happy to explain further
First off Greg Clarke, THANK YOU!!!! Now that I have the spreadsheet I'm excited, but that excitement dissipated when I was scrolling down and copying all of my matches. As I got closer to the 25 cM pages it began to go slower and slower I was in about 2 hours at this point. Next thing, 30 minutes later my page started crashing and then crashed! I lost all of my copy/highlights. Is there a way to copy a few hundred at a time paste it on the spreadsheet and go back for more and keep adding a few at a time or must they be all copied at the same time? Second question, what are y'all doing with the info once you have it in the spreadsheet? How are you grouping them to know you are related and how? In ancestry, then going back and finding those matches? I'm not sure how to separate, group, or color-code them on the sheet. I don't even know which are my mom's side and my father's side without constantly going back to my ancestry. That would be very time-consuming. Please let me know if you have a video on this. Thank you again this is awesome!
Great update to the Spreadsheet. I love putting all my info into Spreadsheets but am new to Google Sheets, and don't know many functions other than basic Excel ones. Both of Greg's versions are working fine for me, but quick question: Can you sort the Column "People in Tree" numerically? I can't, because it has mixed numbers and words, but there might be a trick out there. Other observations: On the original version, I could only display approx. 550 shared matches. I thought therefore to break up my searches, by Surname of Interest, or Place of Interest, using the Duplicate function on the lower Tabs. It limits me to 5,000,000 cells (I think), so i can only create 3 tabs. I have therefore created MANY new Files, with 3 tabs each, to sort my data... Loving the work you're doing in this Group!
I'm not able to populate the "NOTES" column but I can see that those notes are being copied. Trying with Safari and Firefox. I don't use Chrome. Trying with each version of your template. (My Ancestry has the 'Do you Recognize" feature.) Neither puts anything into the 'Notes' column which is the most vital info I want in the spreadsheet. I'm 73-years young and new to creating spreadsheets so all gentle suggestions are welcome. Thx.
As explained in this video, send Greg an email. Ancestry is constantly updating and he goes in and adjusts the spreadsheet accordingly. Or, there might be something you're not doing. Anyway... the email is in the spreadsheet and he'll be happy to help.
Hello. Used this before, but I am stuck, I pasted my data into your google sheets copy. Everything is in the first column. How do I get it to populate the other columns?? I am hoping to extract names only. Please help.
The link to the spreadsheet is available through the description. There is a consent to send form which has a follow-up email that double confirm that you want the link to the spreadsheet. After you confirm your email, then you'll receive a link to Google Sheets. Save the Google Sheets file to your Google Drive account by following the instructions in the email or on the spreadsheet. Once you do all of those steps, you can then follow the instructions in the spreadsheet on where to get the information to copy, where to paste the information in the primary sheet for the formulas to work, and then you can look at the spreadsheet that has the list you're seeking.
Tried it, it doesn't work. I also do not see any benefit of putting it into a spreadsheet. It's a lot of fiddly work for little benefit. Unfortunately, too many youtubers are putting out "tips and tricks" videos, "hints and clues," and other how-tos that eat up a lot time and do nothing to advance actual research.
If it didn't work, there is an email to reach out to the spreadsheet developer to troubleshoot why it's not working. Ancestry changes their layout frequently and sometimes it's not working because Greg needs to make a change. Why do you download the match list - you don't need to. HOWEVER, since Ancestry doesn't offer some tools for understanding matches, many folks want to download their match list on Ancestry to keep better notes, filter the results, and compare what they see on Ancestry to Myheritage, 23andMe, Family Tree DNA, GEDmatch, and so forth. This tool and tutorial came out of a Channel Membership training session when attendees wanted a way to download their match list but Ancestry doesn't allow that. Greg graciously programmed a tool that could achieve that goal and then shared it with us for our members and the general public. Yes, many genealogists on CZcams share lots of tips and tricks. There are some I dislike and some I find amazing. It's up to each genealogist to take the suggestions and do with them what they will. Good luck
Tried with no results. Doesn't populate the sheet. My display is not the same. Tried in Chrome, Firefox and offline. Google sheet added Raw Data in row above the other headers. A5 becomes A6 but pasting in never works.
Send an email to Greg. The email is in the spreadsheet . That way if there's a problem, he can make changes. Or we can help figure out the steps we need to tell folks.
@@FamilyHistoryFanatics I don't see an email for Greg in the spreadsheet. Anybody find it? I so hope he can help those of us who all seem to have the same problem.
@@pamelahickmann5781 his email is on the instructions sheet, towards the top, near his name (at least it was as of last I accessed the sheet yesterday)
Greg has found the problem and we've updated the spreadsheet. Will you try again? Do you still have the link? If not, sign-up again at this website www.familyhistoryfanatics.com/post/download-ancestrydna-matches-hack
Thank you Greg, this is great. For reasons I'm sure that you understand, what I'd really like to be able to do is download all of the "Shared Matches" data for each of my own matches, and get all of that information into a spreadsheet. Any thoughts?
A gin & tonic are looking pretty good about now. Firstly thank you for all the work you have put in for us all. I have managed to finally paste from DNA list, though all the data goes in column A with the Demo info still in all the other columns. I tried removing the Demo info. No difference. Noticed that my Relationships & DNA % & Cm don't highlight to copy. My DNA has View Match & coloured dots. What am I Not doing correctly?
First, the spreadsheet only works in Google Sheets. Second, you have to use the correct tab for the layout that you see on Ancestry. Ancestry is not showing the same DNA match list view to everyone. There is an update in the instructions on the first tab of the Spreadsheet to help you know which tab to look at. If you have any further questions, send Greg and email (also on the first tab of the spreadsheet) and he'll help you out. Perhaps there is a glitch in the coding or perhaps he needs to improve the instructions. Good luck and let me know if that solves the problem.
I can do everything except ‘Paste’. I’m using an iPad 11.5, current iPadOS, and have tried with and without using the Keyboard that Apple made for the iPad.
Hi. I'm a new member today and have enjoyed watching a few of your really educational videos. Thanks. Regarding Greg's excellent spreadsheet for Ancestry DNA matches, Devon mentioned at the end of the video something about updating the spreadsheet with new matches from Ancestry but I couldn't understand how (a) to harvest the new matches since the last time you looked at Ancestry; and (b) how to add in the new matches to the spreadsheet without affecting the data already in there. Is there a set of instructions somewhere for this? Thanks.
The spreadsheet just does a "dumb" copy and paste and interprets the result into a table. It doesn't have the "smarts" built into it to know what is new and what is old. BUT ... if you use a filter to only display the new matches on your Ancestry DNA Matches page, then you could copy & paste those into the spreadsheet, and then add the resulting table of NEW rows to the bottom of your Master Spreadsheet, which I'm assume you're keeping in a safe place somewhere else.
Hello, there! I have received the shared Google Sheet, but it seems as though it has been modified by someone who has not copied the sheet, therefore has directly modified it. Might it be possible for you to share a clean Google Sheet file? A suggestion would be if you replace the word EDIT with the word COPY in the link you share: it forces the receiver to make a copy of the file; in that way, there is no inadvertent modification. I have been unable to get the list populated. I'm not sure if it is directly related to the inadvertent edit by others or because my Ancestry visual is not the same as it is in the video. I look forward to being able to use the Google Sheet! Thank you for creating this!
Hi Connie. The spreadsheet comes with some sample data so that you have a sense of what to expect when you copy your own on top of it. I didn't add many rows, thinking that for most people, it would automatically overwrite my sample. You can always clear the data away from column A and start fresh. For some, though, a totally blank slate is a little unnerving, hence my choice to leave something there as a sample. Excellent point though - about the difference between /edit and /copy for the Google Link !
@@uptergroveGreg Thank you so much for your reply! I finally figured out how to do the spreadsheet and I cannot thank you enough for the work you have done and provide gratuitously. God bless you!! (Sorry for my late reply...).
I love this spreadsheet! Does anyone know of a way to scrape data from Thrulines? I have two brick wall Lees that I suspect are siblings from a particular NC Quaker Lee family and I want to compare the Thrulines for these two, their spouses, and the suspected grandparents. I know Thrulines is based on individual trees, but I think I may find some good info. I've heard from others that they just copy and paste into a spreadsheet on their PCs, but that doesn't work with a Mac. I'd type them in, but that would involve some 250 names. Ideas?
This is cool, but when pasting matches with Ctrl+V and Shift+Ctrl+V,: I noticed: -the former had embedded links (names, trees, etc), the latter did not. Why is that? -neither has Groups (Col P). Why not? -the former does not have Notes, at least not in Col Q ... I noticed some notes in Col G There are other issues, but probably too much to note in this comment.
The embedded links vs no links is the key difference between a straight PASTE (with links) to PASTE VALUES ONLY (just the raw text, nothing fancy, no highlighting, bold, or fancy links). The formulas generally work better with raw text to parse - that's why I recommend that "flavour" of pasting for best results. (However, there is something cool about having a table that has active live links to your DNA matches .... that's cool too ... ) Maybe you do two versions and merge them .... (I'll leave that as an exercise to the intrepid spreadsheet fans out there to play with ....)
Hi again! Just did another update to the latest worksheet : NEW View Match btn - to fix a problem with the Notes column. It may not be perfect still, but it seems to catch more of the Notes and place them correctly (instead of placing them in the first column of the next line).
Hi Greg, thanks for the update, was almost there with it myself, frustrating that it was broken! Couple of issues I'm having, as I have my parents DNA I have Mother's side & Father's side added in to the mix which throws out some of the data. Also, I have some "tree unavailable" as well, so that breaks the tree column I can share my sheet with you if you are interested to work it out, I'm banging my head against the wall!
If you use Google Drive, it should work. The formulas are built for anyone who can access Google Sheets. Since Chromebooks connect to Google Drive, I'm not sure what the problem is. What browser are you using?
I can not get it to paste without format. (I'm familiar on copy and pasting) I'm using firefox. Paste with formatting works but as we know it makes it "messy". Thanks in advance for any helps on what to do.
Hi there utubelaw - do you have access to Google Chrome ? It seems to "play nicer" than FireFox I've found. Not sure why all browsers aren't created equally - especially with such key functions as copy and paste ...
As stated in the video, no it won't. Each program handles the coding differently which would make more work for the volunteer to manage. Since he designed this at no compensation to himself, we chose the most sharable platform - Google Sheets.
That is frustrating. There are some formulas to separate first and last names, but since everyone doesn't put names in a uniform pattern, this isn't as helpful either.
Great question. Several things. You can use it to keep track of your DNA matches across platforms, sort the information to do different analysis, and more.
That's too vague. The table does work only in Google Sheets. If there is an update on Ancestry, we email Greg, the developer, listed in the spreadsheet. He makes changes and we all update our sheet again. You have to save a copy to YOUR Google Drive account. If you follow all of those steps, it works. Which step tripped you up?
@@FamilyHistoryFanatics the spreadsheet will not let me paste into it....I'm in Canada.....I have used these type of spreadsheet before for chromosome mapping and pretty easy but this one seems to perhaps have different settings...maybe permissions? not sure but it needs some tweeking!
If you're a pro at Copy and Paste, that's awesome. Recognize, we're serving a broad audience that is typically 55+ who ask that we walk them through every step (including copy and paste.) Isn't it great that you can skip ahead in the video to get to the portions you need? Cheers.
Hello again ... you guessed it ... Ancestry DNA matches page changed its format, and I have now been able to adjust the Spreadsheet to use the new format. This time, I've created TWO versions of the worksheet, one that works with the SHIFT + CTRL + V when you paste just the values, and the other worksheet that works with the regular CTRL + V which will paste the full comments, including the Live Links back to each DNA Match - and - this worksheet preserves those live links too! SO, you can use whichever version you prefer.
A couple notes:
* Both worksheets come with 4000 rows with the formulas filled in. There are more formulas in these new versions, so, the sheet takes a bit longer to process the data and go through each of the formulas after you do the copy & paste. Be patient. Of course this effect is magnified on older machines.
* If you go BEYOND 4000 rows (yikes), you will have to manually copy the formulas from row 4000 (or so) downwards to the end of the sheet so that it continues to work properly.
* The formulas are setup assuming that the DNA Match page is in its "natural state", sorted by RELATIONSHIP. If you sort it by DATE, the Category formula doesn't work right, and you won't get the results you want for names etc..
* I was able to properly separate Category / Name / Managed by - I think - finally, and, MOST of the Notes section will behave themselves now!
* I've left a row for Groups - but - I can't grab that info for you (since it's not in text) , but if you want a place to manually add it yourself - it's there for you.
Until the next time Ancestry decides to help us out with a new feature and format ... Enjoy!
- Greg
:-)
Thanks so much Greg. You're truly amazing and so generous with your talents and time.
HI Greg. What if you want to select all of the matches? Do you have a faster way of getting the matches to load on the Ancestry page?
@@aprilgoldenberg429 - great question. The only way I've found is to just keep scrolling down to the bottom of your Ancestry DNA Matches page so that it is forced to load more and more matches. The way the page is (currently) programmed, it loads SOME but not all of your matches at a time, that way the page loads pretty quickly initially, and you're not left twiddling your thumbs waiting for a long list to appear. The down side, of course, is that you have to do this, scrolling down, to load more. I don't know of a way to force it to load ALL of your matches at once - and - I would also suggest that at some point, you'll probably want to cut-off the matches you're tracking because the # of cM that you share is so small, it's almost impossible to find the connection, it's so far back. I know completists will argue - and that's fine - go crazy! I just know that my match page is like a bottomless well - it never ends.
@@uptergroveGreg I used to agree about the small cM matches until I saw known relatives appearing in some of those. Of course those help me make the connection with some of the higher matches that I can’t figure out how they are related to me. I guess I’ll be at it for a few days. Thanks for the quick response!
@@aprilgoldenberg429 I've heard similar things from others - so go for it. In my own list, I have many maternal French Canadian matches, and anything less than 15 cM is inevitably so far back , and related in so many different ways, that it's impossible for me to detangle. If I find a paternal match in that range I rejoice... but then I've been fooled because I see an Irish lastname -yay - only to discover, the match's mother or grandmother was French-Canadian! Ahh .... fooled again!
I have been looking for a good way to do this! And behold the good people at Family History Fanatics has done it!
Thanks
Just to say that after many tries that didn't paste anything into my copy of the spreadsheet, something caused Google to tell me that I needed to I install Google Docs Offline as a Chrome extension. Then it worked! I hope this might be useful to someone.
I'm stuck at that stage also...
Now it's working! Persevere everyone! Download that extension, and don't forget to refresh your pages... I also had particular problems with MY shared matches, but I didn't have any problems with my father's shared matches. At first it only gave me the top 55 matches, so I copied all the data from the top downwards and waited, and waited... I now have 500 or more. (Thinking my site didn't work because I just have TOO MANY shared matches from my mother's side)
Yay. Glad you figure it out.
Thanks for figuring it out. We can add this to the instructions in the worksheet.
Can't figure out how to do this with firefox. Got it to work with Chrome though. If someone figures out firefox, please let me know.
If you have DNA from Ancestry, then you'll want to watch this video: czcams.com/video/_rE6EXQPlzQ/video.html
Be sure to become an FHF Xtra channel member to access additional training with spreadsheets including:
- Creating a Leeds Method Charts using GoogleSheets and MyHeritage czcams.com/video/EeeDva2wAWY/video.html
- Genealogy Spreadsheets Tips and Tricks czcams.com/video/_NGdkLTwZ_I/video.html
UPDATE!!!! The Google Spreadsheet has now been updated to handle the latest version of the AncestyDNA matches format released in June 2024. If your AncestryDNA matches page now shows "square dots" with a single character in them, and you can only see 20 or 50 matches at a time, then use the updated version (see link above), and use the 2024 Raw Data tab. On the Instructions page of the spreadsheet is also a link to a CZcams help video I made about the update - including - how to now capture the Custom Dot Groups!
The UPDATED spreadsheet should work now. Do you still have the link? If not, sign-up again at this website www.familyhistoryfanatics.com/post/download-ancestrydna-matches-hack
The problem was in the two versions of Ancestry's DNA match list. Keep sending in the tweaks!!! We'll make this work awesome.
The Spreadsheet works amazingly. Thanks Greg
Greg, you're a rock star! Thanks so much!
Finally successful downloading my date. One problem is the "clear date box" will not work. Here's the message I see on screen.
Thank you so much! I really appreciate this, it was driving me nuts not being able to get the data into spreadsheet form as I'm trying to find out who my mystery great grandfather was and needed to compare my results between all the different tests :-)
Seriously one of the best tools that I've used since I started doing DNA research. Thank you!!!
UPDATE: I have tested a new version of the Google Spreadsheet which I believe will now work with either version of the Ancestry DNA Match list (the format I see here in my corner of the internet in Canada, and the version some of the rest of you are seeing in other parts of the world). Thanks to those who helped test out the new formulas.
The new version has TWO worksheets - one if you have a VIEW MATCH button at the end of each row, and one worksheet if you do NOT have that button.
I will make a post here as soon as I've updated the Google Spreadsheet. (IT IS NOT UPDATED YET - please be patient - I need to coordinate with Devon.)
Thank you for your patience ... the fix is coming ... I'm keen to share it with you all ... thanks for the very positive responses so far from those that have used it successfully, and those testers who have tried the new version.
HI Greg.....I'm pretty familiar with excel(Nortel days)...how did everyone access it previously?
Thanks greg. I'm updating the link. Just go back to the link I sent and everyone can refresh.
Hi Greg. So grateful for all of the hard work you are so willingly sharing with all of us. I noticed a couple of cell hiccups (at least I think they are) and wanted to know if you'd like to connect offline so I could share them. If you're interested, let me know how to reach you. I'm on Ancestry, 23andMe, FTDNA, WikiTree, Geni, FB, etc... Thanks again!
This is AMAZING thank you SO MUCH for sharing this, it's helped me a LOT
Hi all! I've heard from a number of you today - and there is a problem with using this spreadsheet if your Ancestry DNA Match list doesn't look like mine. Mine has a big VIEW MATCH button at the end of each row. If yours does NOT have that button, but instead the coloured dots at the end of each row, then the formulas won't be able to perform their magic.
I'm working on a fix for this, and will post a comment here as soon as that is ready.
Sorry for this - I didn't realize that they were changing the format of their matches page - and that the change was not consistently applied. My bad.
- Greg
:-)
Hi Greg, thank you for doing this and for clarifying why it isn't working for some of us. I'm really excited at finally being able to download my own data!
Thanks so much!
Greg Clarke, I have used your program in the past and it worked great! Good luck trying to keep up with the never-ending changes and variations. Thank you for developing it for all of us.
Thanks I still have the old view but I'm using ancestry.co.uk as thats where all my ancestors are but Maybe I'll log in vis .ca and see if I get the access
Thank you for all your hard work. I have the dots, so I will wait. 🙂
I just updated the Google Spreadsheet to include a column that will display Which Side a match is on, if you have taken the time to identify that using the "Do you recognize this match?" buttons. The column will either be blank, or have Both, Mother's, or, Father's in it - so - yet another way you can sort your results if you wish.
Thanks Greg!!
The macro to clear data from the worksheet is under "Extensions" in my Google Docs online app, not Under Tools. While I can cut and paste the results, whether as is or just values, the formulas are not populating columns G through P I think because as other person mentioned my list of matches is not laid out in the same way yours is. I can share a snapshot if you would like; basically, I have 3 lines of information for each match, where your view only shows 2 lines.
Please send a screenshot to Greg (email in the spreadsheet). And then send me a copy of the email using the form here. www.familyhistoryfanatics.com/contact
Greg has found the problem and we've updated the spread sheet. Will you try again?
Do you still have the link? If not, sign-up again at this website www.familyhistoryfanatics.com/post/download-ancestrydna-matches-hack
It wouldn't work in Safari on my Mac. So having avoided using Chrome for years (I don't like change) - I bit the bullet and moved to Chrome........I can't get it to do a CMD A select but that's trivial - I'm happy to scroll down.
BUT.....
OH MY GOODNESS - THANK YOU!!!! This has absolutely driven me nuts for years. Hubby and I have tried all sorts - and the number of hours I've spent copy, paste, delete all the gunk. Urrgh!!! I could kiss you! Fab.
Have you sent Greg an email? His email address is in the Google Sheets file. There were some changes that Ancestry made to their match list that he has updated since we released version one of this tool. Greg is constantly trying to improve the tool, and users help him do that. Good luck and let me know how it goes.
So excited that this is coming. Worked on this with my hubby for 3 hours now and can't seem to get it to work. Found this comments list and it seems I am having the same hiccup with a different view. I'm in Canada. Tried Chrome, Edge and Excel and all browsers sort the Ancestry data so the grouping dots are at the end of the rows of matches. Also using Windows 10 if that matters. Will be waiting with excitement to see the 'tweaked' spreadsheet. :-) Thank you very much for your hard work!
Check the link again. There are new updates. Greg made some changes but I wasn't able to update them fast enough because I was ill this weekend.
@@FamilyHistoryFanatics I did receive the new updated spreadsheet but the NO BUTTON option is still not working. I cleared all the data, copied only a small number of Ancestry matches for a test, used Shift, Control V and the raw data drops into Column A but it does not auto populate the righthand portion of the spreadsheet. Any other suggestions with what I can do. Seems like a fantastic tool I would love to get it working.
Hi @@shannaandrews9807 - I've just updated the spreadsheet - my version (in Canada) changed its format this week - if yours did too, see if the latest Worksheet (NEW View Button) does what you want. The other issue I've heard is that not all browsers do the copy and paste the same way. I use Google Chrome on a Mac, and it works better than FireFox. Safari and Opera seem to play nice as well. I don't have a Windows to compare that too, but hopefully something will work out for you.
It stops filling in the data in columns T to the end showing 1. Add more family, U has Copy the last row that has formlas in columns T through AE, and so on. The data is in Column A but won't process
When I do the control a it does not select all the text. The most important data I want in my Excel file is the centigrams.. did ancestry change the display so you can't copy the text on the screen?
I've tried over and over in Google Sheets and Excel and all I get is a single column of match information. The rest of the columns don't populate.
Same here, I'd love to have this working for me as I've been so frustrated not being able to download my matches from Ancestry.
Same for me. I put my cursor in the "yellow box" and press SHIFT+CONTROL+V a little box with word "paste" appears on my screen and then I click it. Copied Text Only goes into far left column. Nothing to the right.
Also, I did try to download your google spreadsheet in Excel. Now on Mac I go to downloads and then open it with Excel. The only problem is the "formula's do not transfer over. Here is what I get =IF(ISERR(FIND("shared DNA",A3:A50500)),"",ROW(A3:A50500)).
I also open the Excel File and the top 3 rows left of 1st column do not line up correctly. The information actually appears below the line below the "Yellow Line" (oops not below the yellow line - to right but down a few rows.
Greg, I'm sure that you may have to do a few "fine tuning" to the instructions. Clearly I/we must NOT be doing something correctly based on your verbal instructions. Await to hear back.
I get the same - what am I doing wrong, just noticed you have your dots on 2nd row, mine are at the end of first row, guess this is making a difference
As far as I have been able to figure, the cause of that could be because the formulas used are expecting the copy & pasted info to be a bit different than how Ancestry is displaying it for those of us in the States compared to how it does in Canada...or maybe the differences are because of which browser used to access ancestry...just something is definitely different.
If you look at the initial info on the worksheet before we clear the creator's info out, you'll see his info includes a shared % and some fields include this symbol | ...I have no experience with how to adjust the formulas to match what we are getting from Ancestry, but I have at least figured out that is where the hiccup comes into it.
Same for me exactly - not working properly for me on a Mac.
It's broken. I followed the directions exactly and it doesn't copy to correct fields and copies some of the names twice. I even tried all 4 of the different formats and none of them copy correctly. I have the "do you recognize them?" type match list.
This is super frustrating, I am following the directions and it is only bringing over 143 of my matches, not all of them. Help?
My List on Ancestry does not look the same as yours and does not work...can you fix the formula to work with the older style list please
Good question. Let me send that to Greg.
That was the problem but yay!!! We should have it fixed. Do you still have the link? If not, sign-up again at this website www.familyhistoryfanatics.com/post/download-ancestrydna-matches-hack
Fantastic! I've been manually doing this using a few filters, but this is great, however, i have notes on a lot of my matches and this seems to mess up the sheet a little, happy to explain further
Actually I've cracked it, if you want notes to display in the notes column
=if(isblank(indirect("A" & ($E3+1))),indirect("A" & ($E3+2)),"")
Awesome. Thanks
Brilliant tool. I use formulas a lot but those are amazing. Well done.
Thank you! Cheers!
Excellent! Needed this for a while will save so much time! Many Thanks
You're welcome!
Have had a terrible time. Nothing works. None of the yellow fields I dumped the copied data into worked.
First off Greg Clarke, THANK YOU!!!! Now that I have the spreadsheet I'm excited, but that excitement dissipated when I was scrolling down and copying all of my matches. As I got closer to the 25 cM pages it began to go slower and slower I was in about 2 hours at this point. Next thing, 30 minutes later my page started crashing and then crashed! I lost all of my copy/highlights. Is there a way to copy a few hundred at a time paste it on the spreadsheet and go back for more and keep adding a few at a time or must they be all copied at the same time? Second question, what are y'all doing with the info once you have it in the spreadsheet? How are you grouping them to know you are related and how? In ancestry, then going back and finding those matches? I'm not sure how to separate, group, or color-code them on the sheet. I don't even know which are my mom's side and my father's side without constantly going back to my ancestry. That would be very time-consuming. Please let me know if you have a video on this. Thank you again this is awesome!
Great update to the Spreadsheet. I love putting all my info into Spreadsheets but am new to Google Sheets, and don't know many functions other than basic Excel ones. Both of Greg's versions are working fine for me, but quick question:
Can you sort the Column "People in Tree" numerically? I can't, because it has mixed numbers and words, but there might be a trick out there.
Other observations:
On the original version, I could only display approx. 550 shared matches. I thought therefore to break up my searches, by Surname of Interest, or Place of Interest, using the Duplicate function on the lower Tabs. It limits me to 5,000,000 cells (I think), so i can only create 3 tabs. I have therefore created MANY new Files, with 3 tabs each, to sort my data...
Loving the work you're doing in this Group!
I'm not able to populate the "NOTES" column but I can see that those notes are being copied. Trying with Safari and Firefox. I don't use Chrome. Trying with each version of your template. (My Ancestry has the 'Do you Recognize" feature.) Neither puts anything into the 'Notes' column which is the most vital info I want in the spreadsheet.
I'm 73-years young and new to creating spreadsheets so all gentle suggestions are welcome. Thx.
Reach out to Greg (his email is on the spreadsheet). He'll be able to guide you.
The spredsheet update doesn't work for me. :( My version has "do you recognize them" at the end of each match.
As explained in this video, send Greg an email. Ancestry is constantly updating and he goes in and adjusts the spreadsheet accordingly. Or, there might be something you're not doing. Anyway... the email is in the spreadsheet and he'll be happy to help.
Hello.
Used this before, but I am stuck,
I pasted my data into your google sheets copy. Everything is in the first column. How do I get it to populate the other columns?? I am hoping to extract names only.
Please help.
There is an email in the sheets for Greg. Send him an email and he can help you out.
CAn someone post the example spreadsheet for me please. I'm being diverted to pages with numerous samples and I can't work out which one it is. Thanks
The link to the spreadsheet is available through the description. There is a consent to send form which has a follow-up email that double confirm that you want the link to the spreadsheet.
After you confirm your email, then you'll receive a link to Google Sheets. Save the Google Sheets file to your Google Drive account by following the instructions in the email or on the spreadsheet.
Once you do all of those steps, you can then follow the instructions in the spreadsheet on where to get the information to copy, where to paste the information in the primary sheet for the formulas to work, and then you can look at the spreadsheet that has the list you're seeking.
I am not sure why the yellow isn’t highlighting, I saved as, etc.
Use the email in the spreadsheet to contact Greg. He is the technical wizard behind the spreadsheet and he will know how to help.
Tried it, it doesn't work. I also do not see any benefit of putting it into a spreadsheet. It's a lot of fiddly work for little benefit. Unfortunately, too many youtubers are putting out "tips and tricks" videos, "hints and clues," and other how-tos that eat up a lot time and do nothing to advance actual research.
If it didn't work, there is an email to reach out to the spreadsheet developer to troubleshoot why it's not working. Ancestry changes their layout frequently and sometimes it's not working because Greg needs to make a change.
Why do you download the match list - you don't need to. HOWEVER, since Ancestry doesn't offer some tools for understanding matches, many folks want to download their match list on Ancestry to keep better notes, filter the results, and compare what they see on Ancestry to Myheritage, 23andMe, Family Tree DNA, GEDmatch, and so forth.
This tool and tutorial came out of a Channel Membership training session when attendees wanted a way to download their match list but Ancestry doesn't allow that. Greg graciously programmed a tool that could achieve that goal and then shared it with us for our members and the general public.
Yes, many genealogists on CZcams share lots of tips and tricks. There are some I dislike and some I find amazing. It's up to each genealogist to take the suggestions and do with them what they will. Good luck
Tried with no results. Doesn't populate the sheet. My display is not the same. Tried in Chrome, Firefox and offline. Google sheet added Raw Data in row above the other headers. A5 becomes A6 but pasting in never works.
Send an email to Greg. The email is in the spreadsheet . That way if there's a problem, he can make changes. Or we can help figure out the steps we need to tell folks.
@@FamilyHistoryFanatics I don't see an email for Greg in the spreadsheet. Anybody find it? I so hope he can help those of us who all seem to have the same problem.
@@pamelahickmann5781 his email is on the instructions sheet, towards the top, near his name (at least it was as of last I accessed the sheet yesterday)
yes me also...has old data still in it...and wont let me paste....possibly settings in excel for spreadsheet
Greg has found the problem and we've updated the spreadsheet. Will you try again?
Do you still have the link? If not, sign-up again at this website www.familyhistoryfanatics.com/post/download-ancestrydna-matches-hack
Ancestry says "failed to copy" after selecting all, then copy. Did ancestry break this work-around?
Perhaps. There's an email in the spreadsheet to interact with the person who made it. Whenever there's a 'break', he works to fix things.
Thank you Greg, this is great. For reasons I'm sure that you understand, what I'd really like to be able to do is download all of the "Shared Matches" data for each of my own matches, and get all of that information into a spreadsheet. Any thoughts?
If you can access the account their kit is in, you can do the same thing. Otherwise, Ancestry doesn't make that possible.
A gin & tonic are looking pretty good about now. Firstly thank you
for all the work you have put in for us all. I have managed to finally
paste from DNA list, though all the data goes in column A with the Demo
info still in all the other columns. I tried removing the Demo info. No
difference. Noticed that my Relationships & DNA % & Cm don't
highlight to copy. My DNA has View Match & coloured dots. What am I
Not doing correctly?
Apparently it only works in Chrome.
Cheers Rick. Great spreadsheet idea. Will look out for something similar in Windows.
First, the spreadsheet only works in Google Sheets.
Second, you have to use the correct tab for the layout that you see on Ancestry. Ancestry is not showing the same DNA match list view to everyone. There is an update in the instructions on the first tab of the Spreadsheet to help you know which tab to look at. If you have any further questions, send Greg and email (also on the first tab of the spreadsheet) and he'll help you out. Perhaps there is a glitch in the coding or perhaps he needs to improve the instructions. Good luck and let me know if that solves the problem.
I can do everything except ‘Paste’. I’m using an iPad 11.5, current iPadOS, and have tried with and without using the Keyboard that Apple made for the iPad.
Did you contact Greg for suggestions? His email is in the table maker. I believe uses Apple, whereas I've always used PC. I know he'll help you out.
Thanks for the information! I’ll give it a try!
I hope it works. If it didn't, then try again. We just made some changes.
Hi. I'm a new member today and have enjoyed watching a few of your really educational videos. Thanks. Regarding Greg's excellent spreadsheet for Ancestry DNA matches, Devon mentioned at the end of the video something about updating the spreadsheet with new matches from Ancestry but I couldn't understand how (a) to harvest the new matches since the last time you looked at Ancestry; and (b) how to add in the new matches to the spreadsheet without affecting the data already in there. Is there a set of instructions somewhere for this? Thanks.
The spreadsheet just does a "dumb" copy and paste and interprets the result into a table. It doesn't have the "smarts" built into it to know what is new and what is old.
BUT ... if you use a filter to only display the new matches on your Ancestry DNA Matches page, then you could copy & paste those into the spreadsheet, and then add the resulting table of NEW rows to the bottom of your Master Spreadsheet, which I'm assume you're keeping in a safe place somewhere else.
@@uptergroveGreg Thank you.
Thanks Greg for your input
Hello, there! I have received the shared Google Sheet, but it seems as though it has been modified by someone who has not copied the sheet, therefore has directly modified it. Might it be possible for you to share a clean Google Sheet file? A suggestion would be if you replace the word EDIT with the word COPY in the link you share: it forces the receiver to make a copy of the file; in that way, there is no inadvertent modification. I have been unable to get the list populated. I'm not sure if it is directly related to the inadvertent edit by others or because my Ancestry visual is not the same as it is in the video. I look forward to being able to use the Google Sheet! Thank you for creating this!
Hi Connie. The spreadsheet comes with some sample data so that you have a sense of what to expect when you copy your own on top of it. I didn't add many rows, thinking that for most people, it would automatically overwrite my sample. You can always clear the data away from column A and start fresh. For some, though, a totally blank slate is a little unnerving, hence my choice to leave something there as a sample. Excellent point though - about the difference between /edit and /copy for the Google Link !
@@uptergroveGreg Thank you so much for your reply! I finally figured out how to do the spreadsheet and I cannot thank you enough for the work you have done and provide gratuitously. God bless you!! (Sorry for my late reply...).
Yay Connie! So glad you figured it out. Greg is such a blessing to our genealogy community.
@@FamilyHistoryFanatics he certainly is...and so are you. Bless you!
I love this spreadsheet! Does anyone know of a way to scrape data from Thrulines? I have two brick wall Lees that I suspect are siblings from a particular NC Quaker Lee family and I want to compare the Thrulines for these two, their spouses, and the suspected grandparents. I know Thrulines is based on individual trees, but I think I may find some good info. I've heard from others that they just copy and paste into a spreadsheet on their PCs, but that doesn't work with a Mac. I'd type them in, but that would involve some 250 names. Ideas?
There aren't ways to scrap data from ThruLines. Typically, we would use the spreadsheet and then examine ThruLines and make notes on the spreadsheet.
This is cool, but when pasting matches with Ctrl+V and Shift+Ctrl+V,: I noticed:
-the former had embedded links (names, trees, etc), the latter did not. Why is that?
-neither has Groups (Col P). Why not?
-the former does not have Notes, at least not in Col Q ... I noticed some notes in Col G
There are other issues, but probably too much to note in this comment.
The embedded links vs no links is the key difference between a straight PASTE (with links) to PASTE VALUES ONLY (just the raw text, nothing fancy, no highlighting, bold, or fancy links).
The formulas generally work better with raw text to parse - that's why I recommend that "flavour" of pasting for best results. (However, there is something cool about having a table that has active live links to your DNA matches .... that's cool too ... )
Maybe you do two versions and merge them .... (I'll leave that as an exercise to the intrepid spreadsheet fans out there to play with ....)
Thanks Greg for the response!
Hi again! Just did another update to the latest worksheet : NEW View Match btn - to fix a problem with the Notes column. It may not be perfect still, but it seems to catch more of the Notes and place them correctly (instead of placing them in the first column of the next line).
Thanks for sharing!
Hi Greg, thanks for the update, was almost there with it myself, frustrating that it was broken!
Couple of issues I'm having, as I have my parents DNA I have Mother's side & Father's side added in to the mix which throws out some of the data.
Also, I have some "tree unavailable" as well, so that breaks the tree column
I can share my sheet with you if you are interested to work it out, I'm banging my head against the wall!
@@xanthian9754 Sure - you've got my email address from the first page of the spreadsheet - if you share your sheet with me, I can take a look
@@uptergroveGreg Invite sent 👍
Does this spreadsheet work on a ChromeBook? Data not coming across and I'm beginning to wonder if this is the problem. Thanks for any response
If you use Google Drive, it should work. The formulas are built for anyone who can access Google Sheets. Since Chromebooks connect to Google Drive, I'm not sure what the problem is. What browser are you using?
@@FamilyHistoryFanatics I use Chrome
I can not get it to paste without format. (I'm familiar on copy and pasting) I'm using firefox. Paste with formatting works but as we know it makes it "messy". Thanks in advance for any helps on what to do.
UPDATED spreadsheet should work now. Do you still have the link? If not, sign-up again.
Hi there utubelaw - do you have access to Google Chrome ? It seems to "play nicer" than FireFox I've found. Not sure why all browsers aren't created equally - especially with such key functions as copy and paste ...
@@uptergroveGreg I do not use Chrome anymore due to it's plug-in vulnerabilities. using up to much cpu resources. Thank for your reaching out.
@@utubeblaw I've also found that Safari and Opera work fine, on my Mac.
Will this work with Libre Office and Open Office?
As stated in the video, no it won't. Each program handles the coding differently which would make more work for the volunteer to manage. Since he designed this at no compensation to himself, we chose the most sharable platform - Google Sheets.
This very nice but unfortunately, names are first then last so can't sort by last name unless there is a trick I don't know.
That is frustrating. There are some formulas to separate first and last names, but since everyone doesn't put names in a uniform pattern, this isn't as helpful either.
I suppose this would also work with Open Office? I use Ubuntu on my laptop
Nope. The formulas don't work to parse out the data from Ancestry's copy & paste method. Sorry, it's only designed for Google Spreadsheets.
This is fabulous! Thank you! Thank you!
Glad you enjoyed it!
omg, this is AWESOME!! Thank you!
You are so welcome!
What do you do with it once you have it? I'm not a spreadsheet user and I'm not clear what the purpose is???
Great question. Several things. You can use it to keep track of your DNA matches across platforms, sort the information to do different analysis, and more.
Great! Can’t wait to try it
Hope you like it!
Thank you, thank you, thank you!
You're welcome
Perfect contact although not working for me as I'm on old view . Just joined based on the great content thats relevant to me
UPDATED spreadsheet should work now. Do you still have the link? If not, sign-up again.
@@FamilyHistoryFanatics Perfect Works now
thank you!!
Glad to help.
This doesn’t work
That's too vague. The table does work only in Google Sheets. If there is an update on Ancestry, we email Greg, the developer, listed in the spreadsheet. He makes changes and we all update our sheet again. You have to save a copy to YOUR Google Drive account. If you follow all of those steps, it works. Which step tripped you up?
Good day early birds
So true
@@FamilyHistoryFanatics the spreadsheet will not let me paste into it....I'm in Canada.....I have used these type of spreadsheet before for chromosome mapping and pretty easy but this one seems to perhaps have different settings...maybe permissions? not sure but it needs some tweeking!
@@FamilyHistoryFanatics i don't know if Gregs formulas get transferred to new copied sheet!? @Greg Clarke
You waste so much time on how a to c/p.
If you're a pro at Copy and Paste, that's awesome. Recognize, we're serving a broad audience that is typically 55+ who ask that we walk them through every step (including copy and paste.) Isn't it great that you can skip ahead in the video to get to the portions you need? Cheers.