LearnDash Course Import/Export - Overview

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.

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


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.


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.


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”.

Title

This column holds the title of the course.

Content

This column contains the content featured on 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 [embed] for the videos. 

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.

Course Access Settings

The course access settings like course prerequisite, course points, course access expiration, and course price, can be added here.

You can alter the list displayed by setting different parameters

{"sfwd-courses_course_price_type":"free","sfwd-courses_course_prerequisite_enabled":"on","sfwd-courses_course_prerequisite":[667],"sfwd-courses_course_prerequisite_compare":"ANY","sfwd-courses_course_points_enabled":"on","sfwd-courses_course_points":10,"sfwd-courses_course_points_access":5,"sfwd-courses_expire_access":"on","sfwd-courses_expire_access_days":7,"sfwd-courses_expire_access_delete_progress":"on","sfwd-courses_course_price_billing_p3":"","sfwd-courses_course_trial_price":"","sfwd-courses_course_trial_duration_t1":"","sfwd-courses_course_trial_duration_p1":"","sfwd-courses_course_price_billing_t3":""}

Parameters:
  • sfwd-courses_course_price_type: open /free /buy_now /recurring/ closed
  • sfwd-courses_course_prerequisite_enabled: on /off
  • sfwd-courses_course_prerequisite: Add course ID
  • sfwd-courses_course_prerequisite_compare: Any /All
  • sfwd-courses_course_points_enabled: on /off
  • sfwd-courses_course_points: Add number of points awarded for completing the course.
  • sfwd-courses_course_points_access: Add number of points required in order to gain access to the course.
  • sfwd-courses_expire_access: on /off
  • Sfwd-courses_expire_access_days: Set the number of days a user will have access to the course from the enrollment date.
  • sfwd-courses_expire_access_delete_progress: on /off

Course Display Settings

The course display settings like course materials, course certificate, and challenge exam show, can be enabled here.

You can alter the list displayed by setting different parameters

