How to import data from a Google Spreadshet document

Update: A new version of this article can be found here. The updated version of this tutorial was necessary as Google changed in 2014 the way of publishing spreadsheet documents.

Google Spreadsheet documents can be read by Tabulizer and it's an ideal solution if you have more than one collaborators that are working on the same document. As you can publish the Google spreadsheet document as CSV, you can define a data source that will link the document to a table and everytime the document is updated that linked table will be updated as well.

Column filters on the second empty row

Column filtering allows to add search filters that are column specific. So, instead of searching for whole table, each  filter will be applicable to the corresponding column data. In this article we discuss one aspect of using these filters that has to do with their position in the table.

Responsive Scrolling - What to know

In this article we discuss some issues that arise when you want to add scrolling to your table. Generally speaking, scrolling is useful when the "container area" is smaller than the "content area". In such cases the scrollbars allow you to view the part of the content that "overflows", as shown in the images below:

How to add a table header row(s)

One frequently asked question is how to add header rows to a table that is produced by a database query.
for instance, let's assume that you want to display a list of articles with the following query:

Loading data to your table from another database/server

Tabulizer offers you the possibility to display the results of a database query into a table, by creating a data source of type "Database Table/Query" where you have defined the query. This works well for queries that are executed on the same database as the Joomla site, but how about if you wanted to execute a query on a different database or even on a remove server?