How can I separate columns while reading an excel documents if the original format from excel combines all columns in only one separated by ","?

I have an excel document that has the information of 3 columns in only one separated by ",". I want to separate the columns during the pd.read_excel(). I tried to use usecols but it did not work. I would like also to name the columnus while calling pd.read_excel().

enter image description here

>Solution :

Not sure how your .xlsx file is formatted but it looks you should be using pandas.read_csv() instead. Link here.

So maybe something llike pandas.read_csv(filename, sep=',', names=['Name', 'Number', 'Gender'])