Archiver > GENEALOGY-DNA > 2010-11 > 1290530545

From: Robert Stafford <>
Subject: Re: [DNA] MAC Users and XML Files
Date: Tue, 23 Nov 2010 10:42:25 -0600
References: <><>
In-Reply-To: <>

This seems to be the simplest method that I have tried. Once a template is
prepared, there is no need to add any columns or change headings. Hopefully,
it will work on a MAC.

Download Open Office 3.2.1 for free at:

Copy only the data rows and not the headings from the FTDNA table using
Foxfire. In Calc, select Paste Special, Unformatted Text. A delimiter box
will appear. Add hyphen as another delimiter. If you have embedded hyphens
in the text, repeat below without the hyphen selected. Copy and paste the
text to the first copy. Erase the second copy. Copy and paste to a template
spreadsheet that has the headings and proper formatting.

If you do not have a template, Copy and Paste (normal, not special) the
heading row and one data row from the FTDNA results to a blank spreadsheet.
Select the rows and Format, Default Formatting. Insert the extra columns
needed. Copy the heading row to the first spreadsheet. Copy everything to
your working spreadsheet and format as desired. Save. Erase the data and
save the heading and formatting under a different name to use as a template.

You can tighten up the spread sheet in Excel for Windows by reorienting the
headings for the markers by 90 degrees and adjusting the column width. You
can also format them as distributed horizontally and adjusting the column
width so that DYS and the number separate.

Bob Stafford


This thread: