TDM Excel Add-In for Microsoft Excel Download

Using the FREE TDM Excel Add-in for Microsoft Excel, you can load and work with TDM and TDMS files in Excel.

Supported Features:

• Interactively load TDM and TDMS files in Excel
• 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
• Ignore decimation groups generated by SignalExpress.

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 and 64-bit)
• Excel 2000 and before are not supported

Note: You can create a DataPlugin to read Microsoft Excel and OpenOffice Calc spreadsheets with LabVIEW, DIAdem or DataFinder.

Note: Use the ExcelTDM DataPlugin to read Excel files stored with the same worksheet layout as created by the TDM Excel Add-In.  More detailed information can be found here: Editing TDM(S) files with the TDM Excel Add-In.

 

 

FILE EXTENSION:	*.TDM; *.TDMS
DIRECTION:	Read / ---
LAST CHANGE:	June 23, 2011 [3.3.0.0]

 

 

 

 

Installation Instructions

1. Download the attached file referenced in this document titled tdm_excel_add_in_2011.exe.
   
2. Double-click on the file tdm_excel_add_in_2011.exe.
   
3. Follow the installation dialogs.
   
4. After the installation of the TDM Excel Add-In on Microsoft Vista you need to start Microsoft Excel at least once using administrator privileges.

 

 

Requirements

Filename: tdm_excel_add-in_2011.exe

Software Requirements

Application Software: DIAdem Development System 10.2, LabVIEW Base Development System 2009, LabWindows/CVI Base Development System 9.0, Measurement Studio Standard Edition 8.6
Additional Software: Microsoft Excel

Reader Comments | Submit a comment »

TDM Excel Add-in 2011 Capabilities
As an update to some of the questions posted here over the past few month: The current version (2011) of the TDM Excel Add-in works with Excel versions "2003 and higher", which includes version 2007 and 2010 - and includes support for Excel 2010 64-bit. We are not going to support Excel version before 2003, since Microsoft has ended support for these versions years ago. The issue regarding Excel 2007 row limitation has been addressed by R&D, the same applies to double-clicking on TDM(S) files - which will open Excel or DIAdem depending on the default application setting of the Windows operating system. The TDM Excel Add-In comes with in COM automation interface to automate loading TDM(S) files into Excel.
- Otmar Foehner, National Instruments. otmar.foehner@ni.com - Aug 16, 2011

2011 version
This new version supports Excel 2010 64-bit and has a fix for more than 65535 rows in Excel 2010.
- Mavis Jin, National Instrument. mavis.jin@ni.com - Jul 19, 2011

Offce 2010 64-bit support
When will this plug-in support 64-bit Excel? Thanks.
- tstanley@hysitron.com - Jun 8, 2011

VB with TDM C DLL
i want to use VB 2010 to read a tdm file，i also download TDM C DLL，but i don't know how to operate，can you give me some examples
- adven, xp. ppxadvent@sohu.com - Jun 2, 2011

the new 2010-version (3.2) still does not support importing more than 65535 rows
in office 2007 or higher there is still no support in loading more than 65535 rows when running the TDM-importer. I hoped it was fixed by now !!! Is there perhaps a way to have a little more control when using the import from VBA, it always seems to open in a new workbook. Another item on my wishlist is to have a startingoffset and a decimator for specific channels. I have a dataset which contains 10 channels at 200 Hz and 1 channel at 2000 Hz. For data- analysis using excel it would be nice to have it decimated to 200 Hz so I will probably not run into the 65535 limitation.
- Sep 13, 2010

does not work with excel 2007
I installed this plug in excel2003 - works well it does not show up in excel2007 - I can not access my tdms files
- Aug 13, 2010

Excel 2010
It is working with Office Excel 2010 (Beta).
- Zoltan Blahunka, Szent István Egyetem (HU). blahunka.zoltan@gek.szie.hu - Jun 18, 2010

TDM Import breaks double-click
With The TDM Import add-in loaded, I can no longer use double-click to open Excel files. Excel launches, and there is a toolbar with a blank screen - not even empty worksheet. If I click on the add-in and cancel, or even click on add- in "About", then the file open completes. Still, it is inconvenient.
- Daniel, KU BNCD. deb193@ku.edu - Jun 8, 2010

