TableWiz

TableWiz is a Microsoft Excel ® Addin that allows you to capture the structure and layout of tabular data grids (ranges and tables). You can then create them automatically in new worksheets. This removes human error from new worksheet creation and prevents “bloat” from multiple “copy-pasta” operations and the cascade of errors and local optimisations in one project to the next one.

Excel ® users set up their data in many ways, but the most powerful for data analysis is as a datagrid, defined as either ranges or tables (“List” objects). Datagrids enable other Excel capabilities such as PivotTables, PivotCharts and Queries.

There are many Excel add-ins that enhance the capability of users to perform functions on the data in datagrids. But TableWiz focuses not on the data but on the “metadata” of your datagrids, i.e. the structure, relationships, layouts, and appearance of datagrids.

Once you have captured datagrid metadata, you can then use that metadata to perform many other functions, for example create new datagrids with exactly the same structure and function automatically in new worksheets. This removes human error from new worksheet creation and prevents “bloat” from multiple “copy-pasta” operations and the cascade of errors and local optimisations in one project to the next one.

TableWiz allows users to standardise the setup of datagrids for repeatable use of table logic, over and over.