Spreadsheet Rescue & Optimization

A safety-first Google Sheets add-on that audits a messy spreadsheet and reports exactly what's wrong with it — without deleting or changing a single cell until you say so.

📊 Project Summary

• Run Spreadsheet Audit scans every sheet and generates a Rescue Report tab — rows, columns, blank rows, formula cells, and a plain-language status (Healthy, Needs Redesign, Large Dataset) for each tab. No data is touched during the audit.
• Backup Created automatically saves a timestamped backup copy before any cleanup action runs, so changes are always reversible.
• Clean Blank Rows removes completely empty rows from data tabs on command, with a confirmation step before anything is deleted.
• Built this after one too many client spreadsheets arrived in rough shape — the goal was a tool that diagnoses problems clearly enough that a non-technical user could understand what needed fixing and why.

🧰 Tools Used

• Google Apps Script (custom menu, dialogs, backup logic)
• Google Sheets (data auditing, reporting)

📷 Audit, Backup & Cleanup

📁 Files

Download the demo dataset used to test the audit and cleanup tools.