WordPress – Export and Import Pages with Google Sheets

In this tutorial, we will show you how to export and import WordPress pages with Google Sheets.

You’ll be able to connect your WordPress site to Google Sheets, and then export WordPress pages to Google Sheets and import pages from Google Sheets.

The best part is that you won’t need to install any web browser extensions nor run any complicated scripts. Everything will be done in one place: the WordPress admin dashboard.

For this, we will use the WP Sheet Editor plugin. It allows you to manage pages, posts, products and any other custom post type in a spreadsheet.

Also, we will use the Google Sheets Sync service. It allows you to connect WordPress with Google Sheets to export and import content easily.

1- Connect your WordPress site to your Google account

After signing up to the Google Sheets Sync service, you’ll get a helper plugin that will allow you to connect your WordPress site to Google Sheets.

You can follow this guide to learn how to do it. We’ll guide you step by step to connect your WordPress site to your Google Sheets account, the Google API, and the WP Sheet Editor API.

2- Open the WordPress pages spreadsheet

To open the pages spreadsheet, go to WP Sheet Editor > Edit pages.

You’ll see all your WordPress pages displayed in the spreadsheet as rows, and all their fields as columns.

Once you have connected your WordPress site to Google Sheets and opened the WordPress pages spreadsheet, you’re ready to start exporting and importing pages with Google Sheets.

3- How to export WordPress pages to Google Sheets

Let’s see how to export pages from WordPress to Google Sheets. Exporting pages to Google Sheets can be really useful to have a backup of your WordPress pages or to allow your team to create or edit pages using Google Sheets.

We need to start by opening the Export tool.

After that, we need to configure the export by selecting these values:

1. Select the columns you want to export. You can export specific columns by typing the column names, all the active columns in the spreadsheet, or all the columns (including inactive/hidden columns).
2. Select the rows you want to export. In this case, we will export all the rows/pages.
3. Select the Google Sheets app.
4. Add a name for this export, and the Google Sheet that will be generated with this export will inherit that name.
5. Click on Start new export.

After the export process is completed, you will see the View Google Sheet link, so you can click on it to open the Google Sheet that has been generated.

4- Create and edit your WordPress pages on Google Sheets

When you export your WordPress pages to Google Sheets, this is what your Google spreadsheet will looks like:

Important to import Google Sheets files:

If you want to import WordPress pages from Google Sheets, you will first have to make an export containing even one row and add the pages in the rows of that file. The reason for this is that the Google Sheets Sync service only recognizes files that have been created with the service itself. This is important because we protect your privacy by not accessing any other files in your Google account. The service will only read and import Google Sheets files that have been created with our service.

You can read our privacy policy here.

5- How to import WordPress pages from Google Sheets

Importing WordPress pages from Google Sheets can be really useful if you want to add new pages to your site or if you want to update existing pages. You won’t need to add or edit the pages one at a time. Just add the data to Google Sheets and import the file to create/update your pages.

Let’s start by opening the Import tool.

Once you’re on the import tool, you need to select the file you want to import:

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

You need to select which columns you want to import from Google Sheets.

In this case, we will import all the columns, but you could select individual columns to import.

Now you need to select how you will import the pages. You can create new pages and update existing pages, import all the rows as new pages, only update existing pages and ignore the new pages, or only create new pages and ignore the existing pages.

Note – If you will update existing pages, you will need to match the information using a specific field. In this case, we recommend using the page ID.

Click on Next.

Finally, you’ll see a preview of what the pages will look like on the spreadsheet once they’re imported.

If everything is OK, you need to click on The preview is fine, start import, and your WordPress pages data will start importing.

As you can see, with WP Sheet Editor and Google Sheets Sync, you can export and import WordPress pages with Google Sheets.