I suppose you dont get an aswer because its obvious: you export the excel sheet to a txt file (tab delimited) and then introduce the modifications as specified by the manuel of Endnote (see Creating a Tab-Delimited Format) and import it into Endnote.
Best