Data Dictionary Template: document every table and column
An Excel and Google Sheets data dictionary for documenting tables and columns: definitions, owners, classification, personal data and review dates. It comes with 25 example rows from a fictional retailer.
What's included
- Data Dictionary Template.xlsx, with 4 tabs: Instructions, Data Dictionary, Dictionary Health and Lookup Lists
- Quick Start Guide.pdf, 2 pages
- 24 columns and room for 500 entries, with dropdowns, filters and frozen headers
- Highlighting for missing required fields and duplicate columns
- Review dates and status calculated from each classification's review cycle
- A Dictionary Health tab with coverage counts and overdue reviews
Works with Excel 2016 or later, Microsoft 365, Google Sheets and LibreOffice. No macros.
License: single company. Edit and rebrand for internal use; no resale, sharing or redistribution. Free updates to this version through your Payhip download link.
The Data Governance Starter Pack has all four templates plus a quick start guide for $49, about 40% less than buying them separately.
Designed and reviewed by Keel & Charter. AI tools helped build the spreadsheets, draft the text and lay out the preview images. Preview images show the actual files with sample data.
