SOLVED

teams and bulk adding of members

%3CLINGO-SUB%20id%3D%22lingo-sub-1587997%22%20slang%3D%22en-US%22%3Eteams%20and%20bulk%20adding%20of%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1587997%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20set%20up%20a%20new%20team%20or%20a%20channel%20under%20a%20team%2C%20I%20noticed%20that%20I%20have%20to%20add%20each%20name%20one%20at%20a%20time.%20It's%20really%20tedious%2C%20and%20it%20seems%20like%20an%20easy%20add%20just%20to%20cut%20and%20paste%20a%20bunch%20of%20emails%20from%20a%20spreadsheet%20into%20this%20(you%20can%20do%20this%20in%20outlook%20to%20send%20to%20a%20large%20distro).%20Why%20are%20bulk%20adds%20in%20teams%20so%20difficult%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1587997%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMembers%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETeams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1588032%22%20slang%3D%22en-US%22%3ERe%3A%20teams%20and%20bulk%20adding%20of%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1588032%22%20slang%3D%22en-US%22%3EMultiple%20Uservoices%20open%20for%20this%2C%20including%20this%20one%20here%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F38483002-bulk-add-team-members-via-csv-file%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F38483002-bulk-add-team-members-via-csv-file%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20be%20able%20to%20bulk%20add%20via%20CSV%3CBR%20%2F%3E%3CBR%20%2F%3EAnother%20way%20you%20can%20do%20it%20today%2C%20if%20you%20are%20an%20administrator%20and%20now%20how%2C%20is%20Powershell.%20You%20can%20do%20this%20with%20the%20Teams%20Powershell%20module.%20Lots%20of%20guides%20online%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20that%20answers%20your%20question%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chris%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1588123%22%20slang%3D%22en-US%22%3ERe%3A%20teams%20and%20bulk%20adding%20of%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1588123%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F169605%22%20target%3D%22_blank%22%3E%40Christopher%20Hoard%3C%2FA%3E%26nbsp%3B%2C%20thanks%20for%20the%20guidance.%20The%20solution%20doesn't%20help%20me%20since%20I'm%20not%20an%20admin%20(which%20i%20should%20have%20specified).%20Good%20to%20know%20that%20others%20have%20found%20this%20issue%20before%20and%20that%20it%20is%20on%20the%20radar.%20Poor%20that%20MS%20still%20has%20not%20fixed.%20It%20is%20alarming%20that%20a%20long-held%20feature%20is%20mysteriously%20dropped.%20At%20least%20I%20have%20peace%20of%20mind%20that%20a%20ton%20of%20time%20wasn't%20truly%20wasted%20for%20not%20knowing%20how%20to%20use%20the%20feature%2C%20but%20merely%20because%20the%20feature%20did%20not%20exist.%20Too%20many%20competing%20offerings%20get%20these%20details%20right.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1728879%22%20slang%3D%22en-US%22%3ERe%3A%20teams%20and%20bulk%20adding%20of%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1728879%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F759065%22%20target%3D%22_blank%22%3E%40ericxlin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20Add%20Multiple%20Members%20In%20Microsoft%20Teams%20in%20One%20Go%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2F9EVBc_J4yR8%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2F9EVBc_J4yR8%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2081182%22%20slang%3D%22en-US%22%3ERe%3A%20teams%20and%20bulk%20adding%20of%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2081182%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F759065%22%20target%3D%22_blank%22%3E%40ericxlin%3C%2FA%3E%26nbsp%3BI%20have%20written%20a%20blog%20and%20developed%20a%20small%20script%20to%20do%20this%20easily.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fgihanblog.netlify.app%2Fposts%2F2020-08-19%2Fadd-bulk-users-to-teams%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fgihanblog.netlify.app%2Fposts%2F2020-08-19%2Fadd-bulk-users-to-teams%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2173244%22%20slang%3D%22en-US%22%3ERe%3A%20teams%20and%20bulk%20adding%20of%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2173244%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F759065%22%20target%3D%22_blank%22%3E%40ericxlin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Guys%3B%20trying%20some%20of%20your%20solutions.%3C%2FP%3E%3CP%3Esadly%20every%20solution%20is%20focused%20on%20adding%20emails%20%3B%20on%20my%20case%20I%20have%20names%20of%20user%20from%20company(600%20names)%20and%20no%20emails.%3C%2FP%3E%3CP%3Estill%20searching%20for%20a%20way.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2258820%22%20slang%3D%22en-US%22%3ERe%3A%20teams%20and%20bulk%20adding%20of%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2258820%22%20slang%3D%22en-US%22%3E%3CP%3Etry%20to%20copy%20the%20names%20to%20outlook%20email%2C%20and%20you%20click%20the%20%22check%20name%22.%20And%20then%2C%20you%20should%20have%20the%20email%20addresses%20for%20these%20names.%20And%20you%20can%20use%20the%20email%20address%20for%20bulk%20add%20in%20MS%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F981584%22%20target%3D%22_blank%22%3E%40omarsaid980%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2259632%22%20slang%3D%22en-US%22%3ERe%3A%20teams%20and%20bulk%20adding%20of%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2259632%22%20slang%3D%22en-US%22%3EThank%20you%2C%20this%20was%20exactly%20what%20I%20needed!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2638344%22%20slang%3D%22en-US%22%3ERe%3A%20teams%20and%20bulk%20adding%20of%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2638344%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F169605%22%20target%3D%22_blank%22%3E%40Christopher%20Hoard%3C%2FA%3E%26nbsp%3B%20this%20site%20is%20no%20longer%20active.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2638892%22%20slang%3D%22en-US%22%3ERe%3A%20teams%20and%20bulk%20adding%20of%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2638892%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F299520%22%20target%3D%22_blank%22%3E%40missyllane%3C%2FA%3E%26nbsp%3BUserVoice%20is%20temporarily%20down%20and%20will%20be%20up%20again%20for%20some%20time%20before%20Microsoft%20migrate%20to%20the%20new%20feature%20request%20platform.%20As%20of%20now%20instead%20of%20trying%20to%20vote%20on%20the%20linked%20request%20you%20can%20use%20the%20above%20solution%20provided%20in%20the%20post%20with%20a%20video%20link%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2643345%22%20slang%3D%22en-US%22%3ERe%3A%20teams%20and%20bulk%20adding%20of%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2643345%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F551905%22%20target%3D%22_blank%22%3E%40ChristianBergstrom%3C%2FA%3E%20Thanks%20for%20the%20reply.%20Sadly%20that%20must%20be%20specific%20to%20a%20special%20type%20of%20group.%20I%20do%20not%20have%20the%20ability%20to%20%22Bulk%20Import%22%20as%20the%20video%20suggests.%20That%20is%20the%20very%20request%20I%20am%20asking%20for.%20Is%20there%20something%20special%20about%20how%20that%20group%20was%20configured%20that%20allows%20for%20that%20feature%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2643827%22%20slang%3D%22en-US%22%3ERe%3A%20teams%20and%20bulk%20adding%20of%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2643827%22%20slang%3D%22en-US%22%3EYou%20can%20%E2%80%9Dbulk%20add%E2%80%9D%20by%20using%20groups%20today%2C%20if%20users%20outside%20of%20your%20org.%20add%20the%20Chrome%20extension%20and%20copy%2Fpaste%20as%20the%20video%20instructs.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2646173%22%20slang%3D%22en-US%22%3ERe%3A%20teams%20and%20bulk%20adding%20of%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2646173%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F588790%22%20target%3D%22_blank%22%3E%40ChristianJBergstrom%3C%2FA%3E%26nbsp%3BI%20appreciate%20you%20following%20up%20with%20me.%26nbsp%3B%20I%20cannot%20find%20this%20extension%20on%20the%20web%20store.%26nbsp%3B%20It%20seems%20it%20may%20not%20be%20available%20any%20more%3F%26nbsp%3B%20I%20found%20another%20video%20showing%20this%20direct%20link%3A%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fchrome.google.com%2Fwebstore%2Fdetail%2Frefined-mircosoft-teams%2Fbipffdldhfcecjhcgklheahpkocojfk%3Fhl%3Den%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fchrome.google.com%2Fwebstore%2Fdetail%2Frefined-mircosoft-teams%2Fbipffdldhfcecjhcgklheahpkocojfk%3Fhl%3Den%3C%2FA%3E%26nbsp%3BI've%20searched%20as%20many%20ways%20as%20I%20can%20find.%26nbsp%3B%20This%20was%20the%20only%20entry%20I%20could%20find%20in%20ChromeStats...%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22missyllane_0-1628869659576.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303092i4F8E9BBF449B2087%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22missyllane_0-1628869659576.png%22%20alt%3D%22missyllane_0-1628869659576.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20appreciate%20any%20guidance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2702689%22%20slang%3D%22en-US%22%3ERe%3A%20teams%20and%20bulk%20adding%20of%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2702689%22%20slang%3D%22en-US%22%3EPerhaps%20you%20can%20use%20the%20team%20code%20to%20let%20people%20join%20the%20team%20%3F%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DTZ_eTpQSjHY%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DTZ_eTpQSjHY%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2705164%22%20slang%3D%22en-US%22%3ERe%3A%20teams%20and%20bulk%20adding%20of%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2705164%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F759065%22%20target%3D%22_blank%22%3E%40ericxlin%3C%2FA%3E%26nbsp%3Bhave%20you%20thought%20about%20using%20Power%20Automate.%3C%2FP%3E%3COL%3E%3CLI%3ECreate%20a%20table%20in%20a%20Excel%20sheet%20with%20your%20list%20of%20email%20addresses%20to%20be%20added%20to%20the%20team%3C%2FLI%3E%3CLI%3ECreate%20flow%20as%20described%20below%3C%2FLI%3E%3CLI%3EGet%20the%20list%20of%20rows%20from%20the%20excel%20sheet%20and%20table%3C%2FLI%3E%3CLI%3EAdd%20member%20to%20a%20Team%20and%20select%20your%20team%20(this%20will%20automatically%20add%20the%20Apply%20to%20each%20step.%20This%20will%20repeat%201%20to%20N%20times%20for%20each%20row%20of%20the%20Excel%20sheet%20and%20add%20member%20to%20Team)%3C%2FLI%3E%3CLI%3EThen%20run%20flow%20and%20the%20users%20in%20the%20list%20are%20added%20to%20the%20team%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22NikkiChapple_0-1630454629532.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F307122i74B5B03651C50EDC%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22NikkiChapple_0-1630454629532.png%22%20alt%3D%22NikkiChapple_0-1630454629532.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2709624%22%20slang%3D%22en-US%22%3ERe%3A%20teams%20and%20bulk%20adding%20of%20members%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2709624%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F950925%22%20target%3D%22_blank%22%3E%40NikkiChapple%3C%2FA%3E%26nbsp%3B%20This%20worked%20GREAT!%26nbsp%3B%20Thank%20you%20soo%20much!%26nbsp%3B%20I%20have%20multiple%20projects%20expecting%20me%20to%20bulk%20load%20large%20team%20members%20as%20we%20migrate%20our%20activities%20into%20the%20Teams%20platform.%26nbsp%3B%20This%20has%20enabled%20me%20to%20go%20forward%20without%20waiting%20for%20a%20corporate%20administrator's%20support.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

