Add or enroll users in Moodle by uploading a spreadsheet/CSV

Quickly create new Moodle accounts by adding users to a spreadsheet, saving the spreadsheet to CSV, then uploading the CSV file to Moodle. Automatically enroll those users into courses in Moodle. Administrator access required.

[@rohanlewis9167]

Thank you. Corona has struck and this was my aid. #2020 #coronavirus #stayhome #staysafe #quaranteam

[@discospiff]

Glad it helped! And yes, wow, what a difference a few weeks makes.

[@johnsoto989]

Thanks so much for uploading this. Really helpful, especially seeing someone go through the process.

[@discospiff]

Thanks, glad it helped! When I did technical training, I used to enroll everyone manually with Moodle's web interface. Then I found the secret about uploading names from a spreadsheet. It made the process much faster/more efficient.

[@mr.ahmedzaidan770]

Thank you so much. It was really helpful.

[@discospiff]

I'm happy to hear it helped! I used this technique a lot when I was in corporate training, and I had to enroll a large class in Moodle at once.

[@MrCliverlong]

Very clear explanation.

[@discospiff]

Glad it helped... thanks!

Thank you very much for your helpful video.

[@discospiff]

Glad it helped! I used this frequently when I enrolled many users in moodle every week.

[@thedancamproductions5831]

Great tutorial sir.. very helpful and very clear :)

[@discospiff]

Thanks for the feedback!

[@cimmeriantower]

How to set the enrollment start and end dates for a student using the csv uploader? In the case that multiple students join a class that is already in session late.

[@MsAnil2009]

when I check with the uploaded user accounts it shows me an error call inscriptive error

[@mnasirkhan8721]

Great job. How can I enroll existing students using CSV file into a brand new course that has already been created? thanks

[@take1nestudios]

Same process + kzbin.info/www/bejne/epbYpn5qq9qii7c

[@laurentiudll]

can i un-enroll a student list from course1 ? students finish first year and i want them out from the course

[@murarivyas5735]

Can we also group these into new cohorts while creating them

[@chancelbakutshu4849]

Thank you, How to add a cohorts ?

[@waelsaegh3123]

Thanks for your simple explanation. can you please tell us how we can connect Moodle with Active Directory server?

[@discospiff]

Rats... I never did that. I wanted to at one employer, but never got to it by the time I left. :)

[@saidalnabirahmani5598]

Thanks you so much.

[@wannassirahma]

Hello sir i want to import an xl file to my android database,,and i can t plz could you help me plz

[@ultimate-acs7868]

This is all OKAY... But what about sign-up a user to moodle from my website? Means, when user click sign-up button on my website and the user's sign-up data will be stored in moodle database. And automatically redirect the user to moodle login page after succesfull registration.

[@discospiff]

That would be the subject of a much longer video.

[@ultimate-acs7868]

@@discospiff Thanks Brandan Sir, only your reply is enough. But coming to my question, can we do like that what I am trying to do..?

[@danieltorres9788]

thank you, man

[@discospiff]

You're welcome! This was very helpful when I had to do bulk loads of students, before starting a training class. Much easier than entering them manually through the web interface!

[@MsAnil2009]

thanks to you I create my moodle site but i need your help

[@mikeosude]

Hi, fantastic video, please is there a way to enroll users to courses without adding password to the CSV file so that the users preset credentials still stay persistent? I really appreciate a quick response. Thank you in advance

[@discospiff]

As I recall, in the user profile, there's a checkbox for "user must reset password on first login", or something to that effect. I'm not sure if you can upload that property in a spreadsheet, but if nothing else, you can tick that box to force password reset. Hope that helps!

[@Khalid_series]

@@discospiff But it doesn't go to user's email? As it shows 'generated in cron' but still it doesn't appear in user's email?

[@nikhilshinde3702]

thanks!

[@discospiff]

Glad it helped... thanks for watching!

[@nikhilshinde3702]

@@discospiff do you have experience in developing moodle plug-ins?

[@nikhilshinde3702]

I'm developing one as my college project. So any recommendations?

[@willreenespiritu6655]

it says error no name as course1

[@discospiff]

Do you have a course in moodle named course1? It's usually the short course name that has to match up to the spreadsheet.

[@balmonicvasquez]

gracias

[@discospiff]

De nada.