How to merge two Excel files using a common column
Join two Excel files on a shared column such as an ID or email: with XLOOKUP, with Power Query, or in your browser with no formulas. Handles missing and duplicate keys.
Reshape a table step by step. Every step can be undone and shows its Excel formula.
Join two Excel files on a shared column such as an ID or email: with XLOOKUP, with Power Query, or in your browser with no formulas. Handles missing and duplicate keys.
Compare two Excel sheets cell by cell or row by row. Formulas to find missing rows and changed values, conditional formatting, and a no-formula option.
Transpose, choose and reorder columns, split or join columns, clean up text, remove duplicates, sort, filter and find and replace. Each action is added as a step you can undo.
Yes. Paste or open a new file with the same columns and every step runs again automatically.
No. Everything runs in your browser and your data never leaves your device.
Know someone fighting with a spreadsheet? Send them this page.