You need to change the file format of the file chooser dialog to "MS Excel 97/2000/XP (*.xls)" or "MS Excel 2007 XML (*.xlsx)" to import data from Excel into yEd.
How to change the file format in the file chooser dialog is explained in On MacOS can't open .tgf files.