Table Tools

Table Tools is a Firefox addin discovered by project member Bud Rogers. It can be found at https://addons.mozilla.org/en-US/firefox/addon/2637

To install table tools you need to navigate to the website in Firefox.

Click on the Add To Firefox button.

Click on the Install Now button.

Click on the Restart Firefox button.

You are now ready to start using Table Tools.

Control-Alt-Left Click sorts any column. Move the mouse to the column that you want to sort. Use Control-Alt-Left Click to sort.

This is the H1 results table sorted by HVR1.

It can be sorted by country of origin.

When sorted by kit the program ignores leading Ns and Es in the kit numbers.

Control-Shift-Left Click opens the Filtering boxes at the top of each column. Filtering can also be turned on by right clicking on any column.

Each column has a drop down menu.

Selecting a item produces a filtered table.

Multiple columns can be filtered.

Holding down the Control button while selecting from the menu produces a table that excludes the selection. Excluded selections are shown with a yellow background in the selection menu.

The search feature may be the most useful part of Table Tools. It is able to over come many of the problems caused by badly structured and nested tables.

Right Click → Other Table Operations → Show/Hide Search Filters opens the search boxes.

Even though the results tables on the Family Tree DNA pages have grouping by country, they can still be searched.

The resulting tables will not have grouping.

This shows a search for 16311C.

This is the result of a search for 477C.

A term can be excluded from the results using :INV:. This example shows the HVR2 results excluding those with 477C. The search is entered as ”:INV:477C.”

When working with tables inside the Family Tree DNA GAP and myFTDNA sites it is often easiest to copy tables to a spread sheet program. You can then use the functionality found there. Table Tools has three ways to copy results: Copy as Tab-Delimited Text, Copy as Justified Tab-Delimited, and Copy as HTML. Each copy type also has the ability to copy only your filtered results.

This is done with Control-z-Left Click (for filtered tables use Control-shift-z-Left Click) or by Right Clicking Other Table Operations → Copy as Tab-Delimited Text.

These are the pasted results of copying as tab-delimited text.

Low Resolution Matches (HVR1)
Haplogroup	Country	Comment	Count
H	Algeria (39)	-	3
H	Algeria (39)	Sephardic	2
H	Armenia (47)	-	5
H	Australia (32)	-	4
H	Austria (352)	-	32
H	Austria (352)	Austria-Hungary	1
H	Austria (352)	Vienna	1
H	Azerbaijan (67)	-	1
H	Azerbaijan (67)	Mizrachi	6
H	Belarus (194)	-	19
H	Belarus (194)	Ashkenazi	4
H	Belgium (168)	-	15
H	Bosnia and Herzegovina (17)	-	2
....

This is done with Control-e-Left Click (for filtered tables use Control-Shift-e-Left Click) or by Right Clicking Other Table Operations → Copy as Justified Tab-Delimited.

These are the pasted results.

Low Resolution Matches (HVR1)      	                                          	                      	     
Haplogroup                         	Country                                   	Comment               	Count
H                                  	Algeria (39)                              	-                     	3    
H                                  	Algeria (39)                              	Sephardic             	2    
H                                  	Armenia (47)                              	-                     	5    
H                                  	Australia (32)                            	-                     	4    
H                                  	Austria (352)                             	-                     	32   
H                                  	Austria (352)                             	Austria-Hungary       	1    
H                                  	Austria (352)                             	Vienna                	1    
H                                  	Azerbaijan (67)                           	-                     	1    
H                                  	Azerbaijan (67)                           	Mizrachi              	6    
H                                  	Belarus (194)                             	-                     	19   
H                                  	Belarus (194)                             	Ashkenazi             	4    
H                                  	Belgium (168)                             	-                     	15   
H                                  	Bosnia and Herzegovina (17)               	-                     	2    
....

This is done with Control-q-Left Click (for filtered lists use Control-Shift-q-Left Click) or by right clicking Other Table Operations → Copy as HTML.

