# Bulk Add Learners

## Process

Moodly provides a bulk add feature which allows you to quickly populate classrooms using a CSV file.

From the side menu select "Manage Class".

Select "Bulk Add" from the top right corner of the table.

<figure><img src="https://3816989133-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwpfpTMByXabaDN35qbj1%2Fuploads%2Fbt21XP1kqLaOptufpDxf%2Fimage.png?alt=media&#x26;token=3856c9cb-2b03-4b22-be14-a93f03102f50" alt=""><figcaption></figcaption></figure>

From the bulk add screen, either drag your csv onto the area or click the area and select your csv file.

<figure><img src="https://3816989133-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwpfpTMByXabaDN35qbj1%2Fuploads%2FuyKgc2bdUJJWKyBOHdjE%2Fimage.png?alt=media&#x26;token=cbce1618-ef3f-45e7-a3b7-960f9e9fa459" alt=""><figcaption></figcaption></figure>

On the next screen, if your csv contains header (i.e. name, gender) make sure the "Data has headers" check box is selected

<figure><img src="https://3816989133-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwpfpTMByXabaDN35qbj1%2Fuploads%2FfS3OTVqPJrTSTLzvRMbv%2Fimage.png?alt=media&#x26;token=cd2498eb-1486-4ec7-91b6-6a57c9510c4e" alt=""><figcaption></figcaption></figure>

Otherwise, unselect and click "Choose Columns"

{% hint style="info" %}
Ethnicity and Free school meals are optional
{% endhint %}

We now need to map the CSV column to the Moodly data.

Simply drag the column to the corresponding data, in the below example&#x20;

|   |                   |
| - | ----------------- |
| A | Name              |
| B | Gender            |
| C | Ethnicity         |
| D | Free School Meals |

<figure><img src="https://3816989133-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwpfpTMByXabaDN35qbj1%2Fuploads%2FbG392vvu7hRjmmRtWNZV%2Fimage.png?alt=media&#x26;token=efe744b6-a979-4863-8815-c45c5a5367b6" alt=""><figcaption></figcaption></figure>

Finally select Import.

Please wait for the "Finish" button to appear.

If there are any data errors, a table will be displayed with the problems.

## Supported CSV Values

### Name&#x20;

Any Text

### Gender

Male, Female, male, female

### Free School Meals (Optional)

yes, no, true, false, Yes, No, True, False

### Ethnicity (Optional)

| Ethnicity Value                 |
| ------------------------------- |
| White English                   |
| White Welsh                     |
| White Scottish                  |
| White Northern Irish            |
| White Irish                     |
| White Gypsy or Irish Traveller  |
| White Other                     |
| Mixed White and Black Caribbean |
| Mixed White and Black African   |
| Mixed White Other               |
| Asian Indian                    |
| Asian Pakistani                 |
| Asian Bangladeshi               |
| Asian Chinese                   |
| Asian Other                     |
| Black African                   |
| Black African American          |
| Block Caribbean                 |
| Black Other                     |
| Arab                            |
| Hispanic                        |
| Latino                          |
| Native American                 |
| Pacific Islander                |
| Other                           |

### Data issues

If you process a file with incorrect data, like the example blow, after pressing import you will be presented with an errors grid:&#x20;

```
Name,Gender,Ethnicicy,FSM
Learner 1,invalid,White Welsh,yes
Learner 2,female,,invald
Learner 3,female
```

<figure><img src="https://3816989133-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwpfpTMByXabaDN35qbj1%2Fuploads%2FAl3RdCwjWMTk6I4mIUvU%2Fimage.png?alt=media&#x26;token=1af68dc7-c07e-4e6a-ae9b-0729297c80b3" alt=""><figcaption></figcaption></figure>

The errors grid will tell you which rows in the CSV are invalid and which Moodly data element it refers to.