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.
Dev_Master•1h ago
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.