How to Embed Google Sheets in WordPress

With the help of EmbedPress, you can add Google Sheets to WordPress, using just a URL.

Google Sheets is a spreadsheets program and it is a part of a free, web-based software office suite offered by Google along with Google Drive. It allows users to create, edit and upload spreadsheets online while working with other users in real-time scenario.

EmbedPress is a reliable and valuable plugin. With EmbedPress, it is very easy to embed Google Sheets in WordPress, you don’t need to entangle around with embed codes. All you need is the URL of spreadsheet that you have published on Google sheets.

Here’s how to embed any Google Sheets into your WordPress site, using the EmbedPress plugin and a URL.

Step #1. Install the EmbedPress Plugin

EmbedPress is a useful plugin that improves capabilities of WordPress and allows users to embed videos, documents, audio files and more.

Install EmbedPress in your WordPress site and it will become far more powerful and efficient.

Click here to find EmbedPress on WordPress.org.

Step #2. Get the URL of your Google Sheet

Before you can embed your Google Sheets into WordPress, you need to make sure that it is published and visible to others to see.

  • Go to Google Sheets, Login With the help of your Gmail Account.
  • You can either create new spreadsheet or upload it from your Computer.
  • Click on File option, dropdown menu will appear click on “Publish to the web”.
  • Click the blue “Publish” button, as shown in the image:
  • Click on “OK” button in the dialog box that appears after clicking on publish button.
  • A link will be generated, your spreadsheet will be published and you can utilize this URL to embed it in your WordPress Site.

Before you go any further, let’s check that your URL can be embedded on other sites:

  • Your URL should end in /pubhtml
  • Paste the URL into a different browser where you aren’t logged into Google. Can you still see the spreadsheet? If you can’t, then the spreadsheet hasn’t been correctly published to the web.

Step #3. Publish the Google Sheet embed in WordPress

Now you have the Google Sheet URL, you can add it to WordPress.

  • Go to your WordPress site.
  • Edit a post or page.
  • Click the + icon in the top-left corner of editing area.
Add a Google Sheets embed in WordPress
  • Search for the “Google Sheets” block in the “EmbedPress” area:
Google Sheets embed blocks for Gutenberg
  • Enter the URL for your Google Sheet:
Add a URL to a WordPress post for a Google Sheets embed
  • Click the “Embed” button and you’ll now see your Google Docs embed:
Add a Google Sheets embed to a WordPress post
  • Publish your WordPress content and Google Sheet will be embedded for users to see, as shown in the image:
Publish a WordPress post with a Google Sheets embed

Step #4. Edit Your Google Sheet Embed

While editing your WordPress content, you can also edit your embed, thanks to EmbedPress.

  • Hover over the embed, and an pencil icon will appear. This icon will show “Edit URL” if you hover over it.
  • Click the pencil and you will be able to edit your embed:
Edit a WordPress post with a Google Sheets embed

in Embed SourcesGoogle Embeds

Related Articles

Start today!