How do I display Excel in WordPress?
Create an Excel File data source in Tabulizer: point it at the workbook, name the sheet and the range of cells, and choose the ruleset that styles it. Then place it in a post or page with the Tabulizer Data Source block. The table is read from the workbook when the page is served, so uploading a new version of the file updates every page that uses it - optionally keeping the spreadsheet's own colours and bold text.
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
This article explains how to create a dynamic table in WordPress that automatically displays current data without manual post editing. It covers the Tabulizer Table block, the New Dynamic Table wizard, and the concept of data sources stored under Tabulizer › Data Sources. The article details Step 2 (Data source title and Source Type selection), Step 3 (Connection, SQL query, Add header row, Empty Results Message), Steps 4-5 (Ruleset archive and Ruleset), and the resulting tabulizer data source tag format. It also explains caching, table captions, server-side loading, and other advanced settings available on the full Data Sources page.
Wordpress Guides · Read the guide
The Tabulizer Data Source Block
The Tabulizer Data Source block is a WordPress block for displaying existing data sources as tables in posts, pages, and page builders without using the wizard. It explains how to find and select data sources from a dropdown list, configure optional user parameters (user_param_1 through user_param_5) with type specifications, handle empty results, and use the block alongside the Tabulizer Data Source widget and page builder elements. It covers parameter substitution, caching, and how multiple blocks can display the same data source with different parameter values.
Wordpress 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