Our Import Students from File feature is a quick and easy way to add students to your Thinkific account from another platform or database using an XLSX or CSV file!
In this article:
Preparing Your Import File
Before you can run an import, you will need to make sure you have a spreadsheet prepared. You can download a sample template from Support Your Students Users Import from file for reference:
Download the template:
Your import template must have the the following:
- A minimum of three columns that include: Email address, First name, and Last name
- The first row of your columns must be column header names (ie. First name, Last name).
- Your file must have an .XLSX or .CSV extension
- Give your file a unique name as it will be recorded for later use in a User Filter.
- Include a maximum of 5000 students. Please split the file into multiple imports or contact support if you are looking to regularly import a larger number of students.
How to Import Students
- Navigate to Support Your Students Users
- From the Users page, click on the split key to the right of New User on the top right and select Import From File:
- Please review the Guidelines as stated on the page and re-iterated below as there is no cancel option once the import has started:
- New users will be created with Email address, First name, and Last name data. After selecting your import file, you can map which columns from your file to import into each data field.
- Your file must have an .XLSX or .CSV extension. You can chose to download and fill out the template file however we strongly recommend that you save the file with a different name as it will be recorded for use in a User Filter.
- The first row of your columns must be column header names (ie. First name, Last name).
- On import, new users will be created if the email does not already exist in your Thinkific school database.
- If an existing email is found, only the First name and Last name data fields will be updated.
- You will be given the option to confirm the import after mapping the data fields. Please note that there is no delete option, so please be sure your data is corre - Click on Browse Files button to select .XLSX or .CSV file of students to import:
- Select Upload
- Once the file is uploaded and processed, you will then have the option to map the columns in your file to the fields necessary in Thinkific. These include First Name, Last Name and Email. This import process will only import those three fields and no other data (such as Custom Fields). It is not currently possible to add additional data fields at this time.
- Click on the drop down box for each field to chose the column header that matches your spreadsheet. You will see the first 4 rows of data samples to verify the correct column was selected. After mapping each field, you should see a green check mark to the right of the required field:
- Before beginning the import, you have the option to send your Site Welcome Email to each of these imported students. This is helpful in that it includes the Express Sign-In link, which allows the student to set their own password and login. If you do not send the Site Welcome Email, you will need to send your own communication including the Express Sign-In link in order for your students to access their account.
NOTE: The option to send the Site Welcome Email may be unavailable if the global setting for Site Welcome Notification is turned off. You will need to turn this on (and verify the format/edit of the notification) in order to toggle the option to send during the import. You can see more details on enabling and customizing your Site Welcome Email HERE.
- Once you confirm the mappings and selection of whether to send the Site Welcome Email is correct, then select Import.
The import will begin to process and you will receive status notifications in the lower left hand corner of your Admin. You can continue to perform other tasks as you wish. - Once the import is completed and you are notified, you can use the below filter to select those users that were imported in that file. Note that the selection of the filter does reference your file name, so its helpful to have a unique name to each file (each import listed will also be appended with the date and time of the import making for easy identification!)
Using this filter, you can then chose to Add to Groups, or Bulk Enroll (or Unenroll) to Courses and Bundles as well as any other bulk action features!
Important Considerations
How many students can I import at one time?
The Import from File feature is a background process and as such, completion of the task can vary based on number of records affected, the date and time the process is run - as Thinkific is a shared platform amongst all users. We have designed the process to segment large numbers to batches of 500 so as to maintain a healthy system! In addition there is again a maximum of 5,000 students per import. Please split the file into multiple imports or contact support if you are looking to regularly import large number of students.
What happens if I re-import a student who already exists as a user?
If you import a user who already exists in the system, the email first name and last name will be updated if there are any changes. The email address acts as the unique identifier for each user. This means that the import will look for a matching email address and only update the first name and last name associated with that particular email address.
The Site Welcome email will not be sent again for existing users, even if it is enabled. The Site Welcome email can only be triggered on initial creation of the user.
More About Managing Students
Bulk Enroll and Un-Enroll Students
Create, Enroll & Delete Users in a Course