In this tutorial, we will show you how to export WordPress posts to Google Sheets. We’ll be able to easily connect our WordPress site with our Google Sheets account and directly export our posts’ data to a Google spreadsheet.
Related tutorial:
For this, we will use the WP Sheet Editor plugin and the Google Sheets Sync service.
The WP Sheet Editor plugin allows you to view and manage your WordPress posts, pages and custom post types created by third-party plugins, using an intuitive spreadsheet. This spreadsheet allows advanced search, bulk editing, export and import WordPress content. It boosts your productivity and saves you a lot of hours of work.
You can download the plugin here:
Download Posts, Pages, and Custom Post Types Spreadsheet Plugin - or - Check the features
The Google Sheets Sync service, provided by WP Sheet Editor, allows you to directly export and import content between WordPress and Google Sheets. It works with all the WP Sheet Editor spreadsheets running in the backend, so you can export/import posts, pages, products, downloads, events, memberships, and any custom post type, including custom fields.
You can sign up to the service here:
Sign up to the Google Sheets Sync Service - or - Check the features
You need to follow these steps to export posts from WordPress to Google Sheets:
1- Connect WordPress to Google Sheets
When you connect to our 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 install and set up the Google Sheets Sync helper plugin.
It’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- Search or select the posts you want to export
Note – If you want to export all your posts, skip this section.
If you don’t want to export all your WordPress posts to Google Sheets, WP Sheet Editor allows you to run advanced searches to filter them. Besides, you can manually select the posts you want to export.
a) Search for posts
To search for the posts you want to export, you need to start by opening the “Search” tool.
Now you can apply any of the different search filters. In fact, WP Sheet Editor allows you to use any field as a search filter, including third-party, custom fields.
In this example, we will search for all the published posts within the “Blog” category. For this, we just need to enter the category and add an advanced filter to search for posts by status.
After running the search, all the posts that match the search terms will be displayed on the spreadsheet. You’ll see the active search filters above the spreadsheet.
b) Select the posts
WP Sheet Editor allows you to manually select the posts you want to export to Google Sheets.
You just need to tick the checkbox of each post you want to export.
3- Export your WordPress posts to Google Sheets
To export posts from WordPress to Google Sheets, you need to start by opening the Export tool.
Now you need to select these values to export your WordPress content to Google Sheets:
- Select the columns you want to export. You can export all columns, all the active columns only, or select specific columns.
- Select the rows that you want to export. Whether you want to export all posts or the results of a specific search, you have to select the option to export the results of the current search. On the other hand, if you only want to export manually selected posts, you should select the other option.
- Select the Google Sheets app
- Enter a name for this scheduled one-time export
- Click on Start new export
After you have exported your posts to Google Sheets, you will see a link to open the new Google Sheet that has been automatically created on the Google account you have connected your site to.
Click on View Google Sheet to open the file.
As you can see here, we have exported all our WordPress posts data directly to Google Sheets.
The Google Sheets Sync service for WP Sheet Editor doesn’t require you to install any browser extensions nor run any complicated scripts. You can do it all from your WordPress dashboard.