When I set up a new team or a channel under a team, I noticed that I have to add each name one at a time. It's really tedious, and it seems like an easy add just to cut and paste a bunch of emails from a spreadsheet into this (you can do this in outlook to send to a large distro). Why are bulk adds in teams so difficult?

15 Replies
best response confirmed by adam deltinger (MVP)
Solution
Multiple Uservoices open for this, including this one here

https://microsoftteams.uservoice.com/forums/555103-public/suggestions/38483002-bulk-add-team-members...

To be able to bulk add via CSV

Another way you can do it today, if you are an administrator and now how, is Powershell. You can do this with the Teams Powershell module. Lots of guides online

Hope that answers your question

Best, Chris

@Christopher Hoard , thanks for the guidance. The solution doesn't help me since I'm not an admin (which i should have specified). Good to know that others have found this issue before and that it is on the radar. Poor that MS still has not fixed. It is alarming that a long-held feature is mysteriously dropped. At least I have peace of mind that a ton of time wasn't truly wasted for not knowing how to use the feature, but merely because the feature did not exist. Too many competing offerings get these details right.

@ericxlin 

How to Add Multiple Members In Microsoft Teams in One Go:

https://youtu.be/9EVBc_J4yR8

🌟if the extension is not available in chrome then here is the alternative method here: https://youtu.be/tjzgpNUiNgkThis video shows you How to add multiple ...

