Using SSO when trying to import sites during the Office 365 securlet causes an invalid username or password error
Manually import the Office 365 Sharepoint sites
To import your Sites from a CSV format file, click the Select CSV file to upload box, or drag a CSV file into the box, then click Import via CSV.
Note: The CSV file must list the sites with their full URLs but without trailing slashes.
To create a CSV of all the sites on an instance of Office 365 do the following: