File Exchange

image thumbnail

Import Data from Excel Files Generated by Cosmed FitMate

version (535 KB) by Vincent R
Import Cosmed FitMate metabolic data excel files into MATLAB.


Updated 10 May 2016

View License

SCRIPT BASICS WRITTEN BY: John Rogers, 27 Feb 2012


Original Description:
The Cosmed FitMate software saves metabolic data in a text file. Use this function to import the data into MATLAB.


1. sample data file VO2data14Feb.TXT
The text file contains time in HH:MM:SS format, followed by metabolic data in columns.

2. main program readFitmateShell.m calls the function, converts the time to minutes, and plots heart rate and oxygen consumption (VO2).

3. function readFitmate.m
The function imports data into a cell and parses the data. It converts the three time fields to a single time matrix in seconds.

MATLAB release MATLAB 7.12 (R2011a)


Edited the function, so its able to work with xlsread.
Tested script on Matlab2015b/Mac, used .xlsx file extension.

All credits to: John Rogers

Cite As

Vincent R (2021). Import Data from Excel Files Generated by Cosmed FitMate (, MATLAB Central File Exchange. Retrieved .

Comments and Ratings (0)

MATLAB Release Compatibility
Created with R2015b
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!