Attempting to import the sites fails with the red error invalid credentials and a reference number.
The following is required for successful validation of the credentials:
NOTE: There is no difference between methods to active sites while Office 365\Sites - both login and CSV will active updated list of sites in organization.