Import Step 2: Match Columns

Match Columns of your Excel Sheet to the mLIMS Import sheet. Look carefully at the instructions on Tab 1.  Use Tab 2 as your own template. If your headers don't match exactly to mLIMS, you can still import without re-creating your data.  Watch the Video to see how to match your columns to mLIMS.

 Look Carefully at the Instructions on Your Template!  

The Template Example on Tab 1 will help you determine which fields you need.

Here are some important things to know when importing:

1. Under the genotype header, list your genotypes separated by a comma and a space. (alpha +/+, Alph x/y, Beta p/+).  The genotypes will automatially upload to the genotypes section in mLIMS. Use the Genotypes in Single Column option when importing.

Proper format for each genotype: genename (space) allele.  mLIMS will look for the spaces to differentiate gene and genotype, and will look for the commas to differentiate multiple genes and genotypes.

2. Check your data for inconsistencies in strains and genotypes.  If the same genotype or strain is written in two different ways, mLIMS will import them as separate strains or genotypes!

Example of inconsistent strain:  Alpha/998-ty  OR Alpha-998-ty.  These will import as two separate strains!

3. Use Proper Date Format! 

Correct: 12-15-16   Incorrect :12.15.16

4. Check all mLIMS Fields before creating custom fields.  Duplicate fields will cause mLIMS to not display fields properly.

5. Remove any columns you do not need.  Animal Name, Life Status, Cage name and Cage Status are required fields.

6. You can import animals directly to a project by adding a project column.  Your project must be set up first in mLIMS.

7. Add a protocol column to assign the protocol, if desired. Set up your protocols in mLIMS before importing.

78 Owner name should exactly match the person's name listed in your group.




  • mLIMS Updates