Importing MLST data from an Excel file

This tutorial illustrates how to import MLST allelic profiles and strain information from an Excel file. The same steps are also applicable for import of other character experiments.


A character is basically a name-value pair of which the value can be binary, multi-state or continuous. Because of this very broad definition, a wide variety of data can be analyzed as character types (= an array of characters). This includes morphological and biochemical features, commercial test panels (API®, Biolog®, Vitek®, etc.), antibiotics resistance profiles, fatty acid profiles, microarrays, SNP arrays, repeat numbers in MLVA, allelic profiles in MLST, etc.

Download PDF file: 
Download sample data: 
Neisseria MLST data
MS Excel file, containing MLST allelic profiles for 500 Neisseria meningitidis strains, including serogroup and strain information.