Excel Summary Generator (PowerShell)

Excel Summary Generator (PowerShell Script)

Automatically generate summaries from your Excel files — calculate total, average, maximum, and minimum values from all numeric columns in seconds.

---

What It Does

• Reads your .xlsx Excel file

• Detects all numeric columns automatically

• Calculates:

  • Sum

  • Average

  • Maximum

  • Minimum

• Saves the results in a new Excel file under the sheet name Summary

• No Excel software needed — runs directly on PowerShell with the ImportExcel module

---

How to Use

1. Download and unzip the product

2. Open the script in a text editor (like Notepad)

3. Modify the following settings at the top of the script:

   • $inputFile = full path to your source Excel file

   • $outputFile = path where the summary should be saved

4. Save and run the script with PowerShell

A sample Excel file is included for testing.

---

Requirements

• Windows PowerShell

• Internet connection (only for first-time automatic installation of the ImportExcel module)

• Source file in .xlsx format

---

Security Note

If you see a security warning when running the script:

To unblock the file:

Or run the script like this:

Or permanently allow local scripts:

---

What’s Included

• ExcelSummaryGenerator.ps1 – the script file

• README.txt – complete usage instructions

• sample_summary_input.xlsx – demo file for instant testing