The CSV file should be edited in Notepad so that the double quotes will be retained. The following is the format that should be used for adding guest accounts to collections via CSV file.
"first.last_domain.com#EXT#@tenant.onmicrosoft.com"
Once the file has been prepared, follow the steps below to populate the collection.