How to Embed Google Sheets in Joomla

How to Embed Google Sheets in Joomla

Google's Sheets product is their version of Microsoft Excel.

Here at Joomlashack, we have a lot of members who rely on spreadsheets so we created tools to help. Did you know you can also send Joomla forms results directly to Google Sheets? Did you know that you can easily import and display spreadsheets with Shack Spreadsheets?

Google Sheets is a powerful tool and one that is surprisingly easy to use with Joomla. I'm going to show you how to embed Google Sheets into your Joomla site with just a URL.

Step #1. Install OSEmbed Pro

Step #2. Get the Google Sheets URL

Getting the link for a Google Spreadsheet

  • Go to the "File" menu then "Publish to Web".

Google spreadsheet publish to web link

  • We now need to change who can access the document. Click the "Publish" link:

spreadsheet publish

  • Copy the link in the box:

Publish a Google spreadsheet for Joomla

Step #3. Add the Google Sheets URL to a Joomla article

  • Go to your Joomla site and log in.
  • Add the Google Sheets URL to a Joomla article:

A Google Sheets link inside a Joomla article</[>

The URL will automatically be turned into a working Google spreadsheet! You'll see a preview inside the editor:

spreadsheet in the Joomla admin

The Google spreadsheet embed will work perfectly on the front of your site.

Showing Google sheets inside Joomla