Azure Machine Learning Studio: how to add a dataset from a local Excel file?

Question

Despite prominent how-to posts on how to add datasets to Azure Machine Learning that say Excel is supported when I actually go to add a dataset and select a local Excel file, there's no option for "Excel" in the required datatype property dropdown. I'm surprised that Azure wouldn't support Excel (right?) - am I missing something?

Answer 1

You can upload your excel file into CSV format. You are not missing out on anything. Just that CSV files are more easy to work with but does not tamper your excel format at all.