moodle upload users

If you need to add a large number of users to your site, and you don’t want them to create their own accounts, you can upload a text (.csv) file to create the accounts in bulk.

1. Log in to Moodle with your administrator account
2. Click Site administration
3. Click the Users tab
4. Click “Upload users”
   Download to your computer the example text file . Leave the top line (with the fields) blank, and complete it with the details of your users, using a text editor like Notepad or a spreadsheet program like MS Excel or Libre Office Calc.
   
   Uploading user, you can see above example.csv.It is a sample for uploading.You must download example.csv next do user list on excel.Table header should have username,first name,last name,email ,password,id number ,department.

   Required fields

   username,firstname,lastname,email

   Passwords

   To force password change for a particular user, set the password field to changeme. If omitted, a password will be generated for each user (during the next Cron job) and welcome e-mails sent out. The text for the welcome e-mail is in the language settings in Site administration > Language > Language customisation with a String identifier of ‘newusernewpasswordtext’.

   Optional user fields

   institution,department,city,country,lang,auth,timezone,idnumber,icq,phone1,phone2,address,url,description,mailformat,maildisplay,maildigest,htmleditor,autosubscribe,interests,theme

   table sample:

   idnumber	lastname	firstname	username	password	department	email	phone1
   1	la	lin	l.lin	Lala@123:	IT	lala@gmail.com	000000000
5. Make sure you save it as a text (.csv) file and please note,It is going to be error .xlsx extension (excel file).
6. Go back to Upload users and upload your file, making sure the CSV delimiter is the same as the one you used. Usually this is a comma.
7. Preview the accounts and decide on the settings and default values you want. (If in doubt, leave them as they are)
8. Click Upload users again