Group items matching

in title, tags, annotations or url

Search in values, formulas, notes, hyperlinks in all sheets at once. Get the list with the found entries and replace them in a click Use this simple add-on for advanced search in your google spreadsheet. Find and replace text within a formula, check links hidden behind the display text, search within notes, and look for values at the same time. You can search and replace within a column by simply selecting the necessary range of data, or choose to scan any selected sheets. The add-on will display the list of all found records organized by sheet and take you to any found cell in a click. It's easy to use and it offers all you need to discover the necessary data.: Look at values, formulas, notes, and links simultaneously. Find and replace in a single column or search everywhere in the spreadsheet. Get all matches listed in the sidebar, navigate to any entry in a click. Export the found values or the entire rows that contain them. Advanced Find and Replace add-on will help you complete any substitutions in your sheets in seconds.

Search in values, formulas, notes, hyperlinks in all sheets at once. Get the list with the found entries and replace them in a click Use this simple add-on for advanced search in your google spreadsheet. Find and replace text within a formula, check links hidden behind the display text, search within notes, and look for values at the same time. You can search and replace within a column by simply selecting the necessary range of data, or choose to scan any selected sheets. The add-on will display the list of all found records organized by sheet and take you to any found cell in a click. It's easy to use and it offers all you need to discover the necessary data.: Look at values, formulas, notes, and links simultaneously. Find and replace in a single column or search everywhere in the spreadsheet. Get all matches listed in the sidebar, navigate to any entry in a click. Export the found values or the entire rows that contain them. Advanced Find and Replace add-on will help you complete any substitutions in your sheets in seconds.

Use this add-on to quickly fill a range with random passwords, custom values, numbers, booleans or dates according to your criteria. This add-on will be at hand whenever you need a random set of data in your sheet. Forget about inventing clever passwords: this tool will quickly create any number of random strings that meet your requirements. All you need is pick a set of characters and choose the length for the generated values. The add-on is also good at filling your range with workdays or weekends in the selected time period, getting unique numbers from the defined range, randomizing your custom values, or simply putting yes/no or true/false values at random. Create any set of random data in your sheet in three simple steps: Select the range you want to fill with random values. Choose from 6 types of data to generate: integer or real numbers, dates, booleans, custom list values, or strings. Narrow down the data range or character set and click "Generate". This tool will be irreplaceable for completing your spreadsheet with random passwords, dates, numbers, or the data type of your choice.

Use this add-on to quickly fill a range with random passwords, custom values, numbers, booleans or dates according to your criteria. This add-on will be at hand whenever you need a random set of data in your sheet. Forget about inventing clever passwords: this tool will quickly create any number of random strings that meet your requirements. All you need is pick a set of characters and choose the length for the generated values. The add-on is also good at filling your range with workdays or weekends in the selected time period, getting unique numbers from the defined range, randomizing your custom values, or simply putting yes/no or true/false values at random. Create any set of random data in your sheet in three simple steps: Select the range you want to fill with random values. Choose from 6 types of data to generate: integer or real numbers, dates, booleans, custom list values, or strings. Narrow down the data range or character set and click "Generate". This tool will be irreplaceable for completing your spreadsheet with random passwords, dates, numbers, or the data type of your choice.

Quickly split full names to several columns with first, middle, last names, titles, and/or post-nominal letters. If you ever need to have first and last names in different columns, this add-on will prove to be a great assistant. You can complete this task in a click: choose the name parts you need and click "Split" to have them pulled out to separate cells. That's it! The add-on recognizes over 80 titles and 40 post-nominals; you can be sure you address people appropriately. Once you start it you'll see how simple it is to divide the names: Select your column with full names. Start the add-on and pick the parts you have: titles, name parts, and post-nominal letters. Click "Split" and see new columns with the results. The add-on will insert columns with the selected name units next to the original one. You can keep your table structure by considering or ignoring headers. Run this add-on to divide multi-part names into separate columns they belong to: first, middle, and last names, titles and post-nominal letters. Splitting names is that easy!

Quickly split full names to several columns with first, middle, last names, titles, and/or post-nominal letters. If you ever need to have first and last names in different columns, this add-on will prove to be a great assistant. You can complete this task in a click: choose the name parts you need and click "Split" to have them pulled out to separate cells. That's it! The add-on recognizes over 80 titles and 40 post-nominals; you can be sure you address people appropriately. Once you start it you'll see how simple it is to divide the names: Select your column with full names. Start the add-on and pick the parts you have: titles, name parts, and post-nominal letters. Click "Split" and see new columns with the results. The add-on will insert columns with the selected name units next to the original one. You can keep your table structure by considering or ignoring headers. Run this add-on to divide multi-part names into separate columns they belong to: first, middle, and last names, titles and post-nominal letters. Splitting names is that easy!

