CSV file to add members to Yammer group not working

%3CLINGO-SUB%20id%3D%22lingo-sub-52176%22%20slang%3D%22en-US%22%3ECSV%20file%20to%20add%20members%20to%20Yammer%20group%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-52176%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys-%20Apologies%20if%20this%20is%20a%20newbie%20mistake%20but%20it%20used%20to%20be%20easier%20to%20upload%20a%20CSV%20file%20to%20add%20members%20to%20a%20Yammer%20group.%20Now%20it%20seems%20to%20only%20accept%20a%20file%20that%20has%20been%20exported%20from%20Outlook.%20Has%20there%20been%20a%20change%3F%20I%20can%20no%20longer%20upload%20a%20simple%20CSV%20with%20emails.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-52176%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EYammer%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-123381%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20file%20to%20add%20members%20to%20Yammer%20group%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-123381%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20as%20Tom%20said%2C%20it's%20very%20finicky.%20You%20have%20to%20get%20the%20spelling%20of%20the%20headers%20exactly%20right%2C%20and%20there%20can%20be%20no%20spaces%20(including%20trailing%20spaces)%20in%20the%20email%20addresses.%20Make%20sure%20you%20check%20those%20things%2C%20and%20then%20switch%20browsers%20if%20it's%20still%20not%20working.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-122626%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20file%20to%20add%20members%20to%20Yammer%20group%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-122626%22%20slang%3D%22en-US%22%3E%3CP%3EWe're%20all%20newbies%20at%20some%20point.%26nbsp%3B%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8846%22%20target%3D%22_blank%22%3E%40Katie%20O'Leary%3C%2FA%3E%2C%26nbsp%3BOne%20thing%20I%20noticed%20is%20that%20sometimes%20you%20have%20to%20add%20the%20users%20to%20your%20network%20with%20Invite%20Users%20first%2C%20and%20then%20you%20can%20add%20them%20to%20a%20group.%26nbsp%3B%20Try%20that%20and%20let%20us%20know%20how%20it%20works.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F42284%22%20target%3D%22_blank%22%3E%40Hans%20van%20Rijsbergen%3C%2FA%3E%2C%20I've%20seen%20this%20sometimes%20when%20certain%20users%20are%20listed%20in%20the%20Blocked%20Users%20list.%26nbsp%3B%20Also%2C%20I've%20seen%20it%20when%20there%20are%20certain%20users%20which%20are%20%3CU%3E%3CEM%3Esimilar%3C%2FEM%3E%3C%2FU%3E%20to%20users%20in%20the%20Blocked%20Users%20list.%26nbsp%3B%20And%20finally%2C%20I've%20seen%20this%20for%20certain%20people%20with%20no%20explanation%20at%20all.%26nbsp%3B%20Usually%20I%20can%20add%20these%20outliers%20manually.%26nbsp%3B%20Once%20or%20twice%20there%20was%20something%20very%20strange%20with%20the%20user%20object%20(take%20a%20look%20in%20your%20data%20export)%20that%20needed%20corrected%2C%20such%20as%20multiple%20accounts%20sharing%20an%20email%20address.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F65132%22%20target%3D%22_blank%22%3E%40Mark%20Allotey%3C%2FA%3E%2C%20that%20spinning%20wheel%20of%20doom%20(SWoD)%20is%20super%20annoying.%26nbsp%3B%20I've%20found%20it%20to%20be%20a%20browser%20issue%2C%20but%20I%20forget%20which%20one%20works.%26nbsp%3B%20If%20you're%20getting%20the%20SWoD%20in%20IE%2C%20try%20Chrome.%26nbsp%3B%20If%20you're%20getting%20it%20in%20Chrome%2C%20try%20IE.%26nbsp%3B%20Personally%20I%20do%20that%20kind%20of%20stuff%20usually%20in%20Chrome%20Incognito%20Mode%2C%20to%20avoid%20any%20add-ons%20getting%20in%20the%20way.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20functionality%20is%20kind%20of%20old%20so%20it's%20a%20little%20temperamental.%26nbsp%3B%20But%20it's%20a%20life-saver%20as%20compared%20to%20adding%20all%20those%20users%20manually.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-121619%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20file%20to%20add%20members%20to%20Yammer%20group%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-121619%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20struggling%20with%20this%20also.%20I'm%20uploading%20a%20CSV%20file%20that%20contains%26nbsp%3B%3CSTRONG%3EE-Mail%20Address%3C%2FSTRONG%3E%20at%20the%20top%2C%20with%20the%20users'%20email%20addresses%20below.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F22964iFC0779F8BF9D1DC0%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22CSV-fail.PNG%22%20title%3D%22CSV-fail.PNG%22%20%2F%3E%3C%2FSPAN%3EWhen%20I%20go%20to%20Group%20Settings%20%26gt%3B%26nbsp%3B%3CSPAN%3EAdd%20From%20Address%20Book%20(CSV)%20%26gt%3B%20Choose%20File%20(selecting%20CSV%20file)%20%26gt%3B%20Preview%2C%20all%20I%20get%20is%20the%20spinning%20wheel%20of%20doom.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAnyone%20else%20getting%20this%20or%20is%20it%20just%20me%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-58637%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20file%20to%20add%20members%20to%20Yammer%20group%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-58637%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20struggling%20with%20adding%20members%20through%20csv%20(import).%3C%2FP%3E%3CP%3EOut%20of%20list%20with%20hundreds%20of%20people%2C%20all%20in%20the%20same%20tenant%2C%20some%20I%20can't%20add%20.%20It%20seems%20pretty%20random.%3C%2FP%3E%3CP%3EWhen%20adding%20manually%20these%20work%20fine.%20I've%20created%20a%20small%20set%20with%20just%203%20addresses%20of%20which%20one%20is%20%22not%20allowed%22.%20This%26nbsp%3Bgives%20the%20same%20behaviour.%20Any%20clue%20how%20this%20can%20be%20fixed%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20couldn't%20find%20many%20other%20resources%20on%20this%20issue%20unfortunately.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20getting%20back%20to%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHans%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-52260%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20file%20to%20add%20members%20to%20Yammer%20group%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-52260%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Katie%2C%20does%20this%20support%20doc%20help%20at%20all%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F2809170%2Fhow-to-invite-or-add-members-to-a-yammer-group%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F2809170%2Fhow-to-invite-or-add-members-to-a-yammer-group%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20don't%20believe%20anything%20has%20changed%20in%20the%20product.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20anyone%20else%20here%20having%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-760217%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20file%20to%20add%20members%20to%20Yammer%20group%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-760217%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%20need%20to%20export%20from%20outlook%20we%20can%20convert%20excel%20file%20to%20CSV%20while%20converting%20it%20we%20get%204%20different%20option%20of%20csv%20so%20we%20need%20to%20choose%20CSV(Comma%20delimited)%20after%20doing%20this%20try%20uploading%20on%20yammer%20it%20%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123591i6852CD91D05A62C8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22yammer.png%22%20title%3D%22yammer.png%22%20%2F%3E%3C%2FSPAN%3Etake%20very%20much%20less%20time%20of%20course%20don't%20forget%20to%20add%20column%20header%20%22Email%22%20without%20quotes.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1091836%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20file%20to%20add%20members%20to%20Yammer%20group%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1091836%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESame%20issues%20with%20me.%20While%20upload%20.csv%20file%20it%20just%20does%20not%20upload%20except%20spinning%20the%20wheel.%3CBR%20%2F%3EAny%20help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESalik%20Anwar%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1103566%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20file%20to%20add%20members%20to%20Yammer%20group%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1103566%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F123518%22%20target%3D%22_blank%22%3E%40Salik%20Anwar%3C%2FA%3E%26nbsp%3BSee%20above%3A%26nbsp%3B%20%22...%3CSPAN%3Ethat%20spinning%20wheel%20of%20doom%20(SWoD)%20is%20super%20annoying.%26nbsp%3B%20I've%20found%20it%20to%20be%20a%20browser%20issue%2C%20but%20I%20forget%20which%20one%20works.%26nbsp%3B%20If%20you're%20getting%20the%20SWoD%20in%20IE%2C%20try%20Chrome.%26nbsp%3B%20If%20you're%20getting%20it%20in%20Chrome%2C%20try%20IE.%22%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1104494%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20file%20to%20add%20members%20to%20Yammer%20group%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1104494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F123518%22%20target%3D%22_blank%22%3E%40Salik%20Anwar%3C%2FA%3E%26nbsp%3B%2C%20a%20few%20pointers%20%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20find%20that%20there%20is%20a%20maximum%20number%20of%20people%20that%20can%20be%20added%20in%20one%20batch.%20I%20think%20this%20is%20related%20to%20the%20total%20number%20of%20characters%20in%20the%20CSV%20file%2C%20not%20the%20number%20of%20people%20or%20lines.%20So%20if%20you%20have%20a%20domain%20with%20a%20very%20long%20extension%20then%20that%20may%20mean%20you%20can%20add%20fewer%20in%20one%20batch.%20For%20us%2C%20our%20domain%20is%20short%20(%40xxx.com)%20and%20we%20recommend%20that%20batches%20of%20no%20more%20than%20450%20accounts%20are%20added%20at%20once.%20If%20the%20total%20characters%20within%20the%20CSV%20file%20is%20exceeded%20you%20see%20the%20spinning%20wheel%2C%20sadly%2C%20rather%20than%20a%20partial%20load.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20suggest%20that%20if%20you%20have%20multiple%20batches%2C%20allow%205%20minutes%20between%20each%20one.%20I%20can't%20prove%20it%20but%20we%20think%20that%20if%20you%20run%20them%20too%20quickly%2C%20the%20first%20one%20may%20not%20execute%20fully.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20other%20peculiarities%20in%20adding%20by%20batch.%20Almost%20guaranteed%20that%20if%20you%20add%20200%20names%2C%20you%20will%20only%20see%20an%20increase%20of%20%2B180%2C%20not%20200.%20It%20also%20seems%20to%20depend%20if%20the%20group%20is%20marked%20as%20public%20or%20private.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20mentioned%20in%20the%20above%20thread%2C%20the%20other%20common%20mistakes%20are%20not%20having%20%22email%20address%22%20in%20cell%20A1%2C%20and%20not%20saving%20in%20the%20%22correct%22%20CSV%20option%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFinally%2C%20make%20sure%20that%20you%20use%20the%20addresses%20as%20per%20the%20Active%20Directory%20email.%20Many%20people%20often%20have%20their%20primary%20SMTP%20email%20as%20something%20else.%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-1206471%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20file%20to%20add%20members%20to%20Yammer%20group%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1206471%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F6850%22%20target%3D%22_blank%22%3E%40Alan%20Boulter%3C%2FA%3E%26nbsp%3BI%20just%20uploaded%20a%20CSV%20file%20from%20Excel%20in%20Chrome.%20The%20spinning%20wheel%20sowed%20for%20quite%20a%20few%20seconds%2C%20but%20after%20that%20I%20got%20the%20pop-up%20that%20471%20invites%20would%20be%20sent.%20Seems%20to%20work%20fine!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi Guys- Apologies if this is a newbie mistake but it used to be easier to upload a CSV file to add members to a Yammer group. Now it seems to only accept a file that has been exported from Outlook. Has there been a change? I can no longer upload a simple CSV with emails. 

