Skip to main content

XLTools.net Data Cleaning

WavePoint Co. Ltd.
Clean bulk data fast: remove extra spaces, change text case, convert text format to numbers, etc.

After you paste or import external data to Excel, you may need to clean the data from redundant spaces, line breaks or non-printing symbols. If you work with bulk data, manual cell-by-cell changes take long painstaking hours. Data Cleaning App by XLTools will prepare your data in just a few clicks:

• Trim spaces in the beginning and the end of text

• Remove all excess spaces

• Remove line breaks in cells

• Remove non-printing characters

• Change text case to Proper Case, Sentence case, lower case or UPPER CASE

• Convert text to numbers, i.e. values stored as text to number format

• Convert numbers to text, i.e. values stored as numbers to text format

Please note: the operation cannot be undone. Any formulas will be overwritten with values.

Add-in capabilities
When this add-in is used, it
  • Can read and make changes to your document
  • Can send data over the Internet
  • https://az158878.vo.msecnd.net/marketing/Partner_21474839848/Product_42949678390/Asset_5936e8ca-09c6-468e-a721-ce2d487161a4/appdatacleaning1.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474839848/Product_42949678390/Asset_5936e8ca-09c6-468e-a721-ce2d487161a4/appdatacleaning1.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474839848/Product_42949678390/Asset_9d645eb0-a07d-4f5e-b6f1-d4c315fb4341/appdatacleaning2.png