The sorting in the Excel file has no effect on the layout of the imported diagram. Indeed, the layout is based on the structure of the diagram only. (In this context, structure means "which elements are connected".)
If you want to emphasize elements by their connection count, use "Tools" -> "Centrality Measures" with default values.
Aside from the "Centrality Measures" tool, yEd does not offer much in the way of automated structure (or content) analysis.