Creating .MOT file from excel

[Samuel Parker]

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

[Dimitar Stanev]

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
...

[Murat Bakkal]

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.

[jimmy d]

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