A comprehensive Google Apps Script tool for cleaning and formatting Google Sheets with advanced features for data management, formatting, column sizing, and alignment.

Create Table of Contents - Generate a comprehensive overview sheet with all workbook sheets
Date Range Detection - Automatically find min/max dates in sheets with date data
Professional Formatting - Beautifully formatted overview with alternating colors and proper alignment
Trim Empty Rows & Columns - Remove unused rows and columns from sheets
Find & Clear Hidden Data - Detect and remove empty formulas and whitespace-only cells
Header Formatting - Bold and freeze header rows
First Column Formatting - Bold and freeze first columns
Auto-Resize - Automatically resize columns to fit content
Smart Sizing - Intelligent sizing based on content type (numbers, text, long text)