{"id":19615,"date":"2023-05-26T09:46:32","date_gmt":"2023-05-26T09:46:32","guid":{"rendered":"https:\/\/www.obd2tool.com\/blog\/?p=19615"},"modified":"2024-04-23T03:20:49","modified_gmt":"2024-04-23T03:20:49","slug":"how-to-transfer-cat-et-data-log-file-to-excel","status":"publish","type":"post","link":"https:\/\/www.obd2tool.com\/blog\/how-to-transfer-cat-et-data-log-file-to-excel\/","title":{"rendered":"How to Transfer CAT ET Data Log File to Excel"},"content":{"rendered":"<p>Caterpillar ET diagnostic data log files only can be opened viewed on CAT ET diagnostic software,so if you can export it and edit it on Excel will make your work easier. So here obd2tool show you guide on how to transfer <a href=\"https:\/\/www.obd2tool.com\/category-223-b0-CAT+Caterpillar+ET+Diagnostic+Adapter.html\">Cat ET<\/a> diagnostic data log file to Excel.<\/p>\n<p><strong>Preparations:<\/strong><br \/>\n<a href=\"https:\/\/www.obd2tool.com\/blog\/caterpillar-et-electronic-technician-software-free-download\/\">Caterpillar ET 2024A 2019C 2018A Electronic Technician Software Free Download<\/a><br \/>\n<a href=\"https:\/\/www.obd2tool.com\/goods-10529-CAT-Caterpillar-ET-4-Diagnostic-Communication-Adapter.html\">CAT Adapter 3 ET4 478-0235 High Quality Diagnostic Adapter<\/a><br \/>\n<a href=\"https:\/\/www.obd2tool.com\/blog\/caterpillar-sis-software-download-and-installation\/\">Caterpillar SIS 2022 Software Free Download<\/a><\/p>\n<p><strong>Why exporting CAT ET Data logger to Excel?<\/strong><br \/>\n-Export data, then use the Excel calculation function.<br \/>\n-Make your own graph combining different sources of data Use it in order to troubleshoot equipment.<br \/>\n-Demonstrate new strategies.<br \/>\n-Get a bench mark for future troubleshooting.<\/p>\n<p><strong>Procedures:<\/strong><br \/>\nRun CAT ET diagnostic software,then stop machine connection<br \/>\nClick \u201cFile\u201d option on menu bar,then select \u201cExport\u201d<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-19627\" src=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-1.jpg\" alt=\"\" width=\"992\" height=\"607\" srcset=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-1.jpg 992w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-1-300x184.jpg 300w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-1-900x551.jpg 900w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-1-768x470.jpg 768w\" sizes=\"(max-width: 992px) 100vw, 992px\" \/><\/p>\n<p>Select the data log file that you saved before to open<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-19616\" src=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-2.jpg\" alt=\"\" width=\"1087\" height=\"611\" srcset=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-2.jpg 1087w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-2-300x169.jpg 300w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-2-900x506.jpg 900w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-2-768x432.jpg 768w\" sizes=\"(max-width: 1087px) 100vw, 1087px\" \/><\/p>\n<p>Then click \u201cSave\u201d it as txt file format<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-19626\" src=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-3.jpg\" alt=\"\" width=\"950\" height=\"595\" srcset=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-3.jpg 950w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-3-300x188.jpg 300w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-3-900x564.jpg 900w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-3-768x481.jpg 768w\" sizes=\"(max-width: 950px) 100vw, 950px\" \/><\/p>\n<p>Click the \u201cExport\u201d button to complete the export of the service tool file to an external file<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-19625\" src=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-4.jpg\" alt=\"\" width=\"983\" height=\"493\" srcset=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-4.jpg 983w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-4-300x150.jpg 300w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-4-900x451.jpg 900w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-4-768x385.jpg 768w\" sizes=\"(max-width: 983px) 100vw, 983px\" \/><\/p>\n<p>The service tool file was successfully exported<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-19624\" src=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-5.jpg\" alt=\"\" width=\"993\" height=\"559\" srcset=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-5.jpg 993w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-5-300x169.jpg 300w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-5-900x507.jpg 900w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-5-768x432.jpg 768w\" sizes=\"(max-width: 993px) 100vw, 993px\" \/><\/p>\n<p>Now close CAT ET diagnostic software,then open Excel<br \/>\nClick \u201cFile\u201d\u00e0\u201dOpen\u201d<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-19623\" src=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-6.jpg\" alt=\"\" width=\"733\" height=\"496\" srcset=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-6.jpg 733w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-6-300x203.jpg 300w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-6-120x80.jpg 120w\" sizes=\"(max-width: 733px) 100vw, 733px\" \/><\/p>\n<p>Select the txt file you saved from CAT ET<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-19622\" src=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-7.jpg\" alt=\"\" width=\"899\" height=\"534\" srcset=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-7.jpg 899w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-7-300x178.jpg 300w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-7-768x456.jpg 768w\" sizes=\"(max-width: 899px) 100vw, 899px\" \/><\/p>\n<p>Click \u201cNext\u201d<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-19621\" src=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-8.jpg\" alt=\"\" width=\"810\" height=\"437\" srcset=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-8.jpg 810w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-8-300x162.jpg 300w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-8-768x414.jpg 768w\" sizes=\"(max-width: 810px) 100vw, 810px\" \/><\/p>\n<p>Select \u201cComma\u201d and click \u201cFinish\u201d<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-19620\" src=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-9.jpg\" alt=\"\" width=\"1016\" height=\"606\" srcset=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-9.jpg 1016w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-9-300x179.jpg 300w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-9-900x537.jpg 900w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-9-768x458.jpg 768w\" sizes=\"(max-width: 1016px) 100vw, 1016px\" \/><\/p>\n<p>Now you data log file transfer to Excel finish,it is available to be edit<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-19619\" src=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-10.jpg\" alt=\"\" width=\"951\" height=\"576\" srcset=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-10.jpg 951w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-10-300x182.jpg 300w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-10-900x545.jpg 900w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-10-768x465.jpg 768w\" sizes=\"(max-width: 951px) 100vw, 951px\" \/><br \/>\n<img loading=\"lazy\" class=\"alignnone size-full wp-image-19618\" src=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-11.jpg\" alt=\"\" width=\"1105\" height=\"552\" srcset=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-11.jpg 1105w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-11-300x150.jpg 300w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-11-900x450.jpg 900w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-11-768x384.jpg 768w\" sizes=\"(max-width: 1105px) 100vw, 1105px\" \/><br \/>\n<img loading=\"lazy\" class=\"alignnone size-full wp-image-19617\" src=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-12.jpg\" alt=\"\" width=\"1078\" height=\"551\" srcset=\"https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-12.jpg 1078w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-12-300x153.jpg 300w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-12-900x460.jpg 900w, https:\/\/www.obd2tool.com\/blog\/wp-content\/uploads\/2023\/05\/How-to-Transfer-CAT-ET-Data-Log-File-to-Excel-12-768x393.jpg 768w\" sizes=\"(max-width: 1078px) 100vw, 1078px\" \/><\/p>\n<p>More information for Caterpillar topic,please refer to:<a href=\"https:\/\/www.obd2tool.com\/blog\/category\/caterpillar-trouble-repair\/\">Caterpillar Trouble Repair<\/a><\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Caterpillar ET diagnostic data log files only can be opened viewed on CAT ET diagnostic software,so if you can export<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3224,65],"tags":[940,1334,571,2314,1392,1394,1630],"views":2456,"_links":{"self":[{"href":"https:\/\/www.obd2tool.com\/blog\/wp-json\/wp\/v2\/posts\/19615"}],"collection":[{"href":"https:\/\/www.obd2tool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.obd2tool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.obd2tool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.obd2tool.com\/blog\/wp-json\/wp\/v2\/comments?post=19615"}],"version-history":[{"count":6,"href":"https:\/\/www.obd2tool.com\/blog\/wp-json\/wp\/v2\/posts\/19615\/revisions"}],"predecessor-version":[{"id":21277,"href":"https:\/\/www.obd2tool.com\/blog\/wp-json\/wp\/v2\/posts\/19615\/revisions\/21277"}],"wp:attachment":[{"href":"https:\/\/www.obd2tool.com\/blog\/wp-json\/wp\/v2\/media?parent=19615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.obd2tool.com\/blog\/wp-json\/wp\/v2\/categories?post=19615"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.obd2tool.com\/blog\/wp-json\/wp\/v2\/tags?post=19615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}