Keemei: Cloud-based validation of tabular bioinformatics file formats in Google Sheets

Jai Ram Rideout, John H. Chase, Evan Bolyen, Gail Ackermann, Antonio González, Rob Knight, Gregory G. Caporaso

Research output: Contribution to journalArticlepeer-review

27 Scopus citations


Background: Bioinformatics software often requires human-generated tabular text files as input and has specific requirements for how those data are formatted. Users frequently manage these data in spreadsheet programs, which is convenient for researchers who are compiling the requisite information because the spreadsheet programs can easily be used on different platforms including laptops and tablets, and because they provide a familiar interface. It is increasingly common for many different researchers to be involved in compiling these data, including study coordinators, clinicians, lab technicians and bioinformaticians. As a result, many research groups are shifting toward using cloud-based spreadsheet programs, such as Google Sheets, which support the concurrent editing of a single spreadsheet by different users working on different platforms. Most of the researchers who enter data are not familiar with the formatting requirements of the bioinformatics programs that will be used, so validating and correcting file formats is often a bottleneck prior to beginning bioinformatics analysis. Main text: We present Keemei, a Google Sheets Add-on, for validating tabular files used in bioinformatics analyses. Keemei is available free of charge from Google's Chrome Web Store. Keemei can be installed and run on any web browser supported by Google Sheets. Keemei currently supports the validation of two widely used tabular bioinformatics formats, the Quantitative Insights into Microbial Ecology (QIIME) sample metadata mapping file format and the Spatially Referenced Genetic Data (SRGD) format, but is designed to easily support the addition of others. Conclusions: Keemei will save researchers time and frustration by providing a convenient interface for tabular bioinformatics file format validation. By allowing everyone involved with data entry for a project to easily validate their data, it will reduce the validation and formatting bottlenecks that are commonly encountered when human-generated data files are first used with a bioinformatics system. Simplifying the validation of essential tabular data files, such as sample metadata, will reduce common errors and thereby improve the quality and reliability of research outcomes.

Original languageEnglish (US)
Article number27
Issue number1
StatePublished - 2016


  • Cloud
  • Data validation
  • Metadata
  • Plugin
  • Spreadsheet
  • Tabular file format

ASJC Scopus subject areas

  • General Medicine


Dive into the research topics of 'Keemei: Cloud-based validation of tabular bioinformatics file formats in Google Sheets'. Together they form a unique fingerprint.

Cite this