Bulk Uploading Learners with a CSV File
Prepare a learner CSV, map its columns to Edmingle fields, fix failed rows and review upload history.
When you have more than a handful of learners, upload them in a CSV file. This works in both Enroll New or Existing Learners and Add/Update Learners. This article covers preparing the file, mapping its columns, and fixing problems.
Bulk CSV upload is available on Prime and higher plans. On other plans the option is greyed out.
Step 1: Download the sample and prepare your file
- In the New Enrollment flow, choose Bulk upload CSV file.
- Click Download Sample File.
- In Before you download, tick the fields you want as columns. Default fields (such as name, email and password) are always included. Add any Custom Field you want to fill in.
- Click Download Sample CSV and fill in one row per learner.
Tips for filling in the file:
- Use one row per learner and keep the column headers as they are.
- Password: if you leave it blank, Edmingle generates a random password for the learner.
- Dates: use the format dd-mm-yyyy.
- Dropdown fields: values are case-sensitive and must match your options exactly.
Step 2: Upload the file
- Drag your file into Upload a CSV file, or click to browse.
- Files can be up to 2 MB or 10,000 learners, in .csv format only.
Step 3: Map your columns
The Map Columns window opens so you can match each column in your file to a field in Edmingle.
- For each CSV column name, choose a field under Map to field. Columns are matched automatically where the headers match.
- Required fields must be mapped before you can continue. If any are missing, you'll see which ones.
- Check the Preview of your data and the Total records.
- Click Verify and Proceed.
Data in unmapped columns is ignored. Each Edmingle field can only be mapped once.
Step 4: Finish
- In Enroll New or Existing Learners, continue to the Enroll to a product step. The page shows how many learners were detected. See Enrolling New or Existing Learners.
- In Add/Update Learners, go straight to the review. See Adding or Updating Learners Without Enrolling.
When an upload fails
If rows can't be processed, a CSV Failed message appears. Fix the file and click Reupload to start again from the upload step.
Upload history
Click View File History (shown when Bulk upload is selected) to see your past uploads and their results.
What's next
For imports where each learner needs a different course, batch or fees scheme, use Advanced Bulk Enrolment.