SheetCompareHow-to
Spreadsheet How-To Guides
Practical, copy-paste-friendly walkthroughs for the spreadsheet tasks that come up every week. Built around real workflows, not theory.
Comparing files
Diff two Excel files, two CSVs, two Google Sheets, JSON arrays — without converting first.
- • Compare two Excel files
- • Compare two CSV files
- • Compare two Google Sheets
- • Find differences between two spreadsheets
Converting formats
Move data between CSV, XLSX, JSON, XML, and TSV without losing types or breaking encoding.
- • Convert CSV to Excel
- • Convert Excel to CSV
- • Open CSV in Excel without formatting issues
- • Handle large CSV files
Cleaning data
Find duplicates, remove blank rows, split big files, fix encoding issues, and standardize columns.
- • Find duplicates in CSV
- • Find duplicates in Excel
- • Remove blank rows in Excel
- • Split large CSV files
Reconciliation & auditing
Reconcile bank statements, audit spreadsheet changes, track edits across versions of a model.
- • Reconcile bank statements
- • Audit spreadsheet changes
- • Track changes in Excel
- • Merge two CSV files
Working with JSON & XML
Diff structured data files, validate schemas, and convert in and out of tabular formats.
- • Compare JSON files
- • Validate CSV files
- • Diff CSV files on the command line
More guides coming
We're writing how-to content weekly. If there's a workflow you want covered, sign up and ask.