Page 1 of 1

Convert Plotter PLT files to CSV

Posted: Mon 4. Apr 2011, 13:21
by PEAK-Support
Here a easy way to export Data from the PCAN-Explorer to a CSV file (Excel compatible):
  • - Load your Trace.
    - Load and apply the Symbol file for the traced Data.
    - Import the Trace into the Plotter (Start Plotter - Import from Trace).
    - Select the needed signals.
    - Save the information as .plt file.
With the attached Software plt2csv.exe is it possible to convert the plt file to a csv file.
Then you could simply use the information inside Excel. The Time (x) use the Windows format:

The DATE type is implemented using an 8-byte floating-point number. Days are represented by whole number increments starting with 30 December 1899, midnight as time zero. Hour values are expressed as the absolute value of the fractional part of the number.

You need to use a custom format inside Windows Excel: TT.MM.JJJJ hh:mm:ss,000
Excel-Date/Time Format
Excel-Date/Time Format
Excel-Import.jpg (95.93 KiB) Viewed 8164 times
:!: NEW File Version :!:
New Parameter "/P" for change the floating point seperator from the typical German "," to the international "."
Simply use "plt2csv.exe mypltfile.plt /P" for generate a CSV with "." seperator.

Re: Convert Plotter PLT files to CSV

Posted: Mon 30. Jan 2012, 10:39
by PEAK-Support
With the Update to PCAN-Explorer 5.2, the File Export to TXT and CSV is part of the main PE5 Software.
Update Info
Update Info
Unbenannt.JPG (12.33 KiB) Viewed 7755 times
Now you could export logged CAN Data on a signal based level to a text or CSV File.
You also could select which signals you like to export.