The Download Files page of the FTDNA-GAP allows you to download copies of many of the GAP pages as either CSV or XML files. Both formats can be opened in Excel. CSV format can also be opened by Google Spreadsheets and other opensource spreadsheet programs.
This tutorial assumes you are an FTDNA admin or co-admin and have a login ID and password.
Go to the Family Tree DNA website, and click the SIGN IN link on the top right.
Enter your admin ID and password, then click the Sign In button.
On the top menu, select the PROJECT ADMINISTRATION option.
From the drop-down menu, select Download Files.
Select either the CSV (CSV file) or EXCEL (XML file) next to a report.