In this tutorial, we will show you how to export and import Tutor LMS courses using CSV files.
Related tutorial:
Exporting and importing Tutor LMS courses with CSV files offers several advantages:
- Efficiency: It allows you to quickly create or update multiple courses at once, saving time and effort.
- Bulk Editing: Easily make changes to course details, such as titles, descriptions, and prices using Excel, Google Sheets, or any other CSV editor.
- Structured Data: CSV files provide a structured format for data, reducing the chance of errors during course management.
- Backup and Restore: You can use exports as backups and quickly restore courses if needed by importing the data.
- Advanced Searches: Helps in advanced searches and filtering, enhancing course organization.
Considering these advantages, it’s easy to see that using CSV files for exporting and importing provides a flexible and practical approach to course management in Tutor LMS.
We will use the WP Sheet Editor plugin, which allows you to view and manage posts, pages, and custom post types (courses, products, etc.) using a spreadsheet on WordPress.
You can download the plugin here:
Download Posts, Pages, and Custom Post Types Spreadsheet Plugin - or - Check the features
You need to follow the steps in the sections below in order to export and import Tutor LMS courses with CSV files.
1- Generate a spreadsheet for Tutor LMS courses
The first thing to do is generate a spreadsheet for bulk managing your Tutor LMS courses.
In a previous tutorial, we included a section called “Set up a spreadsheet for Tutor LMS courses” where we show you how to do it.
Optionally, you can follow this setup guide.
After generating the spreadsheet, you will be ready to export and import courses with a few clicks.
2- Export Tutor LMS courses to a CSV file
WP Sheet Editor allows you to export your Tutor LMS courses to a CSV file, which you can open with Excel, Google Sheets, or any other CSV editor.
You need to start by opening the Export tool.
Now you need to select the following values in order to download your Tutor LMS courses in a CSV file to your computer:
- Select the columns you want to export. You can select specific columns by typing the column names, all active columns, or all columns.
- Select the rows you want to update. You can export all the rows (courses), all the courses from a specific search, or all the manually selected courses in the spreadsheet.
- Select the app you’ll use to open the CSV file. You can select Microsoft Excel, Google Sheets, or other options. The plugin will generate a compatible CSV file for these software programs.
- Add a name for this export. You can add a name for this export; this is optional.
- Click on Start new export.
After doing this, you will download a CSV file to your computer, which you can open with the selected CSV file editor.
Below you can see a screenshot of our downloaded CSV file containing our Tutor LMS courses:
After exporting our online courses to a CSV file, we can edit existing courses, add new courses, update course pricing, course duration, etc.
Then, we’ll be ready to import our Tutor LMS courses from the CSV file into WordPress.
3- Import Tutor LMS courses from a CSV file
In order to import Tutor LMS courses from a CSV file into a WordPress site, we need to first prepare the CSV file we will import.
This CSV file may contain changes to existing courses or new courses.
Once we’re ready to import our CSV file, we need to open the Import tool.
Next, you need to select the CSV file you want to import by selecting these values:
- Source: CSV file from my computer
- Click on Choose File and select the CSV you want to import.
- Click on Next.
Now, you need to select the columns you want to import.
You can Import all the columns or Select individual columns to import.
After that, you need to select how you will import your Tutor LMS course data.
In this example, we will Create new items and update existing items, and we will match the courses by ID.
Once done, click on Next.
Finally, you’ll see a preview of what the data will look like on the spreadsheet.
If everything is OK, you need to click on The preview is fine, start import.
Export and import Tutor LMS courses!
With WP Sheet Editor, you can easily export and import Tutor LMS courses using CSV files. This allows you to manage your courses in Excel, Google Sheets, or any other CSV editor.