Most batch scripts are designed to produce output. Instead of converting the BAT file itself, in a CSV-friendly format.
Use this one-liner in your BAT file to convert the CSV to a proper Excel Workbook: convert bat file to excel
Characters like | , > , < , & , % can break CSV parsing. Escape or replace them. Most batch scripts are designed to produce output
Batch script to collect details and write to an Excel spreadsheet report.csv hostname >
@echo off echo ComputerName,IP,OS > report.csv hostname >> report.csv ipconfig | findstr IPv4 >> report.csv systeminfo | findstr "OS Name" >> report.csv
Now go ahead—convert that messy batch file into a sparkling spreadsheet.