ADX Frameworks | Excel add-ins and Outlook tools - AbleBits
Excel add-ins and Outlook tools - Ablebits: 100+ professional tools for Excel, Outlook, Google Sheets and Docs. Download any add-in for free and accomplish your tasks quickly and impeccably. This collection of smart tools will automate most of your daily tasks in Excel and increase your productivity at least by 50%! It's 15 years of experience with Office development embodied in the perfect code of solutions that work flawlessly on all Excel versions and all datasets.
Remove Duplicates add-on for Google Sheets, 12-month subscription
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.
Remove Duplicates add-on for Google Sheets, 12-month subscription | ADX Frameworks
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.
Combine Sheets add-on for Google Sheets, 12-month subscription
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 Sheets add-on for Google Sheets, 12-month subscription | ADX Frameworks
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.
Merge Values add-on for Google Sheets, 12-month subscription
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.
Merge Values add-on for Google Sheets, 12-month subscription | ADX Frameworks
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.
Merge Sheets add-on for Google Sheets, 12-month subscription
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.
Merge Sheets add-on for Google Sheets, 12-month subscription | ADX Frameworks
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.
Combine Sheets add-on for Google Sheets, 1-month subscription
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 Sheets add-on for Google Sheets, 1-month subscription | ADX Frameworks
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.
Advanced Find and Replace for Google Sheets, 12-month subscription
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.
Advanced Find and Replace for Google Sheets, 12-month subscription | ADX Frameworks
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.
Random Generator for Google Sheets, 12-month subscription
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.
Random Generator for Google Sheets, 12-month subscription | ADX Frameworks
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.
Split Names add-on for Google Sheets, 12-month subscription
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!
Split Names add-on for Google Sheets, 12-month subscription | ADX Frameworks
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 for Google Sheets, 12-month subscription
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 for Google Sheets, 12-month subscription | ADX Frameworks
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 for Google Sheets, Lifetime subscription
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 for Google Sheets, Lifetime subscription | ADX Frameworks
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 for Google Sheets, 1-month subscription
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.
Power Tools add-on for Google Sheets, 1-month subscription | ADX Frameworks
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.
Remove Duplicates add-on for Google Sheets, Lifetime subscription
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.
Remove Duplicates add-on for Google Sheets, Lifetime subscription | ADX Frameworks
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.
Advanced Find and Replace for Google Sheets, Lifetime subscription
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.
Advanced Find and Replace for Google Sheets, Lifetime subscription | ADX Frameworks
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.
Combine Sheets add-on for Google Sheets, Lifetime subscription
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 Sheets add-on for Google Sheets, Lifetime subscription | ADX Frameworks
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.
Merge Sheets add-on for Google Sheets, Lifetime subscription
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.
Merge Sheets add-on for Google Sheets, Lifetime subscription | ADX Frameworks
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.
Merge Values add-on for Google Sheets, Lifetime subscription
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.
Merge Values add-on for Google Sheets, Lifetime subscription | ADX Frameworks
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.
Random Generator for Google Sheets, Lifetime subscription
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.
Random Generator for Google Sheets, Lifetime subscription | ADX Frameworks
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.
Split Names add-on for Google Sheets, Lifetime subscription
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!
Split Names add-on for Google Sheets, Lifetime subscription | ADX Frameworks
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!
Ablebits Text Toolkit 2018 for Microsoft Excel
With this add-in for Microsoft Excel you can quickly clean data imported from an external date source and get it to the format convenient for further analysis. In just a couple of clicks you can: Trim leading, trailing spaces and excess spaces between words, Change text case to Proper, UPPER, or lower, Convert numbers in the text format to the number format, Remove or replace unwanted and non-printing characters, Split cell contents, Add any text to the selected cells, Extract text and numbers, Count characters and words in Excel. The add-in works with Microsoft Excel 2016 32-bit and 64-bit, 2013, 2010, and 2007.
Ablebits Merge Tables Wizard 2018 for Microsoft Excel
Merge Tables Wizard for Excel add-in lets you update your main table with the records from another worksheet. It perfectly matches and merges data from 2 Excel lists in seconds. Update columns in your main table or add new columns from the lookup list. Add non-matching rows to the end of your master table. Paste additional matches from the lookup table. Match by one or more key columns. Mark the changes in the Status column or color the updated cells.
Ablebits Merge Duplicates Wizard 2018 for Microsoft Excel
Merge Duplicates Wizard merges data from multiple duplicate rows into 1 quickly and perfectly. It takes just 3 simple steps to combine all values from identical rows based on a selected key column or several columns. The wizard can join all entries or pull unique data only skipping duplicates and empty cells. Here's what makes the Merge Duplicates Wizard stand out: A handy wizard swiftly merges duplicate rows in the entire table or a selected range. The wizard can merge only unique values ignoring duplicates and skipping empty cells. You can choose one or several key columns as your unique identifier. You can specify a different delimiter for each column you want to merge. The add-in works with Microsoft Excel 2016 32-bit and 64-bit, 2013, 2010, 2007.
Ablebits Merge Cells 2018 for Microsoft Excel
Use Merge Cells Wizard every time you need to place values from several Excel cells to one cell, to merge row by row, column by column. If the selection contains multiple data values, Merge Cells Wizard will help you avoid loosing data in Microsoft Excel. Whole columns and rows can be merged with a click. With Merge Cells Wizard for Microsoft Excel you also can: Separate data with any separator you like (e.g. line break). Merge multiple ranges (even non adjacent) and place the results to the selected cell. Clear the cells whose values have been merged. Merge all areas in the selection. The add-in works with Microsoft Excel 2016 32-bit and 64-bit, 2013, 2010, and 2007.
Ablebits Duplicate Remover Wizard 2018 for Microsoft Excel
With Duplicate Remover for Microsoft Excel you can easily remove duplicates from your Excel worksheets or find unique entries. Instantly find duplicates in an Excel sheet. Compare two Excel sheets and remove dupes. Choose one or several columns for comparison. Delete all duplicated rows; select and color found entries; copy or move dupes to another location. The intuitive and user-friendly interface makes your work with the add-in pleasant and easy. The add-in works with Microsoft Excel 2016 32-bit and 64-bit, 2013, 2010, and 2007.
Ablebits Consolidate Worksheets Wizard 2018 for Microsoft Excel
Consolidate Worksheets Wizard for Microsoft Excel quickly combines data from multiple worksheets into one. This smart tool provides you with a number of consolidation options to choose from. You can merge data from one or several workbooks and csv files without opening them, create summary reports, copy multiple worksheets to one large table, consolidate worksheets by name and more. This smart tool gives you flexibility in data consolidation and allows choosing additional options that suit you best: Select any number of Excel files for consolidation. Combine data from the selected ranges into one worksheet. Copy data from the selected ranges to one spreadsheet. Copy sheets in each workbook to one sheet. Place the resulting worksheets into one Excel file. Consolidate worksheets with the same name to one sheet. Copy the selected spreadsheets to one Excel workbook. Paste all, only values or links to source data into the resulting table. Preserve formatting of the selected ranges. Separate the copied ranges by a blank row. Copy the results to a new workbook, new worksheet or select custom location. If you deal with numerous worksheets in Excel 2016, 2013, 2010, or 2007 that need data consolidation, Consolidate Worksheets Wizard is the right tool for you.
Ablebits Add-ins Collection for Microsoft Outlook
Boost your email effectivity with Outlook Add-ins Collection Adding CC and BCC addresses, typing the same text over and over again, checking and tracing important emails, communicating with customers all over the world and figuring out email delivery issues. We know how to make these burdensome and time-consuming tasks easy and fun. The Add-ins Collection for Microsoft Outlook contains 6 smart tools that will improve your inbox productivity: Auto BCC, Template Phrases, Outgoing Email Checker, Important Mail Alert, Sender's Time Zone, Email Headers Analyzer. Just download and install the fully-functional trial version of Add-ins Collection to see your Outlook at its best.
AbleBits Ultimate Suite 2018 for Microsoft Excel, Business edition
Ultimate Suite for Excel contains 60+ professional tools designed to make a huge difference to your daily work with Excel 2016, 2013-2007. Manipulate data effortlessly. The Ultimate Suite solutions are built to improve your experience with such tasks as matching and merging worksheets, generating random numbers, removing duplicates, consolidating multiple files, cleaning imported data and many more. Created to be really simple-to-understand, our tools reliably complete tedious and repetitive tasks, so you2"re likely to start using our add-ins more often than the standard Excel features. Ultimate Suite comes with a list of solutions that we continue to renew and improve. If you manipulate multiple data tables in Excel on daily basis, the suite tools will make keeping up with them smarter.
AbleBits Ultimate Suite 2018 for Microsoft Excel
The AbleBits Ultimate Suite for Microsoft Excel a complete set of 60+ professional tools, which automate many repetitive and time-consuming tasks that Excel users have to perform daily. The Ultimate Suite includes advanced tools for professional data management as well as simple one-click utilities, which makes it an ideal product both for experienced users and beginners. Each add-in was designed with a particular task in mind and offers an amazingly simple way to cope with a variety of complex challenges.
AbleBits Silent BCC for Microsoft Outlook
If you want to monitor every e-mail that leaves your company, try Silent BCC for Outlook. Once installed, the plug-in will deliver you BCC copies of all messages sent from all user accounts of a PC. E-mail senders will never know that a BCC copy was sent from their machines. They will not find Silent BCC in their Outlook, nor will they ever see a BCC address in Sent Items. The Silent BCC for Outlook leaves no traces of its work at all. It is absolutely invisible in Outlook and everywhere else in the system, there is no user interface for the user to switch off the plug-in or alter your monitoring settings. You can tweak the add-in to be copied on every outgoing e-mail or allow exceptions. The Silent BCC plug-in works for Microsoft Outlook 2010, Outlook 2007, Outlook 2003, Outlook XP (2002), Outlook 2000.
AbleBits Template Phrases for Microsoft Outlook
With this handy plug-in for Outlook you need just a mouse click to insert frequently-typed phrases into your e-mail messages. The Template Phrases pane is built into the right part of the message window letting you see all your phrases at a glance organized in a multi-level tree structure. The add-in provides you a number of advanced features to streamline your email responses: Store text formating, pictures, attachments in you templates. Support of macros in a template. You get a pretty good set of macros to automatically add attachments to your email messages, to fill in To, CC, BCC or Subject fields, to request Read or Delivery receipts etc. Shared templates option. You can save your templates somewhere on a network server and let your colleagues use them. Quick search in all templates. You simply switch to the Search tab and type the keywords. As you type, all templates containing this word, or its part, appear in the Template Phrases pane. Favorites. This tab lets you arrange the most frequently used templates so that you can pick the needed one in an instant. Shortcuts. Assign shortcuts to most often used templates or have a certain template automatically inserted into all new emails, replies or forwards. Recently used tab lets you see the most recently used templates at a glance. Export / import features allow you to access your templates on several PCs. The plug-in works with Microsoft Outlook 2016 32-bit and 64-bit, 2013, 2010, and 2007.
AbleBits Sender's Time Zone for Microsoft Outlook
Sender's Time Zone is a plug-in for Microsoft Outlook that displays the sender's current time and your time zone difference when you read or reply to an Outlook e-mail message. You see the time stamp of the message sender at a glance. The add-in's pane is built-in into the Outlook message window. No setting and no configuring is required. The plug-in works with Microsoft Outlook 2016 32-bit and 64-bit, 2013, 2010, and 2007.
AbleBits Outgoing Email Checker for Microsoft Outlook
Outgoing Email Checker for Microsoft Outlook is an plug-in that will verify your messages before sending them according to the specified rules. It is a kind of reminder add-in that will alert you each time the condition you specified for certain rule is not met. This helpful tool lets you avoid silly emailing mistakes like forgetting to add an attachment or using the wrong account and gives you a chance to approve the letter after you hit the Send button. When there are dozens of things to review - our handy reminder add-in can become your life saver: Add attachment if the email contains certain words or is sent top certain recipients. Alert if the message size is greater than specified. Make sure the message contains a salutation a proper closing. Make sure the "To:" or "CC:" field contains certain words if sent through particular account.
AbleBits Link Checker for Microsoft Word
This Link Checker for Microsoft Word will help you check and manage internal hyperlinks and cross-references in your Word 2016 - 2007 documents. Use it every time you need to ensure that all links in your document are valid. You can choose to find all or only suspicious links and cross-references and Link Checker will immediately display them for you in a tree view. You can see where a particular link is located and where it leads, edit or delete links directly on the add-in's pane. You can also export the entire list to Word or Microsoft Excel. The add-in works with Microsoft Word 2016 32-bit and 64-bit, 2013, 2010, and 2007.
AbleBits Auto BCC/CC for Microsoft Outlook
Auto BCC for Outlook is an email add-in that creates a BCC and/or a CC copy automatically every time you send mail. All you need is to create simple rules for filling the BCC/CC fields, and Auto BCC does all other work itself. The Auto CC plugin can send a BCC/CC for all outgoing emails, or to the specified addresses only, or if the subject line or the attachment name contains particular words, etc. A BCC will be sent for all outgoing messages, whether it is a new e-mail, an email reply or a forwarded message. With Auto BCC / CC for Microsoft Outlook you can: Create a new rule for auto-filling the CC, BCC fields of a new message with a couple of clicks. Add rule exceptions. Use several keyphrases for each condition. Fill multiple addresses to the CC and BCC fields. Exclude duplicates from the CC and BCC fields. Send CC (carbon copies) and BCC (blind carbon copies) of the same email at a time. Easily edit your existing rules. The plug-in works with Microsoft Outlook 2016 32-bit and 64-bit, 2013, 2010, and 2007.