{"sfwd-courses_course_materials_enabled":"on","sfwd-courses_course_materials":"<p><a href=\"http:\/\/localhost\/wordpressqa\/wp-content\/uploads\/2021\/10\/sample-1.pdf\">sample-1<\/a><\/p>","sfwd-courses_certificate":"1176","sfwd-courses_exam_challenge":2226,"sfwd-courses_course_disable_content_table":"on”,"sfwd-courses_course_lesson_per_page":"CUSTOM","sfwd-courses_course_lesson_per_page_custom":20,"sfwd-courses_course_topic_per_page_custom":20,"sfwd-courses_course_lesson_order_enabled":"","sfwd-courses_course_lesson_orderby":"","sfwd-courses_course_lesson_order":""}

Parameters:

  • Sfwd-courses_course_materials_enabled: on /off
  • Sfwd-courses_course_materials: Add material link
  • Sfwd-courses_certificate: Add course certificate ID
  • Sfwd-courses_exam_challenge: Add challenge exam ID
  • Sfwd-courses_course_disable_content_table: on /off
  • Sfwd-courses_course_lesson_per_page: CUSTOM /off
  • Sfwd-courses_course_lesson_per_page_custom: Set the number for lessons per page
  • Sfwd-courses_course_topic_per_page_custom: Set the number for topics per page

Course Navigation Settings

Here you can set the course progression settings.

You can alter the list displayed by setting different parameters

{"sfwd-courses_course_disable_lesson_progression":"on"}

Parameters

  • Sfwd-courses_course_disable_lesson_progression: on /off

Category

Here you can add the categories of the course i.e in the example;

  • Category A, Category A > Category B 

Category A is the parent & Category B is a child while Category A > Category B shows their relation.

Course Image

Here you can add the featured image of the course. Simply add the link to the featured image in this column.

“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”.

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 [embed] for the videos. 

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.

Lesson Access Settings

The lesson access settings like lesson schedule, sample lesson, and visibility date can be added here.

You can alter the list displayed by setting different parameters

{"sfwd-lessons_course":347,"sfwd-lessons_lesson_schedule":"visible_after","sfwd-lessons_sample_lesson":"on","sfwd-lessons_visible_after":1,"sfwd-lessons_visible_after_specific_date":""}

Parameters

  • Sfwd-lessons_course: Add lesson ID
  • Sfwd-lessons_lesson_schedule: visible_after /visible_after_specific_date
  • Sfwd-lessons_sample_lesson: on /off
  • Sfwd-lessons_visible_after: Add the number of days after which the lesson will be visible
  • Sfwd-lessons_visible_after_specific_date: Add the specific date on which lesson will be visible

Lesson Display Settings

The lesson display settings like lesson materials, video progression, lesson assignments, and forced lesson timer, can be enabled here.

You can alter the list displayed by setting different parameters

{"sfwd-lessons_lesson_materials_enabled":"on","sfwd-lessons_lesson_materials":"<p>text<\/p>","sfwd-lessons_lesson_video_enabled":"","sfwd-lessons_lesson_video_url":"","sfwd-lessons_lesson_video_shown":"","sfwd-lessons_lesson_video_auto_start":"","sfwd-lessons_lesson_video_show_controls":"","sfwd-lessons_lesson_video_focus_pause":"","sfwd-lessons_lesson_video_track_time":"","sfwd-lessons_lesson_video_auto_complete":"","sfwd-lessons_lesson_video_auto_complete_delay":"","sfwd-lessons_lesson_video_show_complete_button":"","sfwd-lessons_lesson_assignment_upload":"","sfwd-lessons_assignment_upload_limit_extensions":"","sfwd-lessons_assignment_upload_limit_size":"","sfwd-lessons_lesson_assignment_points_enabled":"","sfwd-lessons_lesson_assignment_points_amount":"","sfwd-lessons_assignment_upload_limit_count":"","sfwd-lessons_lesson_assignment_deletion_enabled":"","sfwd-lessons_auto_approve_assignment":"","sfwd-lessons_forced_lesson_time_enabled":"","sfwd-lessons_forced_lesson_time":"","sfwd-lessons_lesson_video_hide_complete_button":""}

Parameters

  • Sfwd-lessons_lesson_materials_enabled: on /off
  • Sfwd-lessons_lesson_materials: Add lesson material
  • Sfwd-lessons_lesson_video_enabled: on /off
  • Sfwd-lessons_lesson_video_url: Add video url
  • Sfwd-lessons_lesson_video_shown: Set it to before or after completing the steps
  • Sfwd-lessons_lesson_video_auto_start: enable or disable autostart
  • Sfwd-lessons_lesson_video_show_controls: enable or disable controls
  • Sfwd-lessons_lesson_video_focus_pause: enable or disable video pased focused
  • Sfwd-lessons_lesson_video_track_time: Set track time
  • Sfwd-lessons_lesson_video_auto_complete: Set it enable or disable 
  • Sfwd-lessons_lesson_video_auto_complete_delay: Add completion delay time
  • Sfwd-lessons_lesson_video_show_complete_button: Enable /disable mark button
  • Sfwd-lessons_lesson_assignment_upload: on /off
  • Sfwd-lessons_assignment_upload_limit_extensions: Set file extensions
  • Sfwd-lessons_assignment_upload_limit_size: Set file upload size
  • Sfwd-lessons_lesson_assignment_points_enabled: Enable /disable Assignment points
  • Sfwd-lessons_lesson_assignment_points_amount: Add total points
  • Sfwd-lessons_assignment_upload_limit_count: Set assignment upload limited number 
  • Sfwd-lessons_lesson_assignment_deletion_enabled: Enable /disable assignment deletion
  • Sfwd-lessons_auto_approve_assignment: Enable /disable to auto approve assignment
  • Sfwd-lessons_forced_lesson_time_enabled: Enable /disable
  • Sfwd-lessons_lesson_video_hide_complete_button: Enable /disable

 Category

Here you can add the categories of the lesson i.e in the example;

  • Category E, Category E > Category F 

Category E is a parent & Category F is a child while Category E > Category F shows their relation.

Lesson Image

Here you can add the featured image of the lesson. Simply add the link to the featured image in this column.

“Topics” Sheet:

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”.

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 [embed] for the videos. 

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.

Topic Access Settings

The topic access settings can be added here.

You can alter the list displayed by setting different parameters

{"sfwd-topic_course":347,"sfwd-topic_lesson":349}

Parameters

  • Sfwd-topic_course: Add Topic Course ID 
  • Sfwd-topic_lesson: Add Topic Lesson ID

Topic Display Settings

The topic display settings like topic materials, video progression, topic assignments, and forced topic timer, can be enabled here.

You can alter the list displayed by setting different parameters

{"sfwd-topic_topic_materials_enabled":"on","sfwd-topic_topic_materials":"<p><a href=\"http:\/\/localhost\/wordpressqa\/wp-content\/uploads\/2021\/10\/sample-1.pdf\">sample-2<\/a><\/p>","sfwd-topic_lesson_video_enabled":"","sfwd-topic_lesson_video_url":"","sfwd-topic_lesson_video_shown":"","sfwd-topic_lesson_video_auto_start":"","sfwd-topic_lesson_video_show_controls":"","sfwd-topic_lesson_video_focus_pause":"","sfwd-topic_lesson_video_track_time":"","sfwd-topic_lesson_video_auto_complete":"","sfwd-topic_lesson_video_auto_complete_delay":"","sfwd-topic_lesson_video_show_complete_button":"","sfwd-topic_lesson_assignment_upload":"","sfwd-topic_assignment_upload_limit_extensions":"","sfwd-topic_assignment_upload_limit_size":"","sfwd-topic_lesson_assignment_points_enabled":"","sfwd-topic_lesson_assignment_points_amount":"","sfwd-topic_assignment_upload_limit_count":"","sfwd-topic_lesson_assignment_deletion_enabled":"","sfwd-topic_auto_approve_assignment":"","sfwd-topic_forced_lesson_time_enabled":"","sfwd-topic_forced_lesson_time":"","sfwd-topic_lesson_video_hide_complete_button":""}

Parameters

  • Sfwd-topic_topic_materials_enabled: on /off
  • Sfwd-topic_topic_materials: Add topic materials
  • Sfwd-topic_lesson_video_enabled: enable /disable
  • Sfwd-topic_lesson_video_url: Add video url
  • Sfwd-topic_lesson_video_shown: Set it to before or after completing the steps
  • Sfwd-topic_lesson_video_auto_start: Enable or disable it
  • Sfwd-topic_lesson_video_show_controls: Enable or disable it 
  • Sfwd-topic_lesson_video_focus_pause: Enable or disable it
  • Sfwd-topic_lesson_video_track_time: Enable or disable it
  • Sfwd-topic_lesson_video_auto_complete: Enable or disable it
  • Sfwd-topic_lesson_video_auto_complete_delay: Add completion delay time
  • Sfwd-topic_lesson_video_show_complete_button: Enable /disable mark button
  • Sfwd-topic_lesson_assignment_upload: Enable or disable it
  • Sfwd-topic_assignment_upload_limit_extensions: Set assignment file extensions
  • Sfwd-topic_assignment_upload_limit_size: Set assignment file size limit
  • Sfwd-topic_lesson_assignment_points_enabled: Enable /disable the points
  • Sfwd-topic_lesson_assignment_points_amount: Set the assignment points
  • Sfwd-topic_assignment_upload_limit_count: Set assignment upload limit
  • Sfwd-topic_lesson_assignment_deletion_enabled: Set deletion time period
  • Sfwd-topic_auto_approve_assignment:  enable /disable it
  • Sfwd-topic_forced_lesson_time_enabled: enable /disable it 
  • Sfwd-topic_forced_lesson_time: Set lesson timer
  • Sfwd-topic_lesson_video_hide_complete_button: Show /hide button on completion

Category

Here you can add the categories of the topic i.e in the example;
Category X, Category X > Category Y
Category X is the parent & Category Y is a child while Category X > Category Y shows their relation.

Topic Image

Here you can add the featured image of the topic. Simply add the link to the featured image in this column.