Go Back   Family Tree DNA Forums > Paternal Lineages (Y-DNA) > Paternal Lineage (Y-DNA STR) Basics

Paternal Lineage (Y-DNA STR) Basics This is an area for those who are new to DNA testing for genealogy can ask about Y-DNA STR based tests and their test results. All may view this forum, but you must register and sign in to post.

Thread Tools Display Modes
Old 12th February 2015, 02:15 PM
penguin penguin is offline
FTDNA Customer
Join Date: Nov 2004
Posts: 501
Downloading data from Y projects

Hi. I have tried cutting and pasting the STR data from Y results from various projects into Excel spreadsheet. The problem is that for markers that have two parts, with numbers like "11-14", excel converts to dates, e.g., "November 14"! When there's alot of rows of data, its very time consuming to go thru each one to change it to two columns etc. So the question is is there a way to just download the data as a file that bypasses this problem? (and if someone says the public data can only be downloaded this way by private project administrators, fair warning I may just shout, especially if one in any one implies its a good thing that the public can't download public data)
Reply With Quote
Old 12th February 2015, 03:04 PM
zen4life zen4life is offline
FTDNA Customer
Join Date: Feb 2015
Posts: 20
I do it by going to the DATA tab in excel and clicking the "From Web" option at top. Put in the URL that goes directly to the results and click Go button. Under options there is a Disable Date Recognition option. Check that and import data.

Hope that helps.
Reply With Quote
Old 17th February 2015, 05:46 PM
penguin penguin is offline
FTDNA Customer
Join Date: Nov 2004
Posts: 501
Yes! that help alot. I did not know about that excel feature at all. i'll check to see if my excel is late enough version to do that. Thanks much for that solution.
Reply With Quote


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Downloading filtered matches Teresa Devine Family Finder Advanced Topics 0 10th November 2013 05:02 PM
Latest on FF downloading raw data nmcconnell1 Family Finder Advanced Topics 11 7th April 2013 01:07 PM
downloading GEDCOM MarquisdeCarabas Paternal Lineage (Y-DNA STR) Advanced 2 22nd August 2012 11:09 PM
Chromosome Browser, downloading matches Marbom Family Finder Advanced Topics 3 17th January 2012 04:00 PM
downloading dna results mari@netins.net Group Administrators - Advanced Chat 5 28th August 2007 01:10 PM

All times are GMT -5. The time now is 06:03 PM.

Family Tree DNA - World Headquarters

1445 North Loop West, Suite 820
Houston, Texas 77008, USA

Phone: (713) 868-1438 | Fax: (832) 201-7147
Copyright 2001-2010 Genealogy by Genetics, Ltd.
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.