Page 1 of 1
Creating .MOT file from excel
Posted: Mon Feb 29, 2016 5:55 pm
by samuelparker
I have an excel spreadsheet of joint angles corresponding with time. Is there any way to convert this file format into the .MOT file format that I need for OpenSim motions?
Thanks
Re: Creating .MOT file from excel
Posted: Mon Feb 29, 2016 11:26 pm
by mitkof6
Hi,
You can copy the data from the excel and paste them into a .mot file, with the values separated by "tab". Also, you have to add a header in the beginning, where you add some description of the data (columns, rows. etc) and you also add the names of the columns after the header.
Code: Select all
Coordinates
version=1
nRows=618
nColumns=7
inDegrees=yes
Units are S.I. units (second, meters, Newtons, ...)
Angles are in degrees.
endheader
time blockToGround_xRotation blockToGround_yRotation blockToGround_zRotation blockToGround_xTranslation blockToGround_yTranslation blockToGround_zTranslation
0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000
...
Re: Creating .MOT file from excel
Posted: Thu Mar 21, 2019 10:43 am
by mubakk
Hello,
I want to do the same thing, but I can not open a mot file. What am I missing? I do not have a place to paste the data into.
Re: Creating .MOT file from excel
Posted: Thu Mar 21, 2019 10:51 am
by jimmy
Open an excel spreadsheet, paste your data, edit the header, column data to match with
mot file format, save the file as a tab delimited file with the extension .mot