Guide · Test data

MDF4, TDMS, CSV, Excel, GPX, FIT, TCX: a guide to test data file formats

Every bench, data logger and software tool has its own format. Here is what each one contains, its pitfalls, and how to open it without a licence.

Why so many formats?

The same test can produce very different files depending on the tool that records it. Automotive data loggers write MDF4, National Instruments benches write TDMS, cyclers often export CSV or Excel, and field tests produce GPS tracks. The trouble starts when these files travel: to a customer, a supplier or a colleague who does not have the original software.

Formats at a glance

FormatExtensionTypeOriginTypical use
MDF4.mf4BinaryASAM standardVehicle measurements, CAN bus, data loggers
NI TDMS.tdmsBinaryNational InstrumentsTest benches running LabVIEW, VeriStand, DIAdem
CSV.csv, .txtTextUniversalExports from cyclers, loggers and software
Excel.xlsx, .xlsSpreadsheetMicrosoftSharing results, cycler exports
GPX.gpxXMLOpen standardGPS tracks, road tests
FIT · TCX.fit, .tcxBinary · XMLGarminConnected sensors, field tests, light mobility

MDF4 (ASAM MDF)

MDF, for Measurement Data Format, is standardised by ASAM and widely used in automotive. Version 4 (.mf4 files) records many signals, often from CAN buses and on-board sensors, organised in channel groups sampled at different rates. The file can also hold conversion rules from raw values to physical quantities.

Common pitfall: two signals in the same file do not necessarily share a time base. To compare them, resample them onto a common time axis.

NI TDMS

TDMS is National Instruments' format, written by LabVIEW, VeriStand, DIAdem or FlexLogger. It organises data on three levels: file, groups and channels, each with its own properties (unit, sample rate, start time…). It often comes with a .tdms_index file, which only speeds up reading.

Common pitfall: opening or sending the .tdms_index file instead of the .tdms. The .tdms file is the one that holds the measurements.

CSV

CSV is a text file where each row is a point in time and each column a measurement channel. It can be read anywhere, which makes it the most common exchange format.

Common pitfalls: the separator (comma or semicolon), decimal commas in files produced on European systems, character encoding and date formats. On long tests, files also become very large.

Excel

The .xlsx format is handy for sharing results, and many cyclers export their data to Excel, often across several sheets.

Common pitfall: an Excel sheet is limited to 1,048,576 rows. A long, finely sampled test quickly exceeds that limit, and the export is then split or truncated.

GPX, FIT and TCX

These formats come from GPS tracks and connected sensors. GPX is an open XML format for position, altitude and time. FIT, a compact binary format, and TCX, an XML format, were created by Garmin and add data such as speed, power, cadence or heart rate.

They are useful for road tests, validation drives, e-bikes and light mobility, where a measurement needs to be tied to a position and a time.

How to open these files without a licence

Thanks to NeydFlow, a free viewer is available to open and view your MDF4, NI TDMS, CSV, Excel, GPX, FIT and TCX files right in your browser, with no software to install. It comes with the free NeydFlow account.

If you work in Python, open-source libraries also exist, such as asammdf for MDF and npTDMS for TDMS.

When one file is no longer enough

Comparing dozens of tests, applying the same calculations to a whole campaign or sharing results with a team takes more than a viewer. That is what test data post-processing with the NeydFlow platform is for.

FAQ

Frequently asked questions

What is the difference between MDF4 and TDMS?

MDF4 is an ASAM-standardised format, mainly used in automotive for on-board measurements. TDMS is National Instruments' proprietary format, used on benches running LabVIEW, VeriStand or DIAdem.

Can I open an MDF4 or TDMS file in Excel?

Not directly. The file must first be converted, or opened in a viewer such as NeydFlow's free viewer, which runs in the browser.

What is the .tdms_index file for?

It speeds up reading of the matching .tdms file. It holds no measurements and can be rebuilt from the .tdms file.

Why does my CSV file show up in a single column?

Usually the file's separator (comma or semicolon) does not match the one the software expects, often because of regional settings.

Contact

Let's talk about your test project.

A first conversation with no commitment, in English or French.

contact@bertrand-consulting.fr
+33 6 33 72 47 43
Contact me