Struggling with how to embed Google Sheets in WordPress?
While there are lots of useful WordPress table plugins that help you add tables on your site, sometimes you just need the full flexibility of Google Sheets and it’s better to embed your table directly from Google Sheets.
This ensures that your spreadsheet data is always up-to-date and, for large spreadsheets, it takes the processing responsibilities off your WordPress site’s server.
Thankfully, it’s pretty easy to embed Google Sheets in WordPress – and in this post, I’ll show you exactly how to do it.
I’ll give you a few different options, ranging from the simplest solution of embedding directly from Google Sheets to some Google Sheets WordPress plugins that offer some interesting possibilities, including importing data from Google Sheets to a self-hosted table on your site.
Let’s dig in!
How to Embed Google Sheets in WordPress
In this first section, I’ll show you how to use the built-in Google Sheets embed option to add your spreadsheet to WordPress. This method doesn’t require the use of any plugins – all you do is generate the embed code from the Google Sheets interface and then add it to the WordPress editor.
For this tutorial, we’ll assume that you’ve already created the spreadsheet that you want to embed. If not, do that first and then come back here for the WordPress-specific parts.
For this example, I’ve created a simple spreadsheet with some random financial dummy data. Now, let’s embed it in WordPress.
1. Generate Google Sheets Embed Code
To get started, you’ll be working in the Google Sheets interface – make sure to open the spreadsheet that you want to embed.
In the Google Sheets interface, open the File menu and choose Publish to the web:
This will open a popup interface. Go to the Embed tab in that popup and choose whether you want to embed that entire document or just an individual sheet (useful if you have multiple sheets but only want to include one of them on your WordPress site.
If you expand the Publish content & settings area, you’ll also get an option to decide whether or not to “republish” your spreadsheet when you make changes to the existing document:
- If you leave the box checked, your embedded spreadsheet will always be in sync with what you see in the Google Sheets interface. As soon as you change something, that change will automatically update on your WordPress site.
- If you uncheck the box, you’ll need to manually republish your spreadsheet when you want to update its data. Otherwise, the embedded version on WordPress will basically just be a snapshot of the spreadsheet’s current version.
Once you’ve made your choices,
This article was written by Colin Newcomer and originally published on Learn WordPress with WPLift.