GenAlEx 6.5: genetic analysis in Excel. Population genetic software for teaching and research--an update

Bioinformatics. 2012 Oct 1;28(19):2537-9. doi: 10.1093/bioinformatics/bts460. Epub 2012 Jul 20.


Summary: GenAlEx: Genetic Analysis in Excel is a cross-platform package for population genetic analyses that runs within Microsoft Excel. GenAlEx offers analysis of diploid codominant, haploid and binary genetic loci and DNA sequences. Both frequency-based (F-statistics, heterozygosity, HWE, population assignment, relatedness) and distance-based (AMOVA, PCoA, Mantel tests, multivariate spatial autocorrelation) analyses are provided. New features include calculation of new estimators of population structure: G'(ST), G''(ST), Jost's D(est) and F'(ST) through AMOVA, Shannon Information analysis, linkage disequilibrium analysis for biallelic data and novel heterogeneity tests for spatial autocorrelation analysis. Export to more than 30 other data formats is provided. Teaching tutorials and expanded step-by-step output options are included. The comprehensive guide has been fully revised.

Availability and implementation: GenAlEx is written in VBA and provided as a Microsoft Excel Add-in (compatible with Excel 2003, 2007, 2010 on PC; Excel 2004, 2011 on Macintosh). GenAlEx, and supporting documentation and tutorials are freely available at:


MeSH terms

  • Computational Biology / methods
  • Gene Frequency
  • Genetic Markers
  • Genetics, Population / education*
  • Genetics, Population / methods*
  • Haplotypes
  • Linkage Disequilibrium
  • Software*
  • User-Computer Interface


  • Genetic Markers