You can open TDMS files in Microsoft Excel using the TDM Excel Add-in TDM Excel Add-In for Microsoft Excel Download


You can download it and install it and it will allow you to open the files directly in Microsoft Excel.


1. Time conversion from UTC to Excel time

For Inksight system, the first column represents the Absolute timestamp in UTC. This is the time in seconds, since 01/01/2019. 

To convert this into excel time stamp format do as follow: 

  1. Add to the TimeAbs UTC the number 3755289600 these are the seconds from 01/01/1900 to 01/01/2019

  2. Divide by 86400, which is the amount of seconds in one day. 

This is: 

For example: 

If the TimeAbs UTC value is equal to 59554408, then: 

The value 44153.28713 are the days since 01/01/1900. The fractional part represents minutes, seconds etc.