With the LearnDash Course Import/Export add-on, creating, updating, migrating and backing-up courses has never been this easy! Export courses into a .xls or .xslx file with a single click. Plus, create and edit courses, lessons, and topics directly from a simple template, importing them into any LearnDash site in record time.
Below, you’ll find the instructions you need to follow to install, configure, and import/export courses with this add-on.
Table of Contents
- Installation
- Activate your License Key
- General Settings
- Export a Single Course
- Export Multiple Courses
- Import a Single Course
- Import Multiple Courses
- Template Guide
- FAQ
- Changelog
Installation
- Install the LearnDash LMS plugin & activate it
- Install LearnDash Course Import/Export and activate it
- A new “Course Import/ Export ” menu will appear under the LearnDash LMS menu
Activate Your License Key
The license key can be configured from the License Settings tab, found on the main Course Import/Export menu. License keys will be sent to your email address when you purchase the addon.
Insert your license key in the field and then click on Activate.
General Settings
- Minimum role to Import courses: Here you can set the minimum user role that will be able to import/export courses. Currently you can choose user roles between administrator, editor & author.
- Publish Courses on Import: Enable this toggle if you want to publish the courses on import. By default, the imported courses status will be Pending.
Export a Single Course
Select “Courses” from the LearnDash menu. An Export button will appear in the courses table, under the “Course Export” column.
To export a course, simply click on the export button. The course will be downloaded as a .xls or .xlsx file. Both course content and course settings will be exported in the file and can be imported to another LearnDash site using this add-on.
Export Multiple Courses
To export multiple courses into a single file, simply select the courses you want to export and then select the “Export to xls” or “Export to xlsx ” options from the “Bulk Options” field.
Complete courses, including course content and settings, will be downloaded as a .xls or .xlsx file, which can be imported to another LearnDash site using this add-on.
Import a Single Course
To import a course, navigate to the “Import Course” tab from the Course Import/Export menu located under the main LearnDash LMS menu. To complete the import, select the completed template’s .xls or .xlsx file and click on the import course button.
Import Multiple Courses
You can import several courses at once using a single template file by adding multiple entries on the “Courses” sheet of the template. When importing lessons and topics, simply specify the title of the course they are assigned to from the “Course” column on the “Lessons” and “Topics” sheet.
Then, to complete the import process, go to the “Import Course” tab from the course Import/Export menu located under the main LearnDash LMS plugin menu. Here, select the Microsoft Excel .xls or .xlsx file containing multiple courses and click on the “import course” button.
After importing the file, you will see a list of all imported courses. Next, select a specific course to configure its settings and publish.
LearnDash Course Import/Export Template Guide
The LearnDash Course Import/Export add-on uses a standard template to import and export courses, lessons, and topics. When exporting a course, its content is added to the corresponding fields on the spreadsheet file. Likewise, on import, the template should be filled with the necessary course content and settings, in the order and form outlined below:
“Course” Sheet
- Type
The first column on the “Course” sheet is the “Type” column. This column is used to specify the type of content being imported. Content types options include: course, lesson, and topic.
In this sheet, this field should be set to “course”.
- Course ID
This field will show the course ID when you will export any course.
- Category
Here you can add the categories of the course i.e in the example;
- Category A, Category A > Category B
Category A is parent & Category B is child while Category A > Category B shows their relation.
- Tag
Here you can add a single or multiple tags for your course. You can separate multiple tags by using commas.
- Title
This column holds the title of the course.
- Content
This column contains the content featured in the course description page.
Images, videos and text can be included in the content using HTML tags. To do so, use <img> for the images, <p> for text and <video> and for the videos.
- Course Image
Here you can add the featured image of the course. Simply add the link of the featured image in this column.
- Course Type
This column can have the following values corresponding to the LearnDash course types:
- Open: open
- Free: free
- Buy now: pay now | (course price)
- Recurring: recurring | (course price) | (interval) | (periodicity i.e D – days, W -weeks, M -months and Y – years )
- Closed: closed | (price) | (button url)
- Material
Supporting materials for the course can be added as plain text or HTML.
- Shared Steps
Leave this field Empty as this adds sting on course export.
- Course trial Price
For the recurring Access Type, enter the price for the trial period of the Course.
- Course trial duration t1
For the recurring Access Type, enter the duration for the trial period of the Course.
- Course trial duration p1
For the recurring Access Type, enter the period for the trial of the Course i.e. D for days, W for weeks, M for months or Y for years.
- Course price type
Here add the course price type i.e. subscribe, closed etc.
- Course price type paynow price
For the buy now Access Type, enter the course price.
- Course price type paynow enrollment url
For the buy now Access Type, enter the URL of the page you want to redirect your enrollees after signing up for the specific course.
- Course price type subscribe billing cycle
For the recurring Access Type, enter the billing period i.e. D for days, W for weeks, M for months or Y for years.
- Course price type subscribe billing recurring times
For the recurring Access Type, set the times for which the billing cycle repeats.
- Course price type subscribe price
For the recurring Access Type, set the course price.
- Course price type subscribe enrollment url
For the recurring Access Type, enter the URL of the page you want to redirect your enrollees after signing up for the specific course.
- Course price billing t3
For the recurring Access Type, enter the duration for the billing.
- Course price billing p3
For the recurring Access Type, enter the billing period i.e. D for days, W for weeks, M for months or Y for years.
- Course price type closed custom button label
Here you can add a button label.
- Course price type closed custom button url
For the closed Access Type, enter the “Take this course” button URL.
- Course price type closed price
For the closed Access Type, set the course price.
- Course prerequisite enabled
To enable the course prerequisite, add “on” in this field.
- Course prerequisite
Add the IDs of single or multiple course prerequisites.
- Course prerequisite compare
In this field, to select “Any Selected” option, add “ANY”, or to select “All Selected” option, add “ALL”.
- Course points enabled
To enable the course points, add “ON” in this field.
- Course points
Add points in this field.
- Course points access
Add the points required to access course access.
- Expire access
To enable the course access expiration, add “ON” in this field.
- Expire access days
Set the number of days a user will have access to the course from enrollment date.
- Expire access delete progress
Set this field to “ON” to delete the user’s course and quiz data when the course access expires.
- Course materials enabled
To enable course materials, add “on” in this field.
- Course lesson order enabled
Supporting materials for the course can be added as plain text or HTML.
- Certificate
To add the certificate add its ID.
- Exam challenge
Set this filed to “ON” if you want to add exam challenge.
- Course disable content table
Add “CUSTOM” in this field.
- Course lesson per page
Default Lesson per page.
- Course lesson per page custom
Set the number of lesson that should appear per page.
- Course topic per page custom
Set the number of topics that should appear per page.
“Lessons” Sheet
- Type
The first column on the “Lesson” sheet is the “Type” column. This column is used to specify the type of content being imported. Content types options include: course, lesson, and topic.
In this sheet, this field should be set to “lesson”.
- Lesson ID
This field will show the lesson ID when you will export any lesson.
- Category
Here you can add the categories of the lesson i.e in the example;
- Category E, Category E > Category F
Category E is parent & Category F is child while Category E > Category F shows their relation.
- Tag
Here you can add a single or multiple tags for your lesson. Multiple tags can be separated by using commas.
- Title
This column holds the title of the lesson.
- Content
This column contains the lesson’s content.
Images, videos and text can be included in the content using HTML tags. To do so, use <img> for the images, <p> for text and <video> and for the videos.
- Lesson Image
Here you can add the featured image of the lesson. Simply add the link of the featured image in this column.
- Material
Supporting materials for the course can be added as plain text or HTML.
- Course
This column represents the course to which this lesson is attached.
- Shared Course
Add the shared course title.
- Forced lesson time
Here add the time of the lesson.
- Lesson assignment points amount
Set the lesson assignment points.
- Visible after
Here you can set the “enrollment based” lesson schedule. All you have to do is, add number of days after that the lesson will be available.
- Visible after specific date
Date can be added as a TimeStamp and to convert a date to timestamp you can use https://www.epochconverter.com/
- Lesson materials enabled
To enable lesson materials, add “on” in this field.
- Lesson materials
Supporting materials for the lesson can be added as plain text or HTML.
- Lesson video enabled
To enable video lesson, set this field to “ON”.
- Lesson video url
Add the URL of the video.
- Lesson video shown
If you want to select “Before completed sub-steps” option then add “Before” in the field or to select “After completing sub-steps” option, add “After” in the field.
- Lesson video auto start
If autostart should be enabled then add “On” here.
- Lesson video show controls
To enable video control display, add “On” in the field.
- Lesson assignment upload
To enable assignment upload, add the “On’ in the field.
- Assignment upload limit extensions
Add a file extension if you want to limit assignment upload in a specific format.
- Assignment upload limit size
Here you can set the assignment file uploading limit i.e. 20M
- Lesson assignment points enabled
Add “On”, if assignment poinst are enabled.
- Assignment upload limit count
Set the number, to limit the number of uploaded assignment files.
- Lesson assignment deletion enabled
If you want to allow file deletion then add “On” in this field.
- Auto approve assignment
Add “On’ to enable the Auto Approve Assignment feature.
- Forced lesson time enabled
Add “On” here to enable Forced lesson time.
- Lesson schedule
If lesson schedule is set to “Enrollment-based” then add “visible_after” in this field.
If lesson schedule is set to “Specific date” then add “visible_after_specific_date” in this field.
- Sample lesson
To enable Sample Lesson, add “on” in this field.
“Topics” Sheet
NOTE: Some of the columns in TOPIC sheet has “Lesson” in the title, instead of “Topic”. You can add your topic settings in these columns as Title doesnot has any effect.
- Type
The first column on the “Topics” sheet is the “Type” column. This column is used to specify the type of content being imported. Content types options include: course, lesson, and topic.
In this sheet, this field should be set to “topic”.
- Topic ID
This field will show the topic ID when you will export any topic.
- Category
Here you can add the categories of the topic i.e in the example;
- Category X, Category X > Category Y
Category X is parent & Category Y is child while Category X > Category Y shows their relation.
- Tag
Here you can add a single or multiple tags for your topic. Multiple tags can be separated by using commas.
- Title
This column will hold the title of the topic.
- Content
This column contains the topic’s content.
Images, videos and text can be included in the content using HTML tags. To do so, use <img> for the images, <p> for text and <video> and for the videos.
- Topic Image
Here you can add the featured image of the topic. Simply add the link of the featured image in this column.
- Material
Supporting materials for the course can be added as plain text or HTML.
- Course
This column represents the course to which this topic is attached.
- Lesson
This column represents the lesson to which this topic is attached.
- Shared Course
Add the shared course title.
- Shared Lesson
Add the shared lesson title.
- Topic materials enabled
To enable topic materials, add “on” in this field.
- Topic materials
Supporting materials for the topic can be added as plain text or HTML.
- Lesson video enabled
To enable video topic, set this field to “ON”.
- Lesson video url
Add the URL of the video.
- Lesson video shown
If you want to select “Before completed sub-steps” option then add “Before” in the field or to select “After completing sub-steps” option, add “After” in the field.
- Lesson video auto start
If autostart should be enabled then add “On” here.
- Lesson video show controls
To enable video control display, add “On” in the field.
- Lesson assignment upload
To enable assignment upload, add the “On’ in the field.
- Assignment upload limit extensions
Add a file extension if you want to limit assignment upload in a specific format.
- Assignment upload limit size
Here you can set the assignment file uploading limit i.e. 20M
- Lesson assignment points enabled
Add “On”, if assignment poinst are enabled.
- Assignment upload limit count
Set the number, to limit the number of uploaded assignment files.
- Lesson assignment deletion enabled
If you want to allow file deletion then add “On” in this field.
- Auto approve assignment
Add “On’ to enable the Auto Approve Assignment feature.
- Forced lesson time enabled
Add “On” here to enable Forced topic time.
- Lesson schedule
If topic schedule is set to “Enrollment-based” then add “visible_after” in this field.
If topic schedule is set to “Specific date” then add “visible_after_specific_date” in this field.
- Visible after
Here you can set the “enrollment based” topic schedule. All you have to do is, add number of days after that the topic will be available.
FAQ
Does the Add-on support all course types (pricing) present in LearnDash?
Yes. The add-on supports all LearnDash course types including the recurring course type as well.
Which excel extension does this add-on support?
This add-on supports the .xls and .xlsx file extension.
Where can I find the standard XLS template?
The plugin zip file includes a standard XLS template for import. The standard XLS template is located inside the zip file provided here: learndash-course-import-export > sample-import-files.
How can I export a course?
To export any course you have to go to the “Courses” page under the LearnDash LMS menu. Next, click on the “Export” button located in the “Course Export” column.
Can I export lessons and topics, without exporting an entire course?
Currently, the add-on only supports exports for complete courses.
Can I import or export multiple courses at a time?
Yes, the add-on supports imports and exports for multiple courses.
Will the course, lessons, and topics be successfully imported if the Shared Course Steps are enabled from the course settings?
Yes, you can successfully import and export the courses with the “shared course steps” option enabled.
Why does the course’s import progress bar get infinitely stuck?
The import progress bar might get stuck when importing a large number of courses at once. To resolve this issue, please contact your hosting provider and ask them to apply the following changes to server configurations:
upload_max_filesize = 32M
post_max_size = 48M
memory_limit = 256M
max_execution_time = 600
max_input_vars = 1000
max_input_time = 400
If a course, lesson, or topic has text, images, and a video lesson how are these added to the spreadsheet and how would one control formatting/appearance?
Images and videos can be added using HTML tags. <img> for the images, <p> for text and <video> and for the videos. Using these tags you can add images and videos along with the text.
Changelogs
1.2.8
- New – Update duplicate lessons/topics option is added in plugin settings.
- Fix – Plugin documentation link updated.
- Fix – Recurring courses values on import/export.
- Fix – Issues with exporting data into wrong column.
- Fix – Change format of prerequisite courses from course ID to course names on import/export.
- Fix – Resolved lesson and topics association issue when shared course steps option is enabled.
1.2.7
- Fix – Compatibility issue with PHP version 8.
- Fix – Resolved lesson and topics association issue when the shared course steps option is enabled.
1.2.6
- Fix – Resolved topics association issue with course and lesson on import.
- Fix – Added plugin settings description.
1.2.5
- Fix – Course and Quiz linking.
- Fix – Resolved import/export problems related to shared course steps.
- Fix – Improved the user interface and experience of the plugin settings page.
- Fix – Upgraded the Excel template used in the plugin.
1.2.4
- Fix – Course duplication issue.
- Fix – Issues with categories and tags.
- Fix – Editor / Author LearnDash menu setup.
- New – Added setting for publishing course on import.
1.2.3
- New – Import/Export tags for courses/lessons/topics.
- Fix – UI Improvements.
1.2.2
- New – Added settings for the minimum role to import courses.
1.2.1
- New – Added support for shared course steps in Import/Export.
1.2.0
- New – Import/Export category and featured image for courses / lessons / topics.
1.1.1
- Fix – Courses, Lessons, and Topics order of list after import.
1.1.0
- New – Import/Export course, lesson, and topic settings.
1.0.2
- Fix – Export button UI on course listing page.
1.0.1
- Fix – License issue.
- Fix – Minor issues.
1.0.0
- Initial Release