Comprehensive CAN monitor for Windows® and its add-ins: Plotter, CANdb Import, Instruments Panel, and J1939
-
PEAK-Support
- Sales & Support

- Posts: 1646
- Joined: Fri 10. Sep 2010, 19:34
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-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
-------------------------------
-
PEAK-Support
- Sales & Support

- Posts: 1646
- Joined: Fri 10. Sep 2010, 19:34
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
- 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-CSV.jpg (62.25 KiB) Viewed 7753 times
-

- Export to TXT
- Export-TXT.jpg (109.23 KiB) Viewed 7753 times
--------------------------------
PEAK-System Technik
Technical Support Team
support[at]peak-system.com
-------------------------------