10 Replies
Highlighted

Hey Katie, does this support doc help at all?

 

https://support.microsoft.com/en-us/help/2809170/how-to-invite-or-add-members-to-a-yammer-group

 

I don't believe anything has changed in the product. 

 

Is anyone else here having issue?

Highlighted

I'm struggling with adding members through csv (import).

Out of list with hundreds of people, all in the same tenant, some I can't add . It seems pretty random.

When adding manually these work fine. I've created a small set with just 3 addresses of which one is "not allowed". This gives the same behaviour. Any clue how this can be fixed? 

 

I couldn't find many other resources on this issue unfortunately.

 

Thanks for getting back to me.

 

Hans

Highlighted

I'm struggling with this also. I'm uploading a CSV file that contains E-Mail Address at the top, with the users' email addresses below. 

 

 

CSV-fail.PNGWhen I go to Group Settings > Add From Address Book (CSV) > Choose File (selecting CSV file) > Preview, all I get is the spinning wheel of doom. 

 

Anyone else getting this or is it just me

Highlighted

We're all newbies at some point.  :)

 

@Katie O'Leary, One thing I noticed is that sometimes you have to add the users to your network with Invite Users first, and then you can add them to a group.  Try that and let us know how it works.

 

@Hans van Rijsbergen, I've seen this sometimes when certain users are listed in the Blocked Users list.  Also, I've seen it when there are certain users which are similar to users in the Blocked Users list.  And finally, I've seen this for certain people with no explanation at all.  Usually I can add these outliers manually.  Once or twice there was something very strange with the user object (take a look in your data export) that needed corrected, such as multiple accounts sharing an email address.

 

