How do I display an Excel file in Joomla?
Create an Excel File data source in the Tabulizer component (sheet, cell range and ruleset), then insert it into an article with the Tabulizer editor button as a dynamic table, or show it in a module position. The data is read from the workbook whenever the page is served, so replacing the file is all it takes to update the table.
Step by step
The Excel File Data Source
This article explains how to use the Excel File data source to import workbook data into tables on your site. It covers file path and URL options, Sheet Name and Sheet Selection configuration, Sheet References settings for cross-sheet formulas, and formatting options including Read Font, Read Color, Read Images, and Read Hyperlinks. The article also discusses the Ignore these colors field, Remove Empty rows and columns, performance optimization strategies, and common errors like sheet name not found, timeouts, formula resolution failures, and file size limits exceeding 16 MB.
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