SF logo
Power BI toolkit

Sheet Recon

Compare two tables from Excel or CSV by key, after cleaning both the same way: DAX column names, dates, numbers and blanks. No Copilot needed.

1

Load data

Add one or more files. Source and target can be two files or two sheets of the same workbook.

Drop files here or .xlsx, .xlsm, .xls, .csv, .tsv
2

Clean and match columns

Cleaning applies to both sides before anything is compared. Pick one or more key columns to line rows up.

Column names

Values

Separate with commas. Letter case is ignored.

Dates

Handles Sept 25, 2026 · 25-Sep-2026 · 2026-09-25T00:00 · Excel date cells and serials · 20260925. Tick Date on a column below to clean it.

Key Source column Target column Date Example after cleaning Unpair

3

Compare

Rows are paired on the key. Every compared column is checked on the cleaned values.