TDM Excel Add-In Tool for Microsoft Excel User Guide

This application note outlines how to use the TDM Excel Add-In tool to load NI *.TDM and *.TDMS files into Microsoft Excel.

To download and install the TDM Excel Add-In go to the TDM Excel Add-In Download Page.

Operation: Install the TDM Excel Add-In and open Microsoft Excel and you will see the following custom toolbar:

Note: If you do not see the TDM Importer see Troubleshooting the TDM Excel Add-In for Microsoft Excel 2007 or Troubleshooting the TDM Excel Add-In for Microsoft Excel 2003.

Loading TDM files into Excel: Simply click on the symbol Import a TDM(S) File, this launches a file open dialog where you select which TDM file you wish to open in Excel.

Configuring the TDM Excel Add-In: You can choose which properties are loaded into Excel at the root, group and channel levels, this includes custom properties. To launch the configuration dialog pictured below, click on the symbol Configure TDM Importer.

Selective Loading:
For data files with more than 65 thousand values per row for Excel 2003 or one million for Excel 2007 the TDM Excel Add-In permits you to choose the part of the file you want to work with in Excel.

Automation:
Use the TDM Excel Add-In COM-API to load TDM/TDMS files into Microsoft Excel using VBA.

Additional Information:

• Use ‘Open with>>Excel Importer’ or double-click from Windows Explorer to open a TDM/TDMS file in Excel
• Use VBA and the TDM Excel Add-In COM-API to automate loading of TDM and TDMS files into Excel
• Each TDM/TDMS file loaded into Excel creates a new Excel Workbook
• Each group in the TDM/TDMS file is loaded onto a separate Excel Worksheet
• Each channel of a group is loaded as a separate column in the groups Worksheet

Supported file formats:

• TDMS 1.0 files and TDMS 2.0 files
• TDM files

Supported Excel versions:

• Excel 2003, Excel 2007 and Excel 2010 (32-bit)
• Excel 2000 and before are not supported
• Currently Excel 2010 64-bit is not supported

Notes on installing on Microsoft Vista:
After the installation of the TDM Excel Add-In you need to start Microsoft Excel at least once using administrator privileges.

29 Ratings | 4.07 out of 5

Read in English German Japanese | Print | PDF

Reader Comments | Submit a comment »

Win 7 x64 & Excel 2007
Likewise, doesn't work with this combination of OS and Excel.
- Jason Grunder,Binary Applications. jgrunder@binaryapplications.com - Apr 29, 2010

Excel 2010
I use the Excel 2010 Beta-Version. The TDM Add-In is not working with Excel 2010. When do you plan to support it?
- Ludwig Berndt,E-T-A Elektrotechnische Apparate GmbH. ludwig.berndt@e-t-a.de - Dec 16, 2009

Excel 2007
Im having an issue where it will work fine in XP SP3 with Excel 2007 but not Win7 with Excel 2007
- Jan 08, 2010

Excel 2010
Likewise, using Excel 2010. Office 2010 is pending release to manufacturing. When will support for Excel 2010 be forthcoming?
- May 27, 2010

Excel 2010
The current version of the TDM Excel Add-In now supports Excel 2010
- Stefan Romainczyk,National Instruments Germany. stefan.romainczyk@ni.com - Jul 28, 2010

Problem XP SP3 Excel 2007
It seems that when I import a data file an extra column with unknown data is added at column H when I use my windows 7 64 bit Pro with office 2007 I have no problem. This is an issue because I run a sort and delete macro to remove unneeded columns from my report data. Any Ideas
- Peter Menningen,Sears Holdings. pete@menningen.us - Aug 02, 2010


I have used this add- in, but it just convert Title Author Date/Time Groups Description and it does not convert anymore my valuable data, numbers!!! i cannot find numbers!
- stargrazer80@yahoo.com - Sep 15, 2010

import limit in Excel 2010
Is there a limitation on import size for Excel 2010? The documentation only mentions limitations for earlier versions.
- david.c.anthony@delphi.com - Jul 08, 2011