Merge Sheets add-on for Google Sheets is a useful and easy-to-use tool for matching and combining records from two sheets or data from two tables. VLOOKUP and INDEX/MATCH functionalities are no longer needed. It searches and matches key columns in the two sheets you provide, updating your primary table with any necessary changes. The add-ons from Ablebits set the tool to only update new and/or empty cells, and to extract rows from another spreadsheet that don’t match.
To use your add-on to combine two Google sheets, you open Merge sheets from the Merge & Combine group in Power Tools. Then you select the primary sheet and choose a lookup sheet. After choosing important columns that are the same in both tables, you determine which columns in the primary table need to be added or updated. Finally, you click “Finish” for the tool to do its job.
Merge Sheets add-on for Google Sheets Discount Code
Feature Highlights
- Making changes to the entire primary table.
- Add rows from the lookup table to the main table that are unique.
- In the main table, only empty and new cells are updated.
- Join two Google Spreadsheets together without using formulae or copy-pasting.
- Choosing a different color to highlight all changes.
- Merge Sheets add-on for Google Sheets will recognize the same data and get updates even if the column order is changed.
- Saving unique rows to the end of the table.
Screenshots
Additionally, the Merge Sheets add-on for Google Sheets adds non-matching rows to the end of the main sheet. It also can color the changes for you. Once you select the corresponding option on the last step, you’ll be offered a palette with different hues — pick the one you like and enjoy the results.
Technical Details
Language Support | English, Français, German, Italian, Spanish, Swedish, and more… |
Money Back Guarantee | 60-Day |
Operating System | Windows |
Shipping | Instantly receive the latest Full Version download link and license code |
Subscription | 1-Year, Lifetime |
Support Services | Email, Tickets |
This site uses User Verification plugin to reduce spam. See how your comment data is processed.