Google Sheets isn’t just another tool—it’s a game-changer for organizing and analyzing data. But did you know you can take its versatility a step further?
Imagine sharing your sheets directly on your website, letting visitors view your data without needing any additional links or downloads. Not only is this efficient, but it also provides a seamless experience for your audience.
If the idea sounds great, but you’re scratching your head thinking, “How do I embed Google Sheets in WordPress?”, Don’t worry! This post is here to guide you through the process. By the end, you’ll be confidently embedding Google Sheets in your WordPress site anytime you wish.
Let’s dive in!
Method 1: Embedding Google Sheets Without a Plugin
In this method, you can directly embed a Google Sheet without the help of a plugin.
Step 1: Publish Google Sheet & Get Embed Code
Open your sheet and click on the File menu at the top.
N.B. You must log in to Google and make sure the sheet is published and visible to others.
Click on the ‘Share’ option; you will find ‘Publish to the web’.
Now, click on the Embed tab and copy the embed code.
Step 2: Embed the Google Sheet
Now, open the page/post where you want to embed the Google sheet. Click on the ‘Add Block’ button and search for ‘Custom HTML’ .
Add the block by clicking on it.
Paste the code that you copied earlier inside the block and hit the ‘Save or Update’ button. With the default code, you may see a very small screen showing the Google sheet. If you would like to make it bigger, then add ‘width=”800″ height=”800’ at the very last of the code but before ‘></iframe>’.
<iframe src="https://docs.google.com/spreadsheets/d/e/2PACX-1vRdNGBPPTrLEXEYRW0KphkL_z2fPF1plHw5G0jnadE07Dmt5_DFp0YzsrVcqUIl70Kg5bXoHb4Nzf0i/pubhtml?widget=true&headers=false" width="1024" height="1024"></iframe>
For you, I have given you a sample above. You may alter the width and height according to your needs.
Afterward, you will see results like the ones below.
Method 2: Embedding Google Sheets With the Help of a Plugin
All you have to do is follow these simple steps, and then you will be able to embed Google Sheets within a few minutes.
Step 1: Install the EmbedPress Plugin
EmbedPress is the leading embed plugin for WordPress. Along with Google Sheets, you can embed anything like Google Docs, Slides, YouTube, Instagram, Vimeo, Facebook, and more.
Let’s install the plugin. Go to your WordPress Dashboard and navigate to Plugins > Add New. Then search for EmbedPress and install & activate the plugin.
Step 2: Publish Your Google Sheets
Now go to your Google Sheets and click on the File menu at the top.
N.B. You must log in to Google and make sure the sheet is published and visible to others.
Click on the ‘Share’ option; you will find ‘Publish to the web’.
Click it, and publish publish-related setting will appear on your screen. Click on the publish button, and you will find the publish link of your Google sheet.
You can use this URL to publish your sheet on different websites.
Step 3: Embed Your Google Sheet
To publish on your website, login to your dashboard, then create or edit an existing page/post where you want to publish your Google sheet.
Click on the Add block button and search for EmbedPress.
Now paste the URL link that you copied earlier and hit the Embed button.
You will be able to see your sheet on the screen. Later on, click on the publish or update button.
Final Words
Now, your Google sheet is fully embedded in your WordPress website. In this way, you can embed as many Google sheets as you want in your website. If you face any problems, feel free to let me know. I will try to help as much as I can.
If you liked the post, feel free to share it with your friends, and don’t forget to share your thoughts in the comment box below.
Changelog
- Updated on 2024-10-27 (Uzzal Raz Bongshi)
- Added ‘Method 1: Embedding Google Sheets Without a Plugin’.
- Updated images.
- Updated details.
Leave a Reply