@Mark Allotey, that spinning wheel of doom (SWoD) is super annoying.  I've found it to be a browser issue, but I forget which one works.  If you're getting the SWoD in IE, try Chrome.  If you're getting it in Chrome, try IE.  Personally I do that kind of stuff usually in Chrome Incognito Mode, to avoid any add-ons getting in the way.  

 

The functionality is kind of old so it's a little temperamental.  But it's a life-saver as compared to adding all those users manually.

Highlighted

Yes, as Tom said, it's very finicky. You have to get the spelling of the headers exactly right, and there can be no spaces (including trailing spaces) in the email addresses. Make sure you check those things, and then switch browsers if it's still not working.

Highlighted

Hi, 

 

No need to export from outlook we can convert excel file to CSV while converting it we get 4 different option of csv so we need to choose CSV(Comma delimited) after doing this try uploading on yammer it yammer.pngtake very much less time of course don't forget to add column header "Email" without quotes.

Highlighted

Hi,

 

Same issues with me. While upload .csv file it just does not upload except spinning the wheel.
Any help?

 

Regards,

 

Salik Anwar

Highlighted

@Salik Anwar See above:  "...that spinning wheel of doom (SWoD) is super annoying.  I've found it to be a browser issue, but I forget which one works.  If you're getting the SWoD in IE, try Chrome.  If you're getting it in Chrome, try IE."

Highlighted

@Salik Anwar , a few pointers :

 

We find that there is a maximum number of people that can be added in one batch. I think this is related to the total number of characters in the CSV file, not the number of people or lines. So if you have a domain with a very long extension then that may mean you can add fewer in one batch. For us, our domain is short (@xxx.com) and we recommend that batches of no more than 450 accounts are added at once. If the total characters within the CSV file is exceeded you see the spinning wheel, sadly, rather than a partial load.   

 

I also suggest that if you have multiple batches, allow 5 minutes between each one. I can't prove it but we think that if you run them too quickly, the first one may not execute fully.

 

There are other peculiarities in adding by batch. Almost guaranteed that if you add 200 names, you will only see an increase of +180, not 200. It also seems to depend if the group is marked as public or private.

 

As mentioned in the above thread, the other common mistakes are not having "email address" in cell A1, and not saving in the "correct" CSV option format.

 

Finally, make sure that you use the addresses as per the Active Directory email. Many people often have their primary SMTP email as something else.

 

 

Highlighted

@Alan Boulter I just uploaded a CSV file from Excel in Chrome. The spinning wheel sowed for quite a few seconds, but after that I got the pop-up that 471 invites would be sent. Seems to work fine!