Custom Post Type UI – Import Post Types from Google Sheets

In this tutorial, we will show you how to import post types created with the Custom Post Type UI plugin from Google Sheets.

Related tutorial: How to Export from Custom Post Type UI to Google Sheets

We need to install and activate two things:

First, we will use the WP Sheet Editor – Post Types plugin.

It allows you to view and manage posts, pages and custom post types, using an intuitive spreadsheet on the WordPress admin dashboard.

In this case, it will allow you to view and manage any post type that you’ve created with the Custom Post Type UI plugin.

Second, we will use the Google Sheet Sync service, provided by wpsheeteditor.com. It allows you to export and import your WordPress content with Google Sheets.

Once you have installed both plugins, you need to follow the steps below to import Custom Post Type UI content from a Google Sheets file.

1- Prepare the Google Sheets file you will import

You need to prepare the Google Sheets file you want to import, but there are some things you need to take into account:

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

Here’s a tutorial on how to export from Custom Post Type UI to Google Sheets.

Once you export the file, you’ll have a Google Sheet like this:

2- Open the “Import” tool

Once you have prepared the data you want to import, you need to open the Import tool.

3- Select the Google Sheet you will import

You need to select the Google Sheets file you want to import. Remember that only Google Sheet files generated with our service will be recognized to be imported.

Select these values in the Import tool:

• Source: Select Google Sheets here.
• Google Sheet file: Here you need to select the file you want to import. If you don’t find it, you can click on the refresh button.
• Click on Next.

4- Select the columns you want to import

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

In this example, we will import all the columns.

5- Select how you want to import the custom post type data

In this example, we will create new items and update existing items. However, you could import all the rows as new, only update, or only create items.

Note. If you update existing items, you can match the information by using a specific field as an identifier. In this case, we will use the ID field.

Once you’ve selected how you want to import the data, click on Next.

Finally, you’ll see a preview of what the import will look like once it’s imported. You can click on The preview is fine, start import.

As you can see in the screenshot below, we have updated 25 items and created 25 items.

In this tutorial, we have shown you how to import data for any post type created with the Custom Post Type UI plugin from Google Sheets.

You can easily export and import Custom Post Type UI content using Google Sheets.