This study presents the development and validation of a practical tool for evaluating narrative elements in educational videos. Based on previous research on narrative analysis and its application in educational contexts, we developed an Excel tool that allows educators to systematically evaluate the narrative structure of videos before using them as educational resources. The tool incorporates key elements such as audiovisual narrative, dramatic structure, narrative flow, and other factors that affect comprehension, and generates automatic reports with recommendations. The validation process involved 30 participants from the educational field, including professors and education students. The results showed high acceptance rates, with more than 90% positive evaluation on usability, functionality and usefulness of the automated reports. This tool represents a significant contribution to the field of educational technology, providing educators with a practical means to select and validate educational videos based on their narrative effectiveness.