Custom Post Type Maker – Export and Import with Google Sheets

Let’s see how to export and import Custom Post Type Maker content with Google Sheets.

In a previous tutorial, we showed you how to bulk edit Custom Post Type Maker content using an intuitive spreadsheet on WordPress.

Here, we will show you how to connect your WordPress site to your Google account in order to export and import content with Google Sheets.

We will use the WP Sheet Editor plugin, which allows you to manage your posts, pages and custom post types in a spreadsheet.

We will also use the Google Sheets Sync service, provided by WP Sheet Editor. This service works with all WP Sheet Editor spreadsheets, and allows you to export and import content with Google Sheets.

You need to follow the steps in the sections below in order to export and import Custom Post Type Maker content with Google Sheets.

1- Set up the Custom Post Type Maker spreadsheet

You can follow this setup guide to generate a spreadsheet bulk editor for any of your post types created with the Custom Post Type Maker plugin.

Note → After generating the spreadsheet, come back to this tutorial.

2- Connect WordPress to Google Sheets

When you sign up to the Google Sheets Sync service, you’ll get a helper plugin that allows you to connect your WordPress site to your Google account, the Google API, and the WP Sheet Editor API.

You can follow this set up guide to learn how to connect your WordPress site to your Google Sheets account through WP Sheet Editor.

3- Export from Custom Post Type Maker to Google Sheets

After connecting your WordPress site to your Google Sheets account, you can proceed to export your Custom Post Type Maker content to Google Sheets.

Start by opening the Export tool.

Now you need to select these values to export from Custom Post Type Maker to Google Sheets:

• What columns do you want to export: You can type specific column names, export all active columns, or all columns.
• Which rows do you want to export: In this case, we will export all the posts.
• What app will you use to edit this file: Select the Google Sheets app.
• Name of this export (optional): You can add a name for this export, and the Google Sheets file will inherit this name.
• Click on Start new export.

After the export process is complete, 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 Custom Post Type Maker content in Google Sheets

As you can see in the screenshot below, we have exported the content of our post type “Lyrics”, created with Custom Post Type Maker, to Google Sheets.

We can save the Google Sheet as a backup, edit existing post data, or even add new posts to import changes or new posts from Google Sheets to WordPress.

5- Import Custom Post Type Maker content from Google Sheets

There are some things you need to keep into account before importing from Google Sheets into WordPress:

• To protect your privacy, our Google Sheets Sync service doesn’t read files that have not been created with the service itself.
• In other words, the service doesn’t recognize files that were not first exported from WordPress to Google Sheets using the service.
• This means that we don’t have any access to other files on your Google account; not even to other Google Sheets files.
• Therefore, to import a Google Sheets file, you’ll need to first export the info.
• Once you’ve exported it, you can edit existing data or create new data in Google Sheets.

First, open the Import tool.

Second, select the Google Sheets file you will import by selecting these values in the Import tool:

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

WP Sheet Editor will automatically detect the columns, and you can Import all the columns or Select individual columns to import.

In this case, we will import all the columns.

Fourth, select how you will import the information.

In this example, we will Create new items and update existing items.

Note. If you select any option to update existing items, you need to match the rows in the Google Sheet with the rows on WordPress by using a specific field as an identifier. In this case, we will use the ID field as an identifier.

Click on Next.

Finally, you will see a preview of what the info will look like in the spreadsheet once it’s imported.

If everything is OK, click on The preview is fine, start import to start the import process.

Export and import Custom Post Type Maker content with Google Sheets

Besides bulk editing Custom Post Type Maker content with WP Sheet Editor, you can connect your WordPress site to your Google account using the Google Sheets Sync service.

This will allow you to export and import content with Google Sheets.