1. Create the CSV file:

  • Open a spreadsheet program (like Excel or Google Sheets).
  • Include the following headers in the first row:

    username, email, and additional columns for the information you want to update (e.g., course1 for course enrollment).

    Example: If you want to enroll users in a course, add the short course name under the course1 column.

    Ensure that all details (e.g., usernames, course names) are correct and match the Moodle system data.

    Image Placeholder

  • Once all user information is added, save the file as a .csv file.




2. Upload to Moodle:

  • Navigate to Site administration.
  • Click on Users.
  • Under Accounts, select Upload users from the options.


  • Click Choose a file, select the .csv file you created, and click Upload users.

    Image Placeholder

3. Map CSV Fields:

  • Ensure that the fields from your .csv file are correctly mapped to Moodle fields (username, email, course1).

Image Placeholder

4. Adjust Upload Settings:

  • In the settings, under Upload type, choose "Update existing users only".
  • For matching criteria, set Match on email address to "Yes".
Image Placeholder


5. Complete the Update:

  • Click Upload users to start the process.
  • Moodle will process the CSV and update user accounts as specified in the file.

    Image Placeholder