How do I show a Google Sheet in Joomla and keep it in sync?
Publish the sheet from Google Sheets, create a Google Spreadsheet data source with its link, and insert that data source into an article as a dynamic table (or show it as a module). People keep editing the sheet where they already work, and the article always shows the current data.
Step by step
The Google Spreadsheet Data Source
This article explains how to use Google Sheets as a data source for Tabulizer tables in Joomla and WordPress. It covers publishing sheets to the web, configuring the data source with Google Spreadsheet URL and Export Format settings, choosing between CSV and HTML export formats, specifying which worksheet to read, and troubleshooting common issues like HTML read as CSV errors, wrong worksheets, and missing edits. It also explains caching, republishing delays, and why private sheets cannot be accessed.
Data Sources · Read the guide
How to create a Dynamic Table (automatically updated)
This article explains how to create a dynamic table in Joomla that automatically updates when underlying data changes. It covers setting up a data source through the Tabulizer wizard, selecting sources like Database Query, CSV File, Excel File, or Remote HTML Table, configuring source settings including Database Connection and SQL Query, choosing an Archive and Ruleset, and naming the data source. It also explains the tabulizer:data_source tag that appears in articles, accessing data sources in Components › Tabulizer › Data Sources, and additional options like Caching, Header row contents, Column mapping, and Publishing preferences.
Joomla Guides · Read the guide
How to display Data Sources as Joomla modules
This article explains how to use Tabulizer Data Source modules in Joomla to display tables in module positions like sidebars and footers without embedding them in articles. It covers creating and configuring the module, selecting a data source, setting the Position and Menu Assignment, passing optional user parameters to data sources, and troubleshooting common issues like modules not appearing, tables being too wide, or slow performance.
Joomla Guides · Read the guide
See it working
- Feature: Reading Local & Remote Data Sources
- Feature: Dynamic vs Static Content
Have a different question?
The knowledge base covers every wizard, data source and option, and we are happy to answer anything it does not.
All solutions Contact us