Does anyone know how to get the raw data in the text file form into a spread sheet so that it can be sorted sequentially in order to find a specific SNP? Can it be brought into Excel? The data is my own data. Appreciate instructions as to how to do it. Thanks, Ron ________________________________ From: "[email protected]" <[email protected]> To: [email protected] Sent: Wednesday, April 4, 2012 2:16:35 PM Subject: AUTOSOMAL-DNA Digest, Vol 2, Issue 54 Today's Topics:   1. extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen)   2. Re: extracting Y-DNA SNPs from 23andMe ([email protected])   3. Re: extracting Y-DNA SNPs from 23andMe (Ann Turner)   4. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen)   5. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen)   6. Re: extracting Y-DNA SNPs from 23andMe (Larry Vick)   7. Re: extracting Y-DNA SNPs from 23andMe (Ann Turner)   8. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen)   9. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) ---------------------------------------------------------------------- Message: 1 Date: Wed, 4 Apr 2012 08:58:14 -0400 From: "Diana Gale Matthiesen" <[email protected]> Subject: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain;    charset="us-ascii" I've been tested at 23andMe, and I must admit that, so far, I've only made use of the medical information.  I would like to learn how to extract data that would be relevant to the SNPs used to determine someone's Y-DNA haplogroup.  (Obviously not out of my own results, but those of particular males.)  Specifically, I'm trying to supplement results that are available at FTDNA, such as at the Haplogroup I1 project: http://www.familytreedna.com/public/yDNA_I1/default.aspx?section=ysnp How would I go about finding SNP results in Hg I1 males at 23andMe?  Diana ------------------------------ Message: 2 Date: Wed, 4 Apr 2012 13:09:53 +0000 (UTC) From: [email protected] Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: [email protected] Message-ID:     <[email protected]a.mail.comcast.net>     Content-Type: text/plain; charset=utf-8 You might wish to look at Adriano Squecco's project where he has them all in nicely annotated Excel spreadsheets. http://www.snpedia.com/index.php/Squecco_List ----- Original Message ----- From: "Diana Gale Matthiesen" <[email protected]> To: [email protected] Sent: Wednesday, April 4, 2012 7:58:14 AM Subject: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe I've been tested at 23andMe, and I must admit that, so far, I've only made use of the medical information. ?I would like to learn how to extract data that would be relevant to the SNPs used to determine someone's Y-DNA haplogroup. ?(Obviously not out of my own results, but those of particular males.) ?Specifically, I'm trying to supplement results that are available at FTDNA, such as at the Haplogroup I1 project: http://www.familytreedna.com/public/yDNA_I1/default.aspx?section=ysnp How would I go about finding SNP results in Hg I1 males at 23andMe? ? Diana ______________________________ For answers to Frequently Asked Questions about mailing lists, please see: http://dgmweb.net/MailingListFAQs.html ------------------------------- To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message ------------------------------ Message: 3 Date: Wed, 4 Apr 2012 06:21:45 -0700 From: Ann Turner <[email protected]> Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: [email protected] Message-ID:     <[email protected]om> Content-Type: text/plain; charset=ISO-8859-1 You're speaking of cases where you don't have access to the raw data, but you know the haplogroup? You can use the Haplogroup Tree Mutation Mapper (under Ancestry Labs) and enter any subclade into the query box. The subclade label may very well be different than the one assigned by FTDNA, depending on nomenclature and how deeply the FTDNA customer has been tested. Take a note of the most derived SNP (the one at the top of the results list) and look it up in http://isogg.org/tree under the major haplogroup label. Ann Turner On Wed, Apr 4, 2012 at 5:58 AM, Diana Gale Matthiesen <[email protected]>wrote: > I've been tested at 23andMe, and I must admit that, so far, I've only > made use of the medical information.  I would like to learn how to > extract data that would be relevant to the SNPs used to determine > someone's Y-DNA haplogroup.  (Obviously not out of my own results, but > those of particular males.)  Specifically, I'm trying to supplement > results that are available at FTDNA, such as at the Haplogroup I1 > project: > http://www.familytreedna.com/public/yDNA_I1/default.aspx?section=ysnp > > How would I go about finding SNP results in Hg I1 males at 23andMe? > > Diana > > > > ______________________________ > For answers to Frequently Asked Questions about mailing lists, please see: > http://dgmweb.net/MailingListFAQs.html > > > ------------------------------- > To unsubscribe from the list, please send an email to > [email protected] with the word 'unsubscribe' without > the quotes in the subject and the body of the message > ------------------------------ Message: 4 Date: Wed, 4 Apr 2012 10:38:42 -0400 From: "Diana Gale Matthiesen" <[email protected]> Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain;    charset="UTF-8" Thanks, Tim.  Wow, my hat's off to the person compiling this.  What a lot of work. Diana > From: [email protected] > Sent: Wednesday, April 04, 2012 9:10 AM > > You might wish to look at Adriano Squecco's project > where he has them all in nicely annotated Excel > spreadsheets. > > http://www.snpedia.com/index.php/Squecco_List ------------------------------ Message: 5 Date: Wed, 4 Apr 2012 11:00:12 -0400 From: "Diana Gale Matthiesen" <[email protected]> Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain;    charset="us-ascii" Yes, I'm looking for SNPs in a certain haplogroup, I1, and I'm familiar with the SNPs.  When I ask for a "List of Mutations" for I1, it gives them to me, but when I click on one, it only gives me my result (nc of course).  What I'm trying to find out, ideally, is the haplogroup-relevant SNP status of all the I1 men in the database.  Is there a way to do that?  What does it mean to have access to the raw data?  I think that must be what I need because some people are talking about some "obscure" I1 SNPs being readable/available there, ones that are not on the List. I really mean it when I say all I've ever done at 23andMe is look at my medical data.  I suppose there's a tutorial I should walk through, as in, "If all else fails, read the instructions." Diana > From: Ann Turner > Sent: Wednesday, April 04, 2012 9:22 AM > > You're speaking of cases where you don't have access > to the raw data, but you know the haplogroup? You can > use the Haplogroup Tree Mutation Mapper (under Ancestry > Labs) and enter any subclade into the query box. The > subclade label may very well be different than the one > assigned by FTDNA, depending on nomenclature and how > deeply the FTDNA customer has been tested. Take a note > of the most derived SNP (the one at the top of the > results list) and look it up in http://isogg.org/tree > under the major haplogroup label. ------------------------------ Message: 6 Date: Wed, 4 Apr 2012 08:35:19 -0700 (PDT) From: Larry Vick <[email protected]> Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: "[email protected]" <[email protected]> Message-ID:     <[email protected]> Content-Type: text/plain; charset=iso-8859-1 Diana, If you are asking how to download the raw data go to "Account" at the top of any screen on 23andMe, then select "Browse Raw Data." ?Next, click on the "Download Raw Data" link at the top left (it has a green down arrow icon). ?Then select "Y Chromosome" for the data set. ?You will have to enter the password and answer the security question. Regards, Larry ________________________________ From: Diana Gale Matthiesen <[email protected]> To: [email protected] Sent: Wednesday, April 4, 2012 11:00 AM Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe Yes, I'm looking for SNPs in a certain haplogroup, I1, and I'm familiar with the SNPs.? When I ask for a "List of Mutations" for I1, it gives them to me, but when I click on one, it only gives me my result (nc of course).? What I'm trying to find out, ideally, is the haplogroup-relevant SNP status of all the I1 men in the database.? Is there a way to do that?? What does it mean to have access to the raw data?? I think that must be what I need because some people are talking about some "obscure" I1 SNPs being readable/available there, ones that are not on the List. I really mean it when I say all I've ever done at 23andMe is look at my medical data.? I suppose there's a tutorial I should walk through, as in, "If all else fails, read the instructions." Diana ------------------------------ Message: 7 Date: Wed, 4 Apr 2012 09:06:53 -0700 From: Ann Turner <[email protected]> Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: [email protected] Message-ID:     <[email protected]om> Content-Type: text/plain; charset=ISO-8859-1 No, you wouldn't be able to look at the SNP status of all I1 men in the 23andMe database. If you don't have any access to a male's account, you can add the demo "Mendel" family  at Account | Settings | Example Profiles. Then you can Browse Raw Data for the SNP and see Greg Mendel's results.  He's currently classified as I1*. If you're talking about an "obscure" SNP that's not currently used by 23andMe or ISOGG to define a subclade, you can start a Community Thread on the topic and ask what people are finding. In fact, I have a vague recollection about just such a thread, so Search the website for the SNP and see if it's under discussion. Ann On Wed, Apr 4, 2012 at 8:00 AM, Diana Gale Matthiesen <[email protected]>wrote: > Yes, I'm looking for SNPs in a certain haplogroup, I1, and I'm > familiar with the SNPs.  When I ask for a "List of Mutations" for I1, > it gives them to me, but when I click on one, it only gives me my > result (nc of course).  What I'm trying to find out, ideally, is the > haplogroup-relevant SNP status of all the I1 men in the database.  Is > there a way to do that?  What does it mean to have access to the raw > data?  I think that must be what I need because some people are > talking about some "obscure" I1 SNPs being readable/available there, > ones that are not on the List. > > I really mean it when I say all I've ever done at 23andMe is look at > my medical data.  I suppose there's a tutorial I should walk through, > as in, "If all else fails, read the instructions." > > Diana > ------------------------------ Message: 8 Date: Wed, 4 Apr 2012 13:51:43 -0400 From: "Diana Gale Matthiesen" <[email protected]> Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain;    charset="iso-8859-1" Thanks, Larry.  I'm not asking how to download my own data, but I see Ann has answered my question... Diana > From: Larry Vick > Sent: Wednesday, April 04, 2012 11:35 AM > > Diana, > > If you are asking how to download the raw data go to "Account" at > the top of any screen on 23andMe, then select "Browse Raw > Data." ?Next, click on the "Download Raw Data" link at the top left > (it has a green down arrow icon). ?Then select "Y Chromosome" for > the data set. ?You will have to enter the password and answer the > security question. > > Regards, > > Larry ------------------------------ Message: 9 Date: Wed, 4 Apr 2012 14:16:18 -0400 From: "Diana Gale Matthiesen" <[email protected]> Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain;    charset="us-ascii" I see, thank you, Ann, even though you're telling me it's not possible to do what I'd hoped. ;-)  I guess it doesn't really surprise me too much. What I am looking for is Hg I* and I1* men who had possibly tested at 23andMe, but not FTDNA, where I could read results for some of the phyloequivalent SNPs that people typically don't test a la carte and that aren't usually included in a deep clade test at FTDNA.  IOW, at FTDNA, if someone tests M253+ or M170+/M253-, there would usually be no reason to test anything else that isn't known to be downstream. To be more specific, I'd like to see if everyone who is M170+/M253- or M253+ is also L840+ (plus other allegedly M253 phyloequivalent SNPs). They are said to be equivalent, and I don't have any reason to doubt the person saying it, but if I'm going to site that as a proven fact on my web site, I would like to see the data for myself.  If that kind of hunt is not possible, then I need to try some other avenue. Am I correct in understanding that, essentially, the only way to get that information is if the test subject gives it to you?  Which means you have to somehow know whom to ask. Diana > -----Original Message----- > From: [email protected] [mailto:autosomal-dna- > [email protected]] On Behalf Of Ann Turner > Sent: Wednesday, April 04, 2012 12:07 PM > To: [email protected] > Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe > > No, you wouldn't be able to look at the SNP status of all I1 men in > the > 23andMe database. > > If you don't have any access to a male's account, you can add the > demo > "Mendel" family  at Account | Settings | Example Profiles. Then you > can > Browse Raw Data for the SNP and see Greg Mendel's results.  He's > currently > classified as I1*. > > If you're talking about an "obscure" SNP that's not currently used > by > 23andMe or ISOGG to define a subclade, you can start a Community > Thread on > the topic and ask what people are finding. In fact, I have a vague > recollection about just such a thread, so Search the website for the > SNP > and see if it's under discussion. > > Ann ------------------------------ End of AUTOSOMAL-DNA Digest, Vol 2, Issue 54 ********************************************

Open Excel first, then use the File | Open dialog and locate the file. Double click on the file name to open. It is a tab-delimited file, which Excel knows how to handle. You must have Excel 2007 or higher because of the large file size. Ann Turner On Wed, Apr 4, 2012 at 2:57 PM, RON SINCLAIR <[email protected]>wrote: > Does anyone know how to get the raw data in the text file form into a > spread sheet so that it can be sorted sequentially in order to find a > specific SNP? Can it be brought into Excel? The data is my own data. > Appreciate instructions as to how to do it. > Thanks, > Ron >