There seems to be a misunderstanding on how Excel import works. Each row in the edge list "Data Range" will result in an edge in your diagram. All the data in cells in those rows will be associated to those edges. Moreover, for each distinct value in the columns designated as "Column of Source IDs" and "Column of Target IDs" there will be a distinct node in your diagram. If you need to associate data to those nodes, you need a separate data range (which is designated in the "Data Range" setting in section "Node List") where each cell in the column designated as "Column of Node IDs" has a unique value and that value matches one of the values used as source or target ID.
That said, searching for "Excel" with the forum search will turn up lots of questions with answers that include sample Excel import settings. E.g. Relational Entities in excel file to directed graph, Import Excel: Group Name not importing correctly, and Multi-level groups from Excel to name but a few. Moreover, section Import of Excel Files in the yEd Manual does come with an illustrative example as well.
The links in my previous comment do contain samples and screen shots.
If you have a specific question, I am more than happy to try to answer that question. E.g. if you upload a sample spreadsheet and a screen shot of your Excel import settings I will try to correct/adjust your data and settings.
However, I do not think creating an arbitrary example will help - after all the existing examples do not seem to help either.