Quickly find duplicates in one sheet or in two columns. Move, delete, or highlight the results.
This add-on comes with two useful wizards. One will show how to delete duplicates in Google Sheets in 4 steps, the other will quickly compare data from two columns for repeated values.
"Find duplicates or uniques" is a quick assistant for Google Sheets: remove duplicates in a column or find duplicate rows. You are free to include the first occurrences or look for unique entries. It lets you choose one of 6 ways you can deal with the results: highlight or remove duplicate lines, copy or move them to another Google Spreadsheet, or clear duplicate entries leaving the cells intact. Once you run the add-on, it will display a summary for the results found in your sheet.
Use the "Compare columns or sheets" tool to quickly scan two Google Sheets columns for the same values. It will take you five simple steps to compare lists and mark the results with colour or status, copy or move them, clear repeating cells, or remove duplicate rows from your main table.
The add-on offers case-sensitive search and additional options for handling empty cells and headers. You can use this tool to make your Google Sheets duplicate-free in a flash.
Quickly find duplicates in one sheet or in two columns. Move, delete, or highlight the results.
This add-on comes with two useful wizards. One will show how to delete duplicates in Google Sheets in 4 steps, the other will quickly compare data from two columns for repeated values.
"Find duplicates or uniques" is a quick assistant for Google Sheets: remove duplicates in a column or find duplicate rows. You are free to include the first occurrences or look for unique entries. It lets you choose one of 6 ways you can deal with the results: highlight or remove duplicate lines, copy or move them to another Google Spreadsheet, or clear duplicate entries leaving the cells intact. Once you run the add-on, it will display a summary for the results found in your sheet.
Use the "Compare columns or sheets" tool to quickly scan two Google Sheets columns for the same values. It will take you five simple steps to compare lists and mark the results with colour or status, copy or move them, clear repeating cells, or remove duplicate rows from your main table.
The add-on offers case-sensitive search and additional options for handling empty cells and headers. You can use this tool to make your Google Sheets duplicate-free in a flash.
This add-on offers a great opportunity to consolidate data from many spreadsheets into one. Even if your tables differ in formatting, column order, or content, Combine Sheets will perfectly join everything you have in one table using the column headers. You dictate the add-on what sheets to compare, what to do with formatting, and where to put the results on two quick steps.
Combine as many spreadsheets as you need.
Add sheets from Google Drive using quick search field.
Use entire sheet or adjust the range manually.
Transfer the formatting of the original datasets.
Review the result in a new spreadsheet, sheet, or a range of your choice.
What's more, you can separate combined sheets with empty rows. This way you'll be able to scan through the consolidated data easily and work with it faster. Try it yourself and you won't regret it.
This add-on offers a great opportunity to consolidate data from many spreadsheets into one. Even if your tables differ in formatting, column order, or content, Combine Sheets will perfectly join everything you have in one table using the column headers. You dictate the add-on what sheets to compare, what to do with formatting, and where to put the results on two quick steps.
Combine as many spreadsheets as you need.
Add sheets from Google Drive using quick search field.
Use entire sheet or adjust the range manually.
Transfer the formatting of the original datasets.
Review the result in a new spreadsheet, sheet, or a range of your choice.
What's more, you can separate combined sheets with empty rows. This way you'll be able to scan through the consolidated data easily and work with it faster. Try it yourself and you won't regret it.
Combine columns, rows, or ranges of data and preserve original values.
This add-on will become your best assistant for merging values in adjacent cells. Three simple settings let you decide if you want to combine multiple columns or rows, pick the delimiter for the records, and choose a place for the results.
Join values horizontally, vertically, or bring all records from the selected range into one cell
Add results to the existing values or as a new column or row
Merge cells without losing your data: you can avoid the standard problem of "Keeping data only in the top leftmost cell" and retain all your records while removing borders between them
Skip blanks, wrap text, and choose other additional options that tailor the results to your needs.
Besides, there is a special option that creates a backup copy of your sheet in case you want to keep it the way it was. You can set up the process in under a minute and concatenate data in seconds.
Combine columns, rows, or ranges of data and preserve original values.
This add-on will become your best assistant for merging values in adjacent cells. Three simple settings let you decide if you want to combine multiple columns or rows, pick the delimiter for the records, and choose a place for the results.
Join values horizontally, vertically, or bring all records from the selected range into one cell
Add results to the existing values or as a new column or row
Merge cells without losing your data: you can avoid the standard problem of "Keeping data only in the top leftmost cell" and retain all your records while removing borders between them
Skip blanks, wrap text, and choose other additional options that tailor the results to your needs.
Besides, there is a special option that creates a backup copy of your sheet in case you want to keep it the way it was. You can set up the process in under a minute and concatenate data in seconds.
Scan two sheets for the same values based on key columns and update your main table with the missing information.
Five simple steps of the Merge Sheets wizard will guide you through the process of joining data from two tables. If you have at least one common identifier column in both sheets, e.g. product ID, the add-on will insert all the missing information for the same records in your main table.
Select the table you want to update and the one to pull information from
Define common columns the add-on can use to find the same records
Choose the columns to update or add to your main sheet
The merge assistant will do the rest. It will quickly compare key columns and find the necessary updates, no vlookup formulas needed. You can highlight changes with color, work only with the empty cells, and have all new records added to the end of the table. When the merge is complete, you'll see the summary of all changes that the add-on has made.
You can use this tool whenever you need to compare two sheets and bring the latest changes to your table.
Scan two sheets for the same values based on key columns and update your main table with the missing information.
Five simple steps of the Merge Sheets wizard will guide you through the process of joining data from two tables. If you have at least one common identifier column in both sheets, e.g. product ID, the add-on will insert all the missing information for the same records in your main table.
Select the table you want to update and the one to pull information from
Define common columns the add-on can use to find the same records
Choose the columns to update or add to your main sheet
The merge assistant will do the rest. It will quickly compare key columns and find the necessary updates, no vlookup formulas needed. You can highlight changes with color, work only with the empty cells, and have all new records added to the end of the table. When the merge is complete, you'll see the summary of all changes that the add-on has made.
You can use this tool whenever you need to compare two sheets and bring the latest changes to your table.
This add-on offers a great opportunity to consolidate data from many spreadsheets into one. Even if your tables differ in formatting, column order, or content, Combine Sheets will perfectly join everything you have in one table using the column headers. You dictate the add-on what sheets to compare, what to do with formatting, and where to put the results on two quick steps.
Combine as many spreadsheets as you need.
Add sheets from Google Drive using quick search field.
Use entire sheet or adjust the range manually.
Transfer the formatting of the original datasets.
Review the result in a new spreadsheet, sheet, or a range of your choice.
What's more, you can separate combined sheets with empty rows. This way you'll be able to scan through the consolidated data easily and work with it faster. Try it yourself and you won't regret it.
This add-on offers a great opportunity to consolidate data from many spreadsheets into one. Even if your tables differ in formatting, column order, or content, Combine Sheets will perfectly join everything you have in one table using the column headers. You dictate the add-on what sheets to compare, what to do with formatting, and where to put the results on two quick steps.
Combine as many spreadsheets as you need.
Add sheets from Google Drive using quick search field.
Use entire sheet or adjust the range manually.
Transfer the formatting of the original datasets.
Review the result in a new spreadsheet, sheet, or a range of your choice.
What's more, you can separate combined sheets with empty rows. This way you'll be able to scan through the consolidated data easily and work with it faster. Try it yourself and you won't regret it.