Sheet Data Dictionary / Definition (report)

Anthony Giacomelli

Need method to quickly examine a sheet's attributes and the data type of each attribute.

USE CASE: I have inherited 10 large sheets with similar but varying attributes -- each sheet has approximately 60-75 attributes. My task is to sync (make the same) all attributes in all of these sheets. Presently, I must manually and individually examine each column. (... that's over 700 separate column examination actions!)

Instead, as with other database applications, here I also want the ability output a report about table/sheet attributes, to enable comparisons of attribute names and data types, and thereby discover which columns match, and which differ.

In summary, the ability to generate a report about one's sheets is smart. ("Smart" - sheet)