how to create multiple ejabberd accounts

Export that sheet to a simple text file, then edit each line so it looks like this:
ejabberdctl register user1 example.org somepass1

And then execute that batch file in the same dir where you have ejabberdctl.

thanks a lot Mr badlop