How to Embed Google Sheets in WordPress

With the help of EmbedPress, you can embed 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 the real-time scenarios.

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 the 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 the 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. Embed Google Sheets & publish 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 editing area.
• Search for the “Google Sheets” block in the “EmbedPress” area:

• Enter the URL for your Google Sheet:

• Click the “Embed” button and you’ll now see your Google Docs embed:

• Publish your WordPress content and Google Sheet will be embedded for users to see, as shown in the image:

Step #4. Edit Your Google Sheet Embed #

While editing your WordPress content, you can also edit your embed, thanks to EmbedPress. Click on your embed and then click on the pencil icon as shown below. 

How to Embed Google Sheets In Elementor With EmbedPress #

You can use EmbedPress with Elementor to embed Google Sheets in your WordPress website. Follow these steps to embed any Google Sheets on your website using the Elementor Editor.

Step 1: Select The EmbedPress Element #

First, create a new page from your WordPress dashboard by navigating to Pages→ Add New and then click on the blue ‘Edit With Elementor’ button. Then search for the ‘EmbedPress ’ element from under the ‘ELEMENTS’ tab in Elementor Editor.

Step 2: Enter The URL In Elementor #

Now click on the ‘Content’ tab in Elementor Editor and enter the URL of your Google Sheets embed in the ‘Embedded Link’ section as shown below. 

Your Google Sheets will be automatically embedded in Elementor.

You can also embed Google Sheets in Elementor by using the ‘EmbedPress Document’ widget in Elementor. Find out more about this widget and how to use it in this step-by-step tutorial.

Embed Google Sheets In Classic Editor #

Open up your preferred posts or page’s on WordPress Classic Editor. 

Add your Google Sheets URL into the content area, with the “Visual” tab enabled. You will see a purple background with a “Loading your embed” message. And within a few moments, your URL will automatically be transformed into an embed of your Google Sheets.

If you are facing problems and require further assistance, feel free to contact our support or join our Facebook Community to get in touch with WordPress experts and content creators like yourself.