@ericxlin I have written a blog and developed a small script to do this easily.

https://gihanblog.netlify.app/posts/2020-08-19/add-bulk-users-to-teams

@ericxlin 

Hi Guys; trying some of your solutions.

sadly every solution is focused on adding emails ; on my case I have names of user from company(600 names) and no emails.

still searching for a way.

try to copy the names to outlook email, and you click the "check name". And then, you should have the email addresses for these names. And you can use the email address for bulk add in MS@omarsaid980 

Thank you, this was exactly what I needed!

@Christopher Hoard  this site is no longer active.

@missyllane UserVoice is temporarily down and will be up again for some time before Microsoft migrate to the new feature request platform. As of now instead of trying to vote on the linked request you can use the above solution provided in the post with a video link attached.

@ChristianBergstrom Thanks for the reply. Sadly that must be specific to a special type of group. I do not have the ability to "Bulk Import" as the video suggests. That is the very request I am asking for. Is there something special about how that group was configured that allows for that feature?
You can ”bulk add” by using groups today, if users outside of your org. add the Chrome extension and copy/paste as the video instructs.

@ChristianJBergstrom I appreciate you following up with me.  I cannot find this extension on the web store.  It seems it may not be available any more?  I found another video showing this direct link:  https://chrome.google.com/webstore/detail/refined-mircosoft-teams/bipffdldhfcecjhcgklheahpkocojfk?hl... I've searched as many ways as I can find.  This was the only entry I could find in ChromeStats... 

missyllane_0-1628869659576.png

I appreciate any guidance.

Perhaps you can use the team code to let people join the team ?
https://www.youtube.com/watch?v=TZ_eTpQSjHY

@ericxlin have you thought about using Power Automate.

  1. Create a table in a Excel sheet with your list of email addresses to be added to the team
  2. Create flow as described below
  3. Get the list of rows from the excel sheet and table
  4. Add member to a Team and select your team (this will automatically add the Apply to each step. This will repeat 1 to N times for each row of the Excel sheet and add member to Team)
  5. Then run flow and the users in the list are added to the team

NikkiChapple_0-1630454629532.png

 

 

@NikkiChapple  This worked GREAT!  Thank you soo much!  I have multiple projects expecting me to bulk load large team members as we migrate our activities into the Teams platform.  This has enabled me to go forward without waiting for a corporate administrator's support.