Tutor LMS – Export and Import Courses with Google Sheets

In this tutorial, we will show you how to export and import Tutor LMS courses with Google Sheets.

Related tutorials:

• Bulk edit Tutor LMS courses
• Export and import Tutor LMS courses with CSV

We will show you how to connect your LMS WordPress site with your Google Sheets account. After that, you’ll be able to automatically export your Tutor LMS courses to Google Sheets, edit courses in Google Sheets, and import courses from Google Sheets into WordPress.

We will use the WP Sheet Editor plugin. It allows you to view and manage your Tutor LMS courses in an intuitive spreadsheet on WordPress.

We will also use the Google Sheets Sync service. It allows you to sync WordPress and Google Sheets in order to export and import content through WP Sheet Editor.

You need to follow the steps in the sections below in order to export and import Tutor LMS courses with Google Sheets.

1- Set up a spreadsheet for your Tutor LMS courses

You can follow this setup guide to generate a spreadsheet for your Tutor LMS courses.

After generating the spreadsheet, you will be ready to connect WordPress with Google Sheets, export and import courses with a few clicks.

2- Connect WordPress with Google Sheets through WP Sheet Editor

When you subscribe to the Google Sheets Sync service, you will get a helper plugin that will allow you to connect your website with your Google account, the Google API, and the WP Sheet Editor API.

You can follow this installation and configuration guide to learn how to connect WordPress to Google.

3- Export Tutor LMS courses from WordPress to Google Sheets

Exporting your tutor LMS courses from WordPress to Google Sheets has some great advantages:

• You can collaborate with your team to manage your Tutor LMS courses in Google Sheets
• You can access the version history to check and restore previous versions of your course data
• You can view and manage your courses easily in Google Sheets
• You don’t have to edit courses one by one, as you can easily manage your courses in Google spreadsheets

To export your Tutor LMS courses from WordPress to Google Sheets, you need to start by opening the Export tool.

Now you need to select these values to export courses directly to Google Sheets:

1. Select the columns you want to export. You can select specific columns by typing the column names, all active columns, or all columns.
2. 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.
3. Select the “Google Sheets” app.
4. Add a name for this export. You can add a name for this export, and the Google Sheet will inherit that name.
5. Click on Start new export.

After the export process is completed, you’ll see the “View Google Sheet” link.

You can click on it to open the Google Sheet that has been generated with this export.

4- View and manage Tutor LMS courses in Google Sheets

After exporting your online courses’ data to Google Sheets, you’ll be able to view and manage your Tutor LMS courses in Google Sheets.

You can edit existing courses and/or add new courses in the Google Sheet. You can collaborate with your team to manage your courses, access the version history, use Google’s IA features for Google Sheets, etc.

Below you can see a screenshot containing our Tutor LMS courses’ data:

5- Import Tutor LMS courses from Google Sheets into WordPress

Importing Tutor LMS courses from Google Sheets into WordPress has some important advantages:

• You can update thousands of courses by importing from Google Sheets
• You can create new courses by importing from Google Sheets
• You can save a lot of time editing your courses because you don’t have to open and change course details one course at a time
• And lots more!

To import your Tutor LMS courses from Google Sheets into WordPress, you need to first open the Import tool.

Second, select the Google Sheets file you want to import:

• Source: Google Sheets
• Google Sheet file: Select the file you’ll import here. If you don’t find it, click on “refresh”.
• Click on Next.

Third, select the columns you will import from Google Sheets into WordPress.

You can Import all the columns or Select individual columns to import.

Fourth, select how you want to import the data.

In this example, we will Create new items and update existing items, so we need to match the rows in Google Sheets with the fields on WordPress. We’ll use the ID field.

Click on Next.

Finally, you need to click on The preview is fine, start import.

Export and import Tutor LMS courses with Google Sheets

We have demonstrated how to use the WP Sheet Editor plugin and the Google Sheets Sync service to export and import Tutor LMS courses with Google Sheets. The advantages of using Google Sheets to manage Tutor LMS courses are evident.

Google Sheets makes it easy to organize and edit course data in bulk. You can efficiently and quickly edit course titles, descriptions, prices, and other details.

Google Sheets allows you to collaborate with your team. Multiple individuals can work on the Google Sheets spreadsheet simultaneously to edit or create Tutor LMS courses.

Being able to import and export data between Tutor LMS and Google Sheets simplifies your online course management, saving time and reducing errors.