How to import data from an Excel Spreadsheet dynamically

In this tutorial we will show how to import data from an Excel file dynamically, so when the Excel file changes the linked table in your site gets updated automatically. This is very useful when a lot of updates occurs and you want to simply update the external Excel file, instead of recreating the tables in your site.

How to split and group tables by column values

Sometimes you need to split a table into multiple tables, based on the value of a certain column. In other words, all rows that have the same value in the specified column will be put into the same sub-table. In this article we will discuss how to do that the right way, using the built-in functionality and the modification function groupbycolumn.