In our previous articles, we talked about embedding PDF files and Word documents in WordPress. But this time we want to show you something else. We will share with you a tutorial on how to embed Google Sheets in WordPress.
Google Sheets is an incredibly useful, versatile and customizable tool.. They’re mostly used in accounting and math-related tasks, but their power goes far beyond that. Thanks to the numerous handy features they come with, Google Sheets can be used for topic billing, data analysis, employee time tracking, calendars, charts, etc. It is also a great choice when If you use them in your daily work, this is probably a time when you will want to add them to your WordPress website for future Visitors to see. And we are here to help you do that.
In this tutorial, we’ll show you two ways you can embed Google Sheets in WordPress. You will discover:
If you wish, you can take a look at our step-by-step video or follow our detailed instructions below to guide you through the process.
Adding Google Sheets to your sheets and posts is pretty easy. You just need to get the iframe link and add it to your website. We will guide you step-by-step through this process.
Note: You can follow the same steps if you want to embed Google Docs, Google Slides and Google Drawings in WordPress.. As for Google Forms, you should use a different method, which we discuss in a separate article on how to embed a Google Form in WordPress.
Publish Google Sheets
The first thing you should do Make sure your Google Sheets are published and ready for everyone to see. To do this, go to your Google Drive and open the document you want to embed.
In the upper left corner, click on Fileand select from the drop down menu Publish to the Web.
Next, it’s time to publish the document. to get the iframe bury tab.
before pressing Publish button, you can choose whether to publish the entire document or just individual pages. Also, any changes you make on the original page will be republished automatically. If you want to change this setting, click on it. Publish Content and Settings under the box and uncheck Automatically Republish When Changed choice.
After everything is set, finally Publish button and then get the shareable link.
Embed Google Sheets URL
Copy the iframe code to embed Google Sheets in WordPress. Next, go to your admin control panel. choose Pages > Add New and paste the link into the text editor.
To embed in Gutenberg, add: Custom HTML block your page and paste the link in the HTML field.
And with that, you have successfully added a Google Spreadsheet to your website.
Meanwhile, if you want change the size of the page, you can specify its width and height in the iframe code. For example, we want our page to be 1100px wide and 300px high. We will edit the code like this:
<iframe src="https://docs.google.com/spreadsheets/d/e/2PACX-1vSz3eSCF1FeAWxjwwkcCprTRCIwUxHnNFPtIsOeAFZyBX_MdhSiIGPwxSHbZUfedUV_XQW6j33AyPKg/pubhtml?widget=true&headers=false" style="height:300px;width:1100px"></iframe>
Another way to embed Google Sheets in WordPress is to use plugins.
As a website building platform, WordPress comes with a lot of built-in features that allow you to create some pretty amazing websites. But you need WordPress plugins to significantly increase the power of your site. Whatever action comes to mind, you will most likely find a plugin made for it. official WordPress plugin library. Embedding Google Sheets in WordPress is no different.
While you will get few results for your search query, in our opinion the best plugin on the market right now EmbedPress.
Not only for adding Google Sheets to your sheets, but also for sharing audio and video files, posts, etc. from over 75 sources. You can also use it to embed.
EmbedPress is regularly maintained and tested up to the latest version of WordPress. It currently has over 9,000 active users.
A premium version of the plugin is also available; It ranges from $49 for a single site to $299, which is a lifetime subscription that lets you use the plugin on an unlimited number of websites.
Still, the free version of EmbedPress will suffice. It can do exactly what you need and that is for embed Google Sheets in WordPress. other than that, Lets you embed Google documents, slides, forms, illustrations, maps and content from Twitch and Wistia for free.
Install Plugin
To start using the plugin, we must first add it to our website. From your admin dashboard, navigate to: Plugins > Add New and search for EmbedPress. Then install and activate the plugin.
this EmbedPress section will now appear in your menu, but there are no specific settings you need to change at this point. You will have the option to edit your Google page URL, but only after you embed it (more on that in a second).
Copy Google Spreadsheet URL
Now that the add-on is active, let’s go back to your Google Drive. Again, you have to make sure the document is published, but this time we don’t need the iframe code.
Once you click Publish to the Web, choose Connection tab and click Publish.
The same options are available as when our goal was to get the iframe code, but now we can do that too. choose the publishing format (web page, CSV, PDF, etc.).
After everything is set, Publish Click the button and you will get the shareable link.
Embed Google Sheets
The next thing you need to do is copy the link and go to your WordPress dashboard. choose Pages > Add New and paste the link visual editor.
In Gutenberg, “+Click the ” symbol and find the EmbedPress block. Create the dropdown selection Google Sheets.
The Google Sheets block will now be added to your page and all you have to do at this point is paste the Google Sheets URL into the specified field. After that, press the button bury button.
And that’s it. Your Google Spreadsheet has now been added to your website. Don’t forget to save the changes and Publish button. If you want to edit your URL at any point, simply select the pencil icon.
Solution
Google Sheets are useful, organized, and powerful, and it’s good to know how to embed them on your website. Both methods we are discussing are quite simple and require minimal effort from the user. The plug-in-free way may be sufficient, but we wanted to offer you an alternative. It doesn’t hurt to know how to embed Google Sheets in WordPress using a plugin that also gives you the chance to embed some additional file types. However, it is up to you to choose the method you feel more comfortable with.
Support our work ❤️
If you enjoyed this article, consider leaving a tip to help us keep publishing great content.