Does not fully support excel 2007 row limit
Excel 2007 supports up to a million rows (1,048,576) While Excel 2003 and below only supported roughly 65,000 rows. The tdms importer limits you to the old 65,000 rows and doesnt allow the new limits! While this is an improvement over the older version of the plugin which would simply crash if you tried to import more than 65,000 values, this still needs to be fixed. I want to import a big tdms file into excel. I am recording at 200Hz for an hour. That's 720,000 rows. Excel can handle it. TDMS importer cannot.
- kyle.ramsdell@dot.state.fl.us - Sep 21, 2009

Is this supposed to work with Excel 2007?
I can't get it to install (I have Excel 2007). The installation runs, I accept the license agreement, then at the next screen it says "No software will be installed". No options to continue.
- Jeffrey Scharpf, Milwaukee Electric Tool. jeffrey.scharpf@milwaukeetool.com - Apr 6, 2009

For some reasons, the Add-Ins tab doesn't show up for me in Excel 2007 even though the addin appears to have been read at startup. Any idea why the Add-Ins tab is not showing up? Note, I disabled the addin, removed the addin, rebooted, re-installed, and reran Excel but this didn't work.
- Anthony Marshall, Intel Corporation. anthony.marshall@intel.com - Feb 11, 2009

Should be available for Excel 2000
This should really be available for 2000 as well.
- braden Giacobazzi, NASA GRC. bgiacoba@mtu.edu - Jan 28, 2009

how to allow all users to use tool?
Is there a way to make it so that non-administrator users can use the tool? From what I've seen only the installer (admin) can access the tool. I'd like all users to be able to use the tool once it has been installed by an admin.
- Nov 17, 2008

needs option to not load certain data
It would be very helpful if there was a property you could set that would cause it not to load particular data. For example, I have a file that has my spreadsheet data saved in it, but I also save images as a byte array. If there was a special group property you could set that would disable this application from loading the image data then it would stop excel from loading massive amounts of data.
- Sep 25, 2008

TDM Excel Add-in Capabilities
The currently posted TDM Excel Add-in works with Excel versions "2003 and higher", which includes version 2007. The currently posted TDM Excel Add-in does correctly import date/time channels into Excel-- note that Excel tracks date/time as the number of fractional days since about 1900. You may need to change the formatting of the datetime channel column in Excel to see the datetime information the way you want it. An error report has been entered for the TDM Excel Add-in for the 256 column limitation in Excel 2007. Hopefully a new version will be posted soon which removes this artificial limitation.
- Brad Turpin, National Instruments. brad.turpin@ni.com - Sep 24, 2008

How about a version for Excel 2007
- Sep 12, 2008

256 Channel limit
Note that there is a 256 channel limit (per tab) in Excel. This add-in will only display the first 256 channels. You can probably get around this by writing code to split the TDM file into multiple smaller files or create your own Excel converter VI that would place 256 channels per tab. Or you could just use DIAdem...you know you want to...all the cool people are doing it. (-;
- Andrew Soukup, SpaceX. asoukup@spacex.com - Mar 18, 2008

Exporing Data
I think it would be useful to have the possibility to build the excel file directly from LabView. Regards.
- LUCIANO MANARA, PERONI POMPE SPA. lucianomanara@peronipompe.it - Nov 20, 2007

Needs Timestamp Data (#2)
I confirm that a time stamp data column would be very useful, if not necessary, also for my company (we manufacture hydraulic pumps, mainly for chemical or oil and gas companies); in fact, also for legal/contract issues, we have to recall the exact time in which a variation of the conditions happens. Thank you very much for your attention.
- Luciano Manara, Peroni Pompe SpA. luciano.manara@peronipompe.it - Oct 31, 2007

Needs timestamp data
This would be very helpful for my application, but the file data is transported to excel without any timing information, making it difficult to graph the results correctly. It would be great if the first column on every sheet contained timestamp data for each row. I don't suppose the source code is available so that we can add improvements ourselves?
- Jason Dunham, SF Industrial Software, Inc.. dunham@sfis.com - Sep 6, 2007