As your Sky / Yahoo contacts are not automatically importing as separate contacts in eM Client Contacts section (which sounds like some Sky / Yahoo issue), and you have exported them from your Sky / Yahoo account online to a .CSV file as you advised, then you could either:-
Import them into one of your other “Gmail or Hotmail account contacts” to integrate with those.
Or you couid choose to import them into “Local Folder Contacts” if you don’t want them integrated into your other account contacts.
After you select your .CSV file, make sure you choose the “Contacts folder” when importing.
Note: If you do import them into Local Folder Contacts “after importing”, go to Contacts section in eM Client and make sure Local Folders contacts are checked / ticked so those contacts then appear in the To , Cc, & Bcc line when composing.
If you don’t have Local folders enabled” up to V9, go to “Menu / Settings (Preferences) / General” and enable Show local folders.
Or to show Local Folders in V10, go to “Menu / Settings (Preferences) / General / Folders” and enable Local Folders.
Lastly see @Gary post example on importing a .CSV file and “matching up headings at the end of the import wizard” in the following thread.
.