These are the pasted results.

<table id="labresults" align="left" border="0" cellpadding="2" cellspacing="0" width="100%">
<tbody><tr>
<th colspan="4" align="left" valign="top">Low Resolution Matches (HVR1)</th>
</tr>
<tr>
<th class="orange" align="left" valign="top" width="25%">Haplogroup</th>
<th class="blue" align="left" valign="top" width="25%">Country</th>
<th class="orange" align="left" valign="top" width="25%">Comment</th>
<th class="blue" align="left" valign="top" width="25%">Count</th>
</tr>
			
					<tr>
						<td style="padding-left: 10px;"><p class="margem">H</p></td>
						<td style="padding-left: 10px;"><p class="margem">Algeria (39)</p></td>
						<td style="padding-left: 10px;"><p class="margem">-</p></td>
						<td style="padding-left: 10px;"><p class="margem">3</p></td>
					</tr>
			
					<tr>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">H</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">Algeria (39)</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">Sephardic</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">2</p></td>
					</tr>
			
					<tr>
						<td style="padding-left: 10px;"><p class="margem">H</p></td>
						<td style="padding-left: 10px;"><p class="margem">Armenia (47)</p></td>
						<td style="padding-left: 10px;"><p class="margem">-</p></td>
						<td style="padding-left: 10px;"><p class="margem">5</p></td>
					</tr>
			
					<tr>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">H</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">Australia (32)</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">-</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">4</p></td>
					</tr>
			
					<tr>
						<td style="padding-left: 10px;"><p class="margem">H</p></td>
						<td style="padding-left: 10px;"><p class="margem">Austria (352)</p></td>
						<td style="padding-left: 10px;"><p class="margem">-</p></td>
						<td style="padding-left: 10px;"><p class="margem">32</p></td>
					</tr>
			
					<tr>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">H</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">Austria (352)</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">Austria-Hungary</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">1</p></td>
					</tr>
			
					<tr>
						<td style="padding-left: 10px;"><p class="margem">H</p></td>
						<td style="padding-left: 10px;"><p class="margem">Austria (352)</p></td>
						<td style="padding-left: 10px;"><p class="margem">Vienna</p></td>
						<td style="padding-left: 10px;"><p class="margem">1</p></td>
					</tr>
			
					<tr>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">H</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">Azerbaijan (67)</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">-</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">1</p></td>
					</tr>
			
					<tr>
						<td style="padding-left: 10px;"><p class="margem">H</p></td>
						<td style="padding-left: 10px;"><p class="margem">Azerbaijan (67)</p></td>
						<td style="padding-left: 10px;"><p class="margem">Mizrachi</p></td>
						<td style="padding-left: 10px;"><p class="margem">6</p></td>
					</tr>
			
					<tr>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">H</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">Belarus (194)</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">-</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">19</p></td>
					</tr>
			
					<tr>
						<td style="padding-left: 10px;"><p class="margem">H</p></td>
						<td style="padding-left: 10px;"><p class="margem">Belarus (194)</p></td>
						<td style="padding-left: 10px;"><p class="margem">Ashkenazi</p></td>
						<td style="padding-left: 10px;"><p class="margem">4</p></td>
					</tr>
			
					<tr>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">H</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">Belgium (168)</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">-</p></td>
						<td style="padding-left: 10px;" bgcolor="#cccccc"><p class="margem">15</p></td>
					</tr>
			
					<tr>
						<td style="padding-left: 10px;"><p class="margem">H</p></td>
						<td style="padding-left: 10px;"><p class="margem">Bosnia and Herzegovina (17)</p></td>
						<td style="padding-left: 10px;"><p class="margem">-</p></td>
						<td style="padding-left: 10px;"><p class="margem">2</p></td>
					</tr>
....

A big thank you to Mingyi Liu for creating this tool and to Bud Rogers for finding it.