Power Tools add-on cuts the clicks on repeated tasks and brings features for organizing and unifying data in Google Sheets. Extra spaces, formulas and data in the wrong format are among many of the issues the add-on deals with: - Take advantage of the new smart toolbar with handy assistants: insert or delete cells and shift adjacent data, change case, or swap values. - Click once to AutoSum numbers in every row or column; sum and count cells by color. - Search all selected sheets for certain values, formulas, notes, and hyperlinks; see a list of found entries, export or replace them in a click. - Get "Text to columns" feature: split values in a column by any delimiter, string, or by position. - Automate some routine tasks: add or remove text by position, transform formulas, change formula reference type, export range to XML or JSON. - Bring order to your sheet: delete unwanted characters, types of data, and clean up formatting. - Get every needed data tool in one place: remove duplicates or bring them to one row, compare and merge sheets, randomize data, and much more. The add-on keeps history of the recent operations at hand so that you can quickly re-apply a set of actions to a different range. You can also star the most frequent features to have access to your favorites at any time. When you import data from different sources or share the same spreadsheet with colleagues, it becomes critical to bring it in order in the shortest time possible. Even such simple tasks as deleting all notes from your sheet can waste a lot of time. Power Tools helps you do this in a click.

Power Tools add-on cuts the clicks on repeated tasks and brings features for organizing and unifying data in Google Sheets. Extra spaces, formulas and data in the wrong format are among many of the issues the add-on deals with: - Take advantage of the new smart toolbar with handy assistants: insert or delete cells and shift adjacent data, change case, or swap values. - Click once to AutoSum numbers in every row or column; sum and count cells by color. - Search all selected sheets for certain values, formulas, notes, and hyperlinks; see a list of found entries, export or replace them in a click. - Get "Text to columns" feature: split values in a column by any delimiter, string, or by position. - Automate some routine tasks: add or remove text by position, transform formulas, change formula reference type, export range to XML or JSON. - Bring order to your sheet: delete unwanted characters, types of data, and clean up formatting. - Get every needed data tool in one place: remove duplicates or bring them to one row, compare and merge sheets, randomize data, and much more. The add-on keeps history of the recent operations at hand so that you can quickly re-apply a set of actions to a different range. You can also star the most frequent features to have access to your favorites at any time. When you import data from different sources or share the same spreadsheet with colleagues, it becomes critical to bring it in order in the shortest time possible. Even such simple tasks as deleting all notes from your sheet can waste a lot of time. Power Tools helps you do this in a click.

Power Tools add-on cuts the clicks on repeated tasks and brings features for organizing and unifying data in Google Sheets. Extra spaces, formulas and data in the wrong format are among many of the issues the add-on deals with: - Take advantage of the new smart toolbar with handy assistants: insert or delete cells and shift adjacent data, change case, or swap values. - Click once to AutoSum numbers in every row or column; sum and count cells by color. - Search all selected sheets for certain values, formulas, notes, and hyperlinks; see a list of found entries, export or replace them in a click. - Get "Text to columns" feature: split values in a column by any delimiter, string, or by position. - Automate some routine tasks: add or remove text by position, transform formulas, change formula reference type, export range to XML or JSON. - Bring order to your sheet: delete unwanted characters, types of data, and clean up formatting. - Get every needed data tool in one place: remove duplicates or bring them to one row, compare and merge sheets, randomize data, and much more. The add-on keeps history of the recent operations at hand so that you can quickly re-apply a set of actions to a different range. You can also star the most frequent features to have access to your favorites at any time. When you import data from different sources or share the same spreadsheet with colleagues, it becomes critical to bring it in order in the shortest time possible. Even such simple tasks as deleting all notes from your sheet can waste a lot of time. Power Tools helps you do this in a click.

Power Tools add-on cuts the clicks on repeated tasks and brings features for organizing and unifying data in Google Sheets. Extra spaces, formulas and data in the wrong format are among many of the issues the add-on deals with: - Take advantage of the new smart toolbar with handy assistants: insert or delete cells and shift adjacent data, change case, or swap values. - Click once to AutoSum numbers in every row or column; sum and count cells by color. - Search all selected sheets for certain values, formulas, notes, and hyperlinks; see a list of found entries, export or replace them in a click. - Get "Text to columns" feature: split values in a column by any delimiter, string, or by position. - Automate some routine tasks: add or remove text by position, transform formulas, change formula reference type, export range to XML or JSON. - Bring order to your sheet: delete unwanted characters, types of data, and clean up formatting. - Get every needed data tool in one place: remove duplicates or bring them to one row, compare and merge sheets, randomize data, and much more. The add-on keeps history of the recent operations at hand so that you can quickly re-apply a set of actions to a different range. You can also star the most frequent features to have access to your favorites at any time. When you import data from different sources or share the same spreadsheet with colleagues, it becomes critical to bring it in order in the shortest time possible. Even such simple tasks as deleting all notes from your sheet can waste a lot of time. Power Tools helps you do this in a click.

