Create your first table on your Joomla site

Getting Started · Tutorial 3

Create Your First Table

Tabulizer is installed - now put a real table on a page. In about fifteen minutes you design a product list in the online Table Wizard, with a search box, pages and a layout that works on a phone, bring it into your Joomla site and publish it in an article. Then you see how easy it is to change the look or the data later.

The plan

1

Design it online

The Table Wizard on tabulizer.com turns your sample data and your choices into a ruleset - the recipe for how the table looks and behaves.

2

Bring it to your site

Download the ruleset as a data source and import it into Tabulizer. The data travels with it.

3

Put it in an article

The editor button inserts a short tag. Visitors see the finished table.

Everything below was made on a Joomla 5 site; the steps are the same on Joomla 3, 4 and 6.

Step 1: your data

Log in to tabulizer.com and open Wizards › Table Wizard. In step 1 (Data), choose Type sample data and paste your rows in CSV form - one line per row, values separated by commas, the first line holding the column headings:

Product,Category,Colour,Price,In stock
Desk lamp,Lighting,Blue,24.50,12
Office chair,Seating,Black,189.00,4
Bookcase,Storage,White,249.90,7
...

Leave Column Separator at Comma, and set the number of rows and columns to match your data - here 13 rows and 5 columns.

Step 1 of the online Table Wizard: Type sample data selected under Sample Data for the Table Preview, and the Input Text box holding thirteen lines of comma-separated product data, from Product, Category, Colour, Price, In stock down to Footrest, Seating, Black, 29.50, 18.

Already have the data in a spreadsheet? Save it as CSV and paste the file's contents. Commas inside a value are fine as long as the value is in double quotes.

Step 2: the shape

In step 2 (Format), set Top Headers to 1 header(s) so the first line becomes the heading row. Then choose Zebra/Rows for alternate row colours and Hover/Row so the row under the mouse lights up. Pick any border style you like; the example uses row borders.

The zebra and hover choices in step 2 of the Table Wizard: Zebra/Rows selected among No Zebra, Zebra/Rows and Zebra/Columns, and Hover/Row selected among No Hover, Hover/Row and Hover/Cell, each with a small sample grid.

Step 3: the colours

Step 3 (Style) has a section for each part of the table. Three settings give the example its look:

Section Setting Value
Table Headers › Header #1 Font Style, Font Color, Background Color › Solid Bold, #ffffff (white), #1f3a68 (dark blue)
Zebra Background Color › Solid #fbeeee (a light blush)
Hover Background Color › Solid #e9ecef (a light grey)

The Header #1 section of step 3 in the Table Wizard: Font Style Bold, Font Color #ffffff, no text shadow, and Background Color set to Solid with the color #1f3a68 and a dark blue swatch.

Type a colour code or click the swatch to pick one. Anything you leave at Default follows your site's template.

Step 4: the features

Step 4 (Features) is where a plain table becomes an interactive one. Switch on three things:

Panel Setting What visitors get
Table/Search Filter Enable Table Filtering: Yes A search box that narrows the rows as they type.
Table/Pagination Pagination Type: Arrows with Page Numbers, 10 rows per page Ten rows at a time, with page numbers and a "Show 10 entries" menu.
Table/Responsive Responsive Pattern: Fixed Headers + Expand On a phone, the less important columns fold away behind an arrow on each row.

The Table/Search Filter panel in step 4 with Enable Table Filtering ticked, Header Size 1 row, Footer Size None and Position Top-Right, followed by the Column Filters box, not ticked, and the start of the Table/Pagination panel set to Arrows with Page Numbers.

For the responsive pattern, decide per column when it may be hidden. The example keeps Product as the column with the expand arrow, always shows Price, hides Category and In stock on phones and Colour on tablets too:

The Table/Responsive panel in step 4 with Responsive Pattern Fixed Headers + Expand and one menu per column: Column 1 Expand, Column 2 Phone, Column 3 Tablet, Column 4 Show Always, Column 5 Phone, then Header Size 1 row and Footer Size None.

Step 5 (Modifications) can change the data itself - formats, calculations, extra rows. Nothing is needed there for this table, so go on to step 6.

Step 5: preview and save

Step 6 (Preview) shows the table as your visitors will see it, with every feature working. Try the search box and the pages.

The step 6 preview of the product table: a Show 10 entries menu and a Search box above it, a dark blue heading row with white bold text reading Product, Category, Price and In stock, and rows that alternate between white and a light blush, each product with a small arrow before its name.

Below the preview, give the ruleset a Ruleset Title and a Ruleset Description - they are how you will recognise it later - and press Save & Download Ruleset.

The Save as Tabulizer Ruleset panel at the end of step 6, with the title Office products, the description Product list with search, pagination and a responsive layout, an empty optional help box, and the buttons Previous Step, Save and Download Ruleset, and Start Over.

Saving needs a tabulizer.com account. If you are not logged in, the wizard keeps your work, sends you to the login page and brings you back to finish.

You land in your Ruleset Manager, with two ways to download:

The Ruleset Manager after saving, with the message Your ruleset has been saved, a blue Download Ruleset button, a Download as Data Source button, and a note explaining that a first-time ruleset is easier to start with as a data source.

This first time, press Download as Data Source. You get one zip holding the ruleset, its styles, your sample rows as a CSV file and a ready-made data source that ties them together - everything Tabulizer needs to show the table.

Step 6: import it into Joomla

In your Joomla administrator go to Components › Tabulizer and press Import Archive. Choose the zip you downloaded.

The Ruleset Archive Import page in the Joomla administrator, with Import and Close in the toolbar, a File field for the zip archive and two Overwrite checkboxes: overwrite any other existing files with the same name, and overwrite safemode settings.

Tick "YES, overwrite safemode settings". Tabulizer starts with Safe Mode on, and Safe Mode does not import data sources - without the tick the import stops with this message:
A red Joomla error message reading: Importation error: You cannot import data sources because the Safe Mode is enabled. If you want to enable this action, you need to disable Safe Mode via Tabulizer's User Preferences page.
The tick lifts Safe Mode for this one import and leaves the setting as it was. Use it only for archives you downloaded from tabulizer.com yourself.

Press Import. Joomla reports that the zip was uploaded, and under Data Sources you find a new one named after your ruleset:

The Data Sources page of Tabulizer in Joomla, searched for Office, showing one data source: Office products, with its tag Yh2UHLSSK0PZmbcsgrkPKpEg, Source Type CSV/Text File, and the actions Preview, Edit, Delete and Publishing Preferences.

Press Preview if you want to see the table before it goes into an article.

Step 7: put it in an article

Create a new article (Content › Articles › New), write an introduction if you like, and put the cursor where the table should go. Open CMS Content › Tabulizer in the editor toolbar.

1

Choose the mode

In the wizard that opens, choose Existing Dynamic Table and press Next.

2

Pick the data source

Select your data source in the Data Source list and press Next.

3

Insert it

Check the summary and press Insert Table.

Step 2 of the Tabulizer editor wizard, Select Data Source, with Office products (csv) chosen in the Data Source list and its tag Yh2UHLSSK0PZmbcsgrkPKpEg shown underneath, and the Back, Cancel and Next buttons.

The article now holds a short tag. That tag is the table: it is replaced with the real thing whenever the page is shown, so the article always displays the current data.

The Joomla article editor with the introduction Our current range of office products, followed by the inserted tag <div class=

Invalid data source. Please correct the following errors:
  • The data source tag/idis missing or it is invalid
." width="742" height="305" />

Save the article, make sure it is published, and open it on your site.

The result

The finished table on the Joomla front end: a Show 10 entries menu and a Search box, the dark blue heading row with white bold text, ten product rows alternating white and light blush, the line Showing 1 to 10 of total 12 entries, and the pager First, Previous, 1, 2, Next, Last.

On a phone the same table keeps the product and its price, and an arrow opens the rest of each row:

The same table on a phone: only the Product and Price columns, with the Office chair row opened to show Category Seating, Colour Black and In stock 4 underneath it.

That is the whole journey: a ruleset designed once online, a data source on your site, a tag in an article.

Changing the look later

The design lives in your ruleset on tabulizer.com, so that is where you change it.

1

Edit the ruleset

On tabulizer.com open My Account › My Rulesets and press Edit next to the ruleset. The Table Wizard opens with every setting as you left it. Change what you want and save again.

2

Download the ruleset only

This time press Download Ruleset, not Download as Data Source. Your site already has the data source and its data file; exporting them again would only bring a second copy, or a message that the data source already exists.

3

Import with Overwrite

In Joomla, Import Archive again and tick YES, overwrite any other existing file(s) with the same name, so the new version replaces the old one.

The Office products ruleset in the My Rulesets list on tabulizer.com, with its name rs_fdg2ilcf, its description, the date it was modified, and the actions Download, Preview, Edit, Edit as Copy, Export as DS and Delete.

Every article that shows the table picks up the new look at once - there is nothing to change in the articles.

Changing the data later

The rows live in a CSV file on your own site, separate from the design. To change them, change the file - the table follows on the next page view.

Way How
Edit it in place Open the data source (Data Sources › Edit). Next to the file name, Edit inline opens the CSV in an editor where you change, add or remove rows and save.
Upload a new version Replace file on the same form, or Data Sources › Manage Data Files › Upload Data File with Overwrite ticked. Keep the same file name and the same columns.
From outside Joomla Replace the file over FTP or with your host's file manager. Data files live in templates/tabulizer/data/.
From the front end The optional Tabulizer File Uploader lets the people you choose upload a new version of a data file from a page on your site - no back-end or FTP access needed. It comes with your membership; see Updating Data from the Front End with Tabulizer File Uploader.

The File path/URL field of the Office products data source, holding rs_fdg2ilcf_sample.csv, with the buttons Replace file, Edit inline and Check file link, followed by Character Encoding, Separator Comma, Enclosure Double Quotes, Column Consistency and Empty results message.

The Data Files page of Tabulizer in Joomla, with Back to Data Sources, Upload Data File, Download Files, Delete Files and Help in the toolbar, listing rs_fdg2ilcf_sample.csv, its last modified time, the linked data source Office products, and Download and Delete actions.

Or let the data come from somewhere else

A data source is not tied to a CSV file. Edit it and change its Source Type, and the same ruleset - the same look and features - shows data from another place:

Source Type When it suits you
Excel File You keep the list in Excel. Upload the .xlsx and replace it whenever it changes; no need to save as CSV.
Google Spreadsheet Several people keep the list up to date. Link a published Google Sheet and the table shows their changes by itself - nobody touches the website.
Database Table/Query The data is already in your site's database, kept by another extension.

Keep the same columns in the same order and the table looks exactly as before.

Common questions

The import says Safe Mode is enabled.

Import again with YES, overwrite safemode settings ticked. Or turn Safe Mode off for good under Components › Tabulizer › User Preferences - but the tick is the safer habit.

The article shows the tag instead of a table.

The two Tabulizer CSS plugins are disabled. Enable them under System › Manage › Plugins; see How to Install Tabulizer on Joomla.

I changed the CSV but the table did not change.

The data source has caching on. Wait for the cache time to pass, or press Clear Cache on the Data Sources page.

Can I use the same table on several pages?

Yes. Insert the same data source in as many articles or modules as you like; they all show the same, current data.

Can I start from my own design rather than the wizard's?

Yes - the wizard covers the common cases, and step 5 lets you add your own CSS. For ready-made designs, browse the premium and community rulesets on tabulizer.com.

Read more

Each step of the wizard in depth: the Table Wizard Guides. More about data: The CSV/Text File Data Source, The Excel File Data Source and The Google Spreadsheet Data Source.

Make yours

Open the Table Wizard, paste a few rows of your own, and follow the same seven steps.

Open the Table Wizard