Convert Plotter PLT files to CSV

Comprehensive CAN monitor for Windows® and its add-ins: Plotter, CANdb Import, Instruments Panel, and J1939
Post Reply
User avatar
PEAK-Support
Sales & Support
Sales & Support
Posts: 1646
Joined: Fri 10. Sep 2010, 19:34

Convert Plotter PLT files to CSV

Post by PEAK-Support » Mon 4. Apr 2011, 13:21

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 8162 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.
Attachments
PLT2CSV.zip
New PLT2CSV exe, 2 Sample files and 2 Batch Files for multiple conversion
(48.82 KiB) Downloaded 959 times
--------------------------------
PEAK-System Technik
Technical Support Team
support[at]peak-system.com
-------------------------------

User avatar
PEAK-Support
Sales & Support
Sales & Support
Posts: 1646
Joined: Fri 10. Sep 2010, 19:34

Re: Convert Plotter PLT files to CSV

Post by PEAK-Support » Mon 30. Jan 2012, 10:39

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 7753 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.
Attachments
Export to CSV
Export to CSV
Export-CSV.jpg (62.25 KiB) Viewed 7753 times
Export to TXT
Export to TXT
Export-TXT.jpg (109.23 KiB) Viewed 7753 times
--------------------------------
PEAK-System Technik
Technical Support Team
support[at]peak-system.com
-------------------------------

Post Reply