How do I turn a CSV file into a table on my website?
Use the CSV / Text File data source: give it the file (uploaded or by URL), the separator, and the ruleset that styles the table, then insert the data source into your page. Every spreadsheet program can export CSV, and the table follows the file whenever it is replaced.
Step by step
The CSV / Text File Data Source
This article explains when and how to use a CSV or delimited text file as a data source in Joomla and WordPress. It covers setting up a CSV/Text File data source through Components › Tabulizer › Data Sources, configuring File path/URL (including upload and file checking), Character Encoding conversion, and Separator, Enclosure, and Column Consistency options. The article also explains the file reading process, how to keep data updated, and troubleshoots common issues like wrong separators, unquoted values containing separators, and character encoding problems.
Data Sources · Read the guide
Managing Data Sources
This article explains what data sources are and how to create, manage, edit, and share them. It covers the Data Sources page toolbar buttons (New Data Source, Import Data Source, Export, Clear Cache, Delete Data Source, Manage Data Files), the list columns and action buttons (Preview, Edit, Delete, Publishing Preferences), and creating data sources by selecting a Source Type, Ruleset Archive, and Ruleset Name. It details the Tag, Title, Table Caption, Table Summary, Server Side, Empty results message, Cache Status, and Cache Time fields, plus importing and exporting data sources, uploading and managing data files, and clearing the cache.
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
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
See it working
- Feature: Reading Local & Remote Data Sources
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