We need to convert excel files to csv files before transferring it to the HDFS as we get distorted output in hadoop when we do processing directly on excel files.


Please refer the below steps:


Right click on the excel files ---> Select the option properties ------> Click on change -------> Select the option notepad ----> Select the Ok option to convert it to csv format.


Please refer the below screenshot for the above steps: