I'm looking for tools to create a data dictionary for my project's data. We have a large database of many variables, and I would like to create a data dictionary that describes what each variable means so that I can share it with collaborators and other researchers (including on the Open Science Framework). I'd like other researchers to be able to use the data dictionary to understand the data we have, find the variables they need, etc. I'm not sure what tools/software/systems are available for this purpose, and whether I should just create a large spreadsheet to do this, or whether there are more specialized tools that people like for this purpose.
For a sense of what my data dictionary might include, here are suggested guidelines for what a data dictionary should include according to the Open Science Framework (https://help.osf.io/hc/en-us/articles/360019739054-How-to-Make-a-Data-Dictionary):
- Variable name
- Human-readable variable name
- Variable type (string, numeric, integer, etc.)
- Measurement unit
- Allowed values
- Definition and description of the variable