Home > Excel Business Solutions > Excel Productivity > Data Management > Data Cleansing Share

Data Cleansing

Excel data cleansing for data management


Excel Data Cleansing

Rate this solution:
(3.1/5 from 8 votes)
Data Cleansing screenshot
Data Cleansing for Excel is designed to automate commonly demanded tasks for cleansing data in Excel. The Excel add-in presents a menu of options for interrogating, cleaning, modifying and transforming data for targeted ranges. Data cleansing is fast and automatic allowing to save considerable time and resources for cleaning data in a customized way for analytical purposes, publishing and application integration.

Key features of Data Cleansing for Excel include:
  • Remove extra, leading or trailing spaces in selected columns.
  • Remove all alphabetic characters in selected columns
  • Remove all numeric data in selected columns.
  • Remove special or user defined characters in selected columns.
  • Remove duplicates in data (with option to keep the first instance).
  • Remove unique values from a column.
  • Remove values from one column if they exist in another column.
  • Prevent duplicate entries into specified columns.
  • Color highlight duplicate rows and/or unique rows.
  • Count duplicates in specified column.
  • Compatible with all versions of Excel for Windows.

Try It  Get It

(Pricing is available on the next page)
(Updated on 2019-08-01)

Related Excel Solutions for Data Cleansing

Random SamplingTechnical Analysis  Remove Cell TextData Management  Convert ValuesData Management  Fuzzy MatchingData Management  Unstructured Data ImportData Management  Data Clean Up ToolsTime Saving  Automation Add-insTime Saving  Data ShapingTime Saving  Search Suggestion MatchingTime Saving

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.