couldn't import data in excel

i was not able to import dataset in excel as shown in excel session1 40:00.couldnt get the option load data and transform data.when i import the dataset in excel ,data displayed in comma based not column based.