How to Embed Google Sheets in Joomla

| Joomla
How to Embed Google Spreadsheets in Joomla

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

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

You can also send Joomla forms results directly to Google Sheets.

Step #1. Install OSEmbed

Buy 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:
ul>
spreadsheet-publish
  • Copy the link in the box:
"AStep #3. Add the Google Sheets URL to a Joomla article
  • Go to your Joomla site and login.
  • 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

About the author

Steve is the founder of OSTraining. Originally from the UK, he now lives in Sarasota in the USA. Steve's work straddles the line between teaching and web development.