Analysis Excel files for key words from library

About us [login to view URL] We believe that everyone should feel safe, heard and trusted at work. In return, they produce amazing results. We provide recruitment, development and staff retention products and services specifically for individuals in frontline leadership roles. This project requires: - We have created a specific methodology to select job applicants for team leader or supervisor roles. - We are piecing together our MVP as we speak and need the assistance of a talented individual to assist us with key word identification in transcripts. - The method focuses on assessing an individuals leadership attitude, aptitude, assimiliation and adaptability. We don't focus on skills or experience in our method. - We have job applicants complete a video interview (a mix of video response and written) with all answers transcribed. We are using VideoAsk to capture which automatically transcribes responses and can download into a CSV file. - Applicants also complete a work sample questionnaire where they provide a response to how they would plan on handling a number of interpersonal situations. What we need is a tool to be able to feed these transcripts into to quickly identify the key words we have identified as signals of leadership qualities. For example, question 1 of the interview is "Tell me about a time when you x". We have identified 20 key words that would signify a leadership mindset in their answer. We would want feed the transcript for that answer into a tool (eg Microsoft word macro) and for the key words to be quickly identified. At the end of the transcript feed a total key word count to be produced and also a key word by question count. We are at MVP stage. As such we are attempting to prove the concept. I have referred to Microsoft Word in the brief as that is a simple option I can think of but I am open to other suggestions from the successful freelancer. Ideally the solution is something we can a.) Feed our library of key words into b.) Load the CSV file into and get a result. I am open to ideas and thoughts taking I to account we are still at mvp stage. See attached download from Video Ask with transcriptions as a sample. Sample 2 attachment has the key words contained for each of the initial questions. Highlighted in yellow row