Google Sheets is a powerful tool for managing and displaying data. Being able to integrate Google Sheets into WordPress is a great way to present your data and make it accessible from anywhere on the web, without having to download software or create a separate account.
If you’ve ever tried to integrate a Google spreadsheet into your WordPress site, you know it can be a bit tricky. Fortunately, with the right tools, you can get it done, and we’ll show you how!
Manually adding HTML code to embed Google Sheets in WordPress
If you’re comfortable with code, you can manually add the HTML code needed to embed your Google document.
Step 1: Open the document you want to embed and click on “File.”
Step 2: From the dropdown menu, select “Share > Publish to the web.”
One way is to simply embed the entire spreadsheet.
To do this, go to “File > Publish to the web > Embed.” Select the “Entire document” option and choose the desired publishing format. Click on “Publish,” then copy the provided code and paste it into your WordPress article or page.
You can also embed individual sheets from a spreadsheet.
To do this, go to “File > Publish to the web > Embed” and select the sheet you want to embed. Click on “Publish,” then copy the provided code and paste it into your WordPress article or page.
Step 3: Next, open the editor of your WordPress article or page. In the text editor field, switch from “Visual” to “Text.”
Step 4: Paste your copied code where you want your embedded document to appear on your page or article.
Step 5: Press “Publish” and preview your article to see the embedded Google spreadsheet in action.
Important!
✓ When you publish a Google spreadsheet to the web, people can see the data. Be careful when publishing sheets that contain private or sensitive information.
✓ Any changes you make to the original document will be updated in the published version.
Using a plugin to embed Google Sheets in WordPress
If you’re looking for an easier way to embed Google Sheets into your WordPress site, there’s a plugin for that. It’s called EmbedPress and allows you to easily embed any public Google spreadsheet into your WordPress articles or pages.
EmbedPress is a reliable and valuable plugin. With EmbedPress, integrating Google Sheets into WordPress is very easy, and you don’t need to bother with custom codes. All you need is the URL of the spreadsheet you have published on Google Sheets.
Step 1: Install and activate the plugin.
In your WordPress dashboard, look at the left sidebar and click on “Plugins > Add New.”
Click on “Add.” In the search bar, search for EmbedPress. Click on “Install,” then click on “Activate.”
Step 2: Get the URL of your Google spreadsheet.
To start, make sure your Google spreadsheet is published and visible to others.
Go to Google Sheets and sign in with your Gmail account. You can either create a new spreadsheet or import it from your computer. Click on the “File” option, and a dropdown menu will appear, click on “Publish to the web.”
Step 3: You can choose to embed the entire document or just a sheet. Make sure to publish it as a web page. Copy the link.
Step 4: Go back to WordPress, look at the left sidebar and click on “EmbedPress > Shortcode.”
Step 5: EmbedPress integrates directly with Classic, Gutenberg, and Elementor editors. But for other page builders, you can use the Shortcode feature of EmbedPress. To generate a shortcode, simply insert your link, click on the “Generate” button, then copy your shortcode.
Step 6: In the text editor field, paste the shortcode and click on “Publish.”
Using DocPress to directly publish Google Sheets data in WordPress
If you’re looking for a smoother way to publish your Google Sheets content on a WordPress site, you might want to try DocPress. This Google Docs add-on allows you to publish content created in Google Docs on your WordPress site.
Instead of using the traditional WordPress editor, you’ll be working directly in Google Docs.
Tip: Tables with more than 400 cells will be pasted without a link in your document. You can’t expand a previously linked table beyond 400 cells.
Step 1: On your computer, open a spreadsheet in Google Sheets in Google Chrome or Firefox.
Step 2: Select the cells you want to place in Google Docs. At the top, click on “Edit > Copy.” You can also use CTRL + C.
Step 3: On your computer, open a document or presentation in Google Docs or Google Slides.
Step 4: Click where you want to place your table, then click on “Edit > Paste,” or simply click CTRL + V.
Step 5: Choose “Link to spreadsheet” and click on “Paste.”
Step 6: Install DocPress and in the main toolbar, click on “Add-ons > DocPress.it > Export.”
Step 7: In the right sidebar, click on “Export.”
Step 8: Select the desired options and click on “Export”: SEO link options, image handling, post status, preview.
Step 9: After clicking the export button, it will take a few seconds for your article to process. This depends on the size of the article and the number of images it contains. Once the article is processed, you will see a confirmation screen with the preview link. Please make sure you are logged into your WP site to preview the article, otherwise, you will get an error.
If you want to make changes to a document, you can export it again and the changes will be automatically reflected on your website, no need to manually embed anything.
BONUS TIP!
You can also edit the table you embedded from your Google spreadsheet within the Google Docs file where you pasted it. Here’s how:
- On your computer, open a document or presentation in Google Docs.
- Click on a chart or table to select it.
- In the top right corner of the chart or table, click on Link options to open the source.
- You can now edit the original file.
Conclusion
All the methods we’ve explored are relatively simple to set up and use for integrating Google Sheets into WordPress. If you have a Google spreadsheet you want to share with the world, try one of these methods. DocPress is our preferred method as it is so easy to set up and maintain, but all three will get the job done. So, what are you waiting for? Start integrating your Google Sheets into WordPress today!
About DocPress.it
Looking for a way to make your blogger life easier? Constantly finding yourself manually copying and pasting Google documents into WordPress articles? If so, then DocPress is the perfect solution for you. It’s an add-on for Google Docs that allows you to automatically export your documents and import them into your WordPress site.
All you have to do is install the add-on and connect it to your WordPress site. Then, whenever you create or edit a document using Google Docs, it will be automatically synced with your WordPress site. This means all your formatting and styles will be preserved. And if that’s not enough, DocPress also offers SEO content analysis and image importing.
Try DocPress today! Crawlan.com
