If your data includes inconsistent types, such as numbers mixed with text in the same column, this automatic step can cause ‘DataFormat.Error: We couldn’t convert to Number’.

Why is my number stored as text in Excel? Excel doesn’t convert numbers written in text into digits if you import data from another source because of the default setting.

“Text analytics” means converting text into conventional data. Once that is done, conventional statistical methods can be used for further analysis.