Join data
Join workbooks that use different Excel date systems
Match dates across workbooks that use Excel’s 1900 and 1904 date systems by importing the original XLSX files.
Make spreadsheet work simpler
Match customer lists, find missing values, and combine spreadsheets. See how to solve everyday Excel problems with worked examples in JOIN SHEET.
Append sheets
Find repeated IDs across files and keep their full records
Find IDs that appear more than once across combined files, then join the ID list back to keep every matching record.
Join data
Keep the latest record for each ID, including all its columns
Find the highest version for each product, then join on product ID and version to retrieve the full record. Tied latest versions are kept.
Join data
Keep notes with the right record when rows change order
Store notes with a stable record ID, then join them to each updated report so changes in row order do not move notes to the wrong record.
Join data
Extract unmatched records with their details
Find records missing from a completed list while keeping their names and amounts. Join the lists, then filter for missing matches.
Join data
Keep whole groups when any member meets a condition
Keep every row in a group if at least one value meets your condition. Find the qualifying groups, then join them to the original records.