SmartExcelGuardian is a Python desktop tool for inspecting and cleaning Excel files. It detects missing values, duplicates, type coercion issues, and invalid formulas, then assigns a heuristic “column health” score (0–100).

Features include:

automatic missing-value imputation (mean/mode)

formula cleanup and regenerated SUM/AVERAGE rows

conditional formatting for high-risk columns

column name normalization

exports to Excel, PDF, JSON, and TXT

Built with pandas, openpyxl, reportlab, and tkinter/ttkbootstrap. Primarily aimed at analysts and engineers who inherit messy Excel files and want fast, auditable cleanup without writing ad-hoc scripts.

Feedback welcome.