This PowerShell script automates network health checks by reading a list of IPs from Excel, pinging them multiple times, and saving the results with color-coded status.
- Reads IPs from Excel (Column A).
- Pings each IP 10 times for reliability.
- Writes results back to Excel with:
- β Green = Up
- β Red = Down
- Saves results into a timestamped Excel file (keeps history).
- Generates log files for troubleshooting.
- Can be scheduled via Windows Task Scheduler for automation.
Multiple-IP-Ping-Excel.ps1β The PowerShell scriptAll-IP-Source-Sheet.xlsxβ Example Excel input file (Column A = IPs)Logs/β Auto-generated logs on each run
- Clone/download this repository
- Place your IPs in Column A of
All-IP-Source-Sheet.xlsx - Run the script:
.\Multiple-IP-Ping-Excel.ps1
Ping-Result_YYYY-MM-DD_HH-mm-ss.xlsx