Address Assistant
Easily split addresses in one cell into multiple cells. Fix zip codes needing leading zeros.
Data Collection
All of our data-related add-ins for Microsoft Excel, in one discounted bundle.
The Data Collection contains all of our data-related add-ins for Microsoft Excel. You get every add-in listed below to help you do data-related work — sold together as a collection for over 85% savings off the individual prices.
If we add new add-ins or new versions after you purchase, you may download the latest collection for free from your purchase date. The add-ins never expire — only the download link does.
Download an evaluation copy of all the Data Collection add-ins
Sridhar Lyer wrote: “Your Data Collection is just super, apart from saving oodles of time and effort it really gives you the capability to see what data means.”
Add-ins included in this collection
Compare Columns Assistant
Easily compare one or more columns in a list or between lists.
Compare Lists Assistant
Compare lists in Excel and quickly identify the differences.
Colored Cells Sorter
Sort rows based on cell background color.
Consolidation Assistant
Consolidate worksheets from multiple workbooks.
Copy Columns Assistant
Easily copy columns between worksheets based on column titles.
CSV File Creator
Create CSV files the easy way.
Data Assistant
Convert data into a form usable by pivot tables.
Data Cleaner
Eliminate tedious manual cleaning of data.
Data Consolidator
Easily combine many rows of data into a few.
Data Extraction Assistant
Extract data from one worksheet to multiple worksheets based on row entries.
Data Loader
Make Excel data loading easier.
Duplicate Finder & Deleter
Quickly find, copy, and delete duplicates in one list or between two lists.
Filter Assistant
Easily filter your data with just a click of a button.
Find Assistant
Find upward in a list or column versus the downward-only option of Excel.
Hide Columns Assistant
Easily hide the columns you don't want to see so you can focus on the ones you do.
List Searcher
Search lists for matches to key words or phrases.
Lookup Assistant
Match data from one list to another the easy way.
Match and Mark Assistant
Easily compare up to 10 lists all at the same time.
Merge Assistant
Merge (concatenate) multiple cells many different ways.
Name Splitter
Easily split names into individual cell entries.
Pivot Table Assistant
Make using pivot tables easier.
Price List Updater
Easily and quickly update prices or cost between two lists.
Report to Data Assistant
Convert reports to worksheet data.
Row Assistant
Hide or show rows based on many different search criteria.
Row Extractor
Extract rows of data into columns for easy review and printing.
Row to Column Viewer
View all the data on a row at one time!
Sort Assistant
Save and re-use sort settings across worksheets and workbooks.
Text File Importer
Import ASCII or text files with over a million lines!
To make learning and using the Data Collection’s add-ins easy, all come with exercise files and step-by-step instructions for hands-on practice. The exercise files and help files are easily accessed from the opening dialogs, and all of the add-ins are menu driven for ease of use.
The add-ins in our collections do not expire or require renewal after a year; they continue to work for years and years with just the one-time purchase. Only the download link expires.