Importing a list of users from Outlook (or Excel) into SharePoint permissions?

%3CLINGO-SUB%20id%3D%22lingo-sub-1067945%22%20slang%3D%22en-US%22%3EImporting%20a%20list%20of%20users%20from%20Outlook%20(or%20Excel)%20into%20SharePoint%20permissions%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1067945%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20a%20SharePoint%20site%20which%20needs%20to%20be%20shared%20externally%20with%20a%20large%20group%20of%20users.%20Typically%2C%20when%20you%20share%20a%20site%20externally%2C%20you%20enable%20external%20sharing%20and%20simply%20enter%20their%20email%20address%20into%20the%20'share%20site'%20window%20and%20press%20'share'.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you're%20doing%20this%20for%20one%20or%20two%20people%20it's%20no%20problem%2C%20but%20we%20have%20a%20list%20of%20about%20200%20external%20email%20addresses%20which%20need%20to%20be%20added.%20This%20list%20has%20been%20sent%20to%20me%20as%20a%20.msg%20file%20in%20Outlook%2C%20but%20I%20could%20also%20import%20it%20into%20a%20simple%20Excel%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20of%20taking%20a%20big%20list%20of%20external%20email%20addresses%20and%20importing%20them%20into%20SharePoint%20permissions%20groups%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1067945%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1084699%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20a%20list%20of%20users%20from%20Outlook%20(or%20Excel)%20into%20SharePoint%20permissions%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1084699%22%20slang%3D%22en-US%22%3E%3CP%3EI%20faced%20the%20same%20scenario.%20All%20I%20can%20figure%20out%20was%20to%20copy%20all%20the%20email%20address%20into%20Notepadd%2B%2B%2FExcel%20for%20formatting%2C%20and%20then%20just%20copy%20and%20paste%20all%20the%20formatted%20email%20id's%20into%20the%20'share%20site'%20invitation%20area%20and%20press%20'share'.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ESharePoint%20will%20be%20auto-invitations%20for%20all%20the%20external%20users%20if%20you%20opt%20to%20'Send%20an%20email%20invitation'%20at%20the%20time%20of%20sharing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3ENote%3A%3C%2FEM%3E%26nbsp%3BBefore%20sharing%20the%20site%2C%20make%20sure%20all%20the%20external%20domains%20are%20added%20to%20the%20sharing%20list%20through%20Admin%20Portal.%20Else%2C%20you%20will%20receive%20an%20error.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EHope%20this%20helps!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

We have a SharePoint site which needs to be shared externally with a large group of users. Typically, when you share a site externally, you enable external sharing and simply enter their email address into the 'share site' window and press 'share'.

 

When you're doing this for one or two people it's no problem, but we have a list of about 200 external email addresses which need to be added. This list has been sent to me as a .msg file in Outlook, but I could also import it into a simple Excel sheet.

 

Is there any way of taking a big list of external email addresses and importing them into SharePoint permissions groups?

 

Thanks

1 Reply

I faced the same scenario. All I can figure out was to copy all the email address into Notepadd++/Excel for formatting, and then just copy and paste all the formatted email id's into the 'share site' invitation area and press 'share'. 


SharePoint will be auto-invitations for all the external users if you opt to 'Send an email invitation' at the time of sharing.

 

Note: Before sharing the site, make sure all the external domains are added to the sharing list through Admin Portal. Else, you will receive an error.


Hope this helps!