Set of tools for daily tasks: change case; sum by color; remove duplicates; split, merge, compare, find, clean up data and more. 30-day unconditional money-back guarantee. Available on all your computers. Priority support service Power Tools add-on cuts the clicks on repeated tasks and brings features for organizing and unifying data in Google Sheets. Extra spaces, formulas and data in the wrong format are among many of the issues the add-on deals with: - Take advantage of the new smart toolbar with handy assistants: insert or delete cells and shift adjacent data, change case, or swap values. - Click once to AutoSum numbers in every row or column; sum and count cells by color. - Search all selected sheets for certain values, formulas, notes, and hyperlinks; see a list of found entries, export or replace them in a click. - Get "Text to columns" feature: split values in a column by any delimiter, string, or by position. - Automate some routine tasks: add or remove text by position, transform formulas, change formula reference type, export range to XML or JSON. - Bring order to your sheet: delete unwanted characters, types of data, and clean up formatting. - Get every needed data tool in one place: remove duplicates or bring them to one row, compare and merge sheets, randomize data, and much more. The add-on keeps history of the recent operations at hand so that you can quickly re-apply a set of actions to a different range. You can also star the most frequent features to have access to your favorites at any time. When you import data from different sources or share the same spreadsheet with colleagues, it becomes critical to bring it in order in the shortest time possible. Even such simple tasks as deleting all notes from your sheet can waste a lot of time. Power Tools helps you do this in a click.

Set of tools for daily tasks: change case; sum by color; remove duplicates; split, merge, compare, find, clean up data and more. 30-day unconditional money-back guarantee. Available on all your computers. Priority support service Power Tools add-on cuts the clicks on repeated tasks and brings features for organizing and unifying data in Google Sheets. Extra spaces, formulas and data in the wrong format are among many of the issues the add-on deals with: - Take advantage of the new smart toolbar with handy assistants: insert or delete cells and shift adjacent data, change case, or swap values. - Click once to AutoSum numbers in every row or column; sum and count cells by color. - Search all selected sheets for certain values, formulas, notes, and hyperlinks; see a list of found entries, export or replace them in a click. - Get "Text to columns" feature: split values in a column by any delimiter, string, or by position. - Automate some routine tasks: add or remove text by position, transform formulas, change formula reference type, export range to XML or JSON. - Bring order to your sheet: delete unwanted characters, types of data, and clean up formatting. - Get every needed data tool in one place: remove duplicates or bring them to one row, compare and merge sheets, randomize data, and much more. The add-on keeps history of the recent operations at hand so that you can quickly re-apply a set of actions to a different range. You can also star the most frequent features to have access to your favorites at any time. When you import data from different sources or share the same spreadsheet with colleagues, it becomes critical to bring it in order in the shortest time possible. Even such simple tasks as deleting all notes from your sheet can waste a lot of time. Power Tools helps you do this in a click.

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.

Search in values, formulas, notes, hyperlinks in all sheets at once. Get the list with the found entries and replace them in a click Use this simple add-on for advanced search in your google spreadsheet. Find and replace text within a formula, check links hidden behind the display text, search within notes, and look for values at the same time. You can search and replace within a column by simply selecting the necessary range of data, or choose to scan any selected sheets. The add-on will display the list of all found records organized by sheet and take you to any found cell in a click. It's easy to use and it offers all you need to discover the necessary data: Look at values, formulas, notes, and links simultaneously. Find and replace in a single column or search everywhere in the spreadsheet. Get all matches listed in the sidebar, navigate to any entry in a click. Replace all or only the selected records. Export the found values or the entire rows that contain them. Advanced Find and Replace add-on will help you complete any substitutions in your sheets in seconds.

Search in values, formulas, notes, hyperlinks in all sheets at once. Get the list with the found entries and replace them in a click Use this simple add-on for advanced search in your google spreadsheet. Find and replace text within a formula, check links hidden behind the display text, search within notes, and look for values at the same time. You can search and replace within a column by simply selecting the necessary range of data, or choose to scan any selected sheets. The add-on will display the list of all found records organized by sheet and take you to any found cell in a click. It's easy to use and it offers all you need to discover the necessary data: Look at values, formulas, notes, and links simultaneously. Find and replace in a single column or search everywhere in the spreadsheet. Get all matches listed in the sidebar, navigate to any entry in a click. Replace all or only the selected records. Export the found values or the entire rows that contain them. Advanced Find and Replace add-on will help you complete any substitutions in your sheets in seconds.

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.

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.