> For the complete documentation index, see [llms.txt](https://helpdesk.ldtsoft.work/ldt-online-course/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://helpdesk.ldtsoft.work/ldt-online-course/students-and-reports/how-to-bulk-import-students-from-a-csv.md).

# How to bulk import students from a CSV

Bring a list of students in from a spreadsheet: download the template, fill it, upload the CSV

Move a whole list of students into the app at once — from another course system, or from a spreadsheet you keep yourself.

The import runs from the **Students** page, and every run is kept in a history so you can see what went in and whether the welcome email went out.

### 1. Open Students

In Shopify admin, open **Apps** -> **LDT Online Courses**, then click **Students** (1) in the app's menu.

<figure><img src="https://3532245007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FuRJ3j93eHyen8t2flj5y%2Fuploads%2Fgit-blob-d75b2562aa568de127669d8c732ddbbe0a5c65b1%2Fhow-to-bulk-import-students-step-1.png?alt=media" alt="Clicking Students in the LDT Online Courses menu of Shopify admin"><figcaption></figcaption></figure>

### 2. Click Import

In the top bar of the Students page, click **Import** (2).

<figure><img src="https://3532245007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FuRJ3j93eHyen8t2flj5y%2Fuploads%2Fgit-blob-341fefc1ac8d29976cdd1f89505c79ebd15f3109%2Fhow-to-bulk-import-students-step-2.png?alt=media" alt="Clicking Import in the top bar of the Students page"><figcaption></figcaption></figure>

### 3. Download the CSV template and fill it

The **Import students** page explains what to prepare: your courses exist and are linked to their Shopify products, and your data follows the app's template. Start with **Download CSV template** (3) and fill one row per student.

<figure><img src="https://3532245007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FuRJ3j93eHyen8t2flj5y%2Fuploads%2Fgit-blob-6382b2f0c1d89cf4a4e6794a2b5bdd58d455a430%2Fhow-to-bulk-import-students-step-3.png?alt=media" alt="Downloading the CSV template before importing students"><figcaption></figcaption></figure>

### 4. Upload the CSV

Under **Bulk upload**, use **Upload CSV file** (4) and pick the file you filled. The rows are read as they are; a student who is already enrolled is not enrolled a second time.

<figure><img src="https://3532245007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FuRJ3j93eHyen8t2flj5y%2Fuploads%2Fgit-blob-8ac45034ff3d46346f3cef57ab4f767e959b1c88%2Fhow-to-bulk-import-students-step-4.png?alt=media" alt="Uploading the filled CSV file on the Import students page"><figcaption></figcaption></figure>

### 5. Check the history

Every run lands in the **History** table (5) at the bottom, with the date, whether the **Send welcome email** option was on, and the **Status** and **Result** of the import. **Refresh** reads the table again after a run. Until the first import the table is empty, as in the screenshot.

<figure><img src="https://3532245007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FuRJ3j93eHyen8t2flj5y%2Fuploads%2Fgit-blob-eb4dec091fdeb31f212ef70747ccc6e9d1d021a7%2Fhow-to-bulk-import-students-step-5.png?alt=media" alt="The import history table, empty until the first import"><figcaption></figcaption></figure>

### Result

The students in your file are enrolled, with the same result as a manual enrolment, and each run stays visible in the history with its status.

### Troubleshooting

* **The import fails with an error on every row.** Check the columns against the template you downloaded — the app reads the header names, so a renamed column is ignored.
* **A student is missing from the list afterwards.** Search the Students page for their email; a row with an address that already has an account is merged, not duplicated, and it does not appear as a new record.
* **Students did not get their welcome email.** The history shows whether the run had **Send welcome email** on; the message itself follows your email settings.
* **You need students who bought before you installed the app.** Use **Import from orders** on the same page instead of a file — it enrols the people behind your existing orders.
* **The list is huge.** Split the file: one import per course keeps the history readable.

### Related pages

* [How to import students from existing orders](https://helpdesk.ldtsoft.work/ldt-online-course/students-and-reports/how-to-import-students-from-orders.md)
* [How to export your student list and read one student's progress](https://helpdesk.ldtsoft.work/ldt-online-course/students-and-reports/how-to-export-students-and-read-progress.md)
* [How to Manually Grant Course Access Without Purchasing](https://helpdesk.ldtsoft.work/ldt-online-course/enroll-and-price/how-to-manually-grant-course-access-without-purchasing.md)
