How to Compare Two Excel Spreadsheets & Highlight What Is Missing. Comparing two spreadsheets using an automated tool eliminates the tedious task of manually analyzing cells for differences.