Read the

Data Quality for Microsoft Excel Guide

to learn how you can apply data quality rules to data in Microsoft Excel worksheets. The rules perform data quality operations such as parsing, cleansing, and standardization. To apply the rules, you run data quality services through Data Quality for Microsoft Excel.