How to how conditional formatting bloats excel file size — and how to reduce it
- Step 1Run Weight Analyzer — Upload the file and note which xl/worksheets/sheet*.xml files are disproportionately large.
- Step 2Check conditional formatting rules in Excel — In Excel: Home → Conditional Formatting → Manage Rules → show rules for 'This Worksheet'.
- Step 3Remove redundant rules — Delete rules applied to entire columns. Limit rules to the actual data range (e.g. $A$2:$A$10000 instead of $A:$A).
- Step 4Re-analyze — Save and re-upload to the Weight Analyzer to confirm the size reduction.
Frequently asked questions
Can Copy-Paste create duplicate conditional formatting rules?+
Yes — Copy-Paste copies all formatting including conditional rules. After pasting, check Manage Rules for duplicates.
Does clearing all formatting fix the bloat?+
Yes — Home → Clear → Clear Formats removes all conditional formatting. Reapply only the rules you need.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.