Free Template
Title Metadata Cleanup Workbook
Title workbook with dropdown validation for type/genre/language/rating, EIDR format check, and a missing-value report so you can see gaps at a glance.
excelgoogle-sheets
What’s Included
- Titles Input — 11 canonical columns with dropdown validation on Type, Genre, Language, and Rating. The Status column checks required-field presence + EIDR format (10.5240 prefix, 34 chars).
- Vocabularies — the allowed values for each controlled field.
- Missing Values — counts of blank cells per field.
How to Use
- Paste your titles into Titles Input. Use the dropdowns — don’t type free text.
- Status flags MISSING (red) if any required field is blank, WARN (amber) if EIDR format is off, OK (green) otherwise.
- Check Missing Values for a per-field gap count — prioritize the most common gaps.
Related Tutorials
- Standardize Title Metadata (
/tutorials/standardize-title-metadata)
Common Pitfalls
- Genre taxonomies vary. The dropdown ships with a common 10-item list. Edit it to match your internal taxonomy if different — don’t duplicate values.
- Rating is jurisdiction-specific. MPAA (movies) + FCC (TV) are US; BBFC (UK), FSK (DE), etc., are separate. Rating here = origin rating, not every territory’s local rating.
Get New Templates
We release new templates regularly. Subscribe to get them in your inbox.