Spreadsheet quick reference/cheat sheet

Previous Next

Spreadsheet tabs

Template formatting

Excel macros


Gen.IT reads all data from Excel spreadsheets. Spreadsheet tabs are specifically named to indicate the data type held within the tab.


Excel is used as it's generally very well understood and extremely flexible. Users are easily able to manipulate data using custom or built in functions and/or macros.


The spreadsheets included within Gen.It include a number of custom functions and macro's which allow easier maniuplation of user data.