One of the ways administrators can invite thousands of students to enroll in the courses is by using a CSV file.

The CSV file could, however, fail to upload the students' information, if it is not formatted in the right way.

The CSV file should have a 3 columns
- 1 column having the students' Names (optional)
- 1 column with emails
- 1 column with Phone numbers

Please name the columns Name, Email & Phone

Download an excel template here

Kindly note; The phone numbers need to be in a different column from the emails! However, you do not need to have both the student's email and phone number for them to be onboarded. You can use either of the two. If you add both, the person will currently receive 2 invitations for each contact point.

It is also important to note that the Phone number Column needs to be in TEXT FORMAT, with a +256 or other country code at the beginning of every phone number.

Select the Number Column and right-click with your mouse and select Format Cells.

Then select Text and OK.

Add the plus sign in front of the number. Now you should be good to go!
Make sure you don't have any spelling errors or additional spaces.

β˜€οΈ Special update! β˜€οΈ

We have upgraded our CSV functionality so that we can further help you to avoid spelling errors.

After you have uploaded your CSV, you will see an overview like this πŸ‘† The CSV has imported all your columns, and named them Column 1, Column 2 Column 3 and so forth.

If your CSV sheet has titles for your columns (A title like Name, Email, Phone)

The first name of each column in this overview will have the name of the title. Please tick off the β€œData has Titles” box, if your CSV sheet had titlesπŸ‘‡

Proceed to select the columns you need to invite students with. This will be the column from your CSV sheet that contains email addresses as well as the column that contains phone numbers of the students.

Please select the correct Column that email addressed belongs to in the dropdown menus.

Then select which column phone numbers belong to πŸ‘‡

Then click Continue.

Your CSV information has been uploaded into the Invite student page. If an email address or phone number has an error, there will be an orange message highlighting the error, so that you can correct it before invitations are sent out.

Phone numbers will need the country code in front of their numbers-including the + sign. Correct the input fields that are highlighted with orange text.

Once you have corrected all errors, you are ready to send out your invites. Click Send Invites to do so β˜€οΈ

If you are still struggling to upload your CSV file, please do not hesitate to reach out to us through our chatbot messenger in the right bottom corner of this page. πŸ‘‰

For quicker assistance, please send us the CSV file you are struggling with.

Did this answer your question?