Merge Sheets add-on for Google Sheets Features Matching and merging records of multiple Google sheets into one, without formula and copy and paste. Detect the same data and retrieve updates, even if the column order differs. Identify the main table and the lookup table to get the correct data. When case sensitivity is essential to distinguish the same values. Add unmatched rows to the end of the main table. Either at the end of the main table or just after the same matching row. Update only empty cells and new cells in the main table. Prevent overwriting your values with blank cells. Clear the background color of the result, or highlight all changes with the hue of your choice. Add a helper column to see the changes better, and sort and filter the tables according to the status.