User Guide - Excel compare tool
Choose a topic to get started
Two Excel File Comparison Guide
Quickly compare two Excel files, select unique key columns for accurate matching, analyze differences, and export results. Covers practical scenarios and best practices.
Guide to Comparing Two Sheets
Learn how to compare different sheets within the same Excel file, suitable for data version changes, monthly reports, pre and post inventory checks, and more.
How to Merge Multiple Excel Files
Combine 2–20 Excel files into one workbook by sheets or by rows. Step-by-step guide with pitfalls and use cases.
How to Split a Large Excel File
Split by column values, date ranges, or row count. Pick the right split column and avoid runaway sheet counts.
How to Clean Excel Data
Remove empty rows, trim whitespace, drop empty columns, and normalize line breaks. Four rules that fix 90% of dirty spreadsheets.
How to Convert Between XLSX, CSV, and TSV
What survives each conversion, the UTF-8 BOM, and how to avoid mojibake. Practical guidance for accounting and database imports.
How to Find and Remove Duplicate Rows
Full-row vs key-column matching, how to pick the right key columns, and why you should always review before discarding.