Download the blank worksheet and example
Get an editable CSV with eight blank rows, a separate fictional example and a readable TXT copy. The sample transcript is constructed, not participant data. No account or qualitative-analysis software is required.
- CSVBlank interview coding worksheet628 bytes
- CSVFictional worked coding example3 KB
- TXTCoding worksheet and method-aware checks4 KB
Use a blank record for your own work. Keep examples separate from your evidence and follow the instructions below.

On this page
Your claim-to-source record
Use one record for one claim. Keep the original source open alongside it.
Notes stay in this tab and are not saved automatically. Download or print them before closing this page.
Copy the sentence you need to check.
Author, title, date, venue, DOI or URL.
Which publisher or library record did you check, and when?
Page, section or paragraph.
Include the words that limit the finding.
Who or what was studied? What was actually measured?
Describe any change in certainty, scope or meaning.
Write wording that the evidence can support.
Choose the analytic approach before choosing a coding sheet
Qualitative analysis does not begin with one universal coding recipe. The question and chosen methodology determine whether you code, what counts as a segment, where labels come from and how interpretations should be reported. Some approaches use a defined scheme; others do not treat coding as a step for sorting data into a fixed codebook. Follow your course, protocol or supervisor’s method guidance before filling a template.
If your approach uses codes, record whether they are informed by prior concepts, developed from the material or revised through both. State what you are analyzing: a transcript, an interaction, a passage or another unit. A code is an analytic aid, not automatically a theme, a participant characteristic or a measured outcome.
Braun and Clarke describe reflexive thematic analysis as distinct from codebook and coding-reliability approaches. Requirements such as a fixed codebook, independent coding or agreement statistics should not be added to every thematic analysis as if they were method-neutral quality checks. Use them only when they fit the approach you have actually selected.
Read the interview in context before selecting a passage
Keep a transcript ID and version that lets you return to the source without putting a participant’s name in a working sheet. Read the full relevant interview before dividing it into extracts. A sentence can change meaning when read beside the interviewer’s question, a correction or a later explanation. Record a stable locator such as page, line, timestamp or paragraph.
The CDC guidance describes repeated reading, coding, memo writing and checking alternative explanations as iterative work. If your method uses codes, note why a passage fits a label and what could make your interpretation incomplete. Leave a field unresolved when the context is unavailable instead of treating the transcript fragment as self-explanatory.
Supporting reading: [2]
A fictional worked example: from passage to provisional code
Constructed teaching example only. The excerpt, participant label and analysis are fictional; no interview was collected, no participant data were analyzed, and no finding about students is reported.
The example question is: “How do first-year students decide when to ask for help with a math problem?” The short excerpt below is deliberately fictional. It demonstrates how a researcher might document one possible descriptive reading and a competing interpretation; it does not answer the research question or represent a real student.
Read the entire fictional exchange before using the table. The excerpt is shown only as a constructed teaching example; it does not contain an actual participant quotation. The labels are provisional practice notes, not a recommended code scheme for another methodology.
Scroll the table sideways to view all columns.
| Selected segment (fictional) | Possible code or note | Reason and uncertainty | Next check |
|---|---|---|---|
| I got stuck on the second step, but I waited until after the lecture. I did not want to hold everyone up. | Possible descriptive code: delaying a public question to avoid disrupting the class | The excerpt connects a timing choice with the participant’s stated concern. This is one provisional reading, not a finding about other students. The participant may have had another reason to wait, such as the lecture ending soon. Re-read the surrounding exchange before deciding what the statement means. | Check the surrounding question and later account of office hours; compare with other interviews only if the chosen method and approved data support that analysis. |
| The tutor asked me to show where the equation stopped making sense. That helped more than when someone just gave me the answer. | Possible descriptive code: locating the step that caused difficulty | The speaker contrasts a diagnostic question with receiving an answer. The excerpt does not show what changed in later performance. “Helped” could refer to feeling understood, identifying a gap or solving this particular problem. The interview context is needed to interpret it. | Keep the contrast attached to its context; do not infer a general learning effect or name a cross-interview theme from this excerpt alone. |
Keep cross-interview patterns and claims traceable
One coded segment is not evidence that a pattern is common, representative or causal. When your method supports cross-case comparison, retain the source IDs and locators for passages that support, complicate or contradict an interpretation. Write a memo about how a candidate pattern answers the question and what other reading remains plausible.
Do not turn a frequency count into participant prevalence unless the design and unit support that interpretation. A count can describe a defined set of coded segments; it does not, by itself, show how many people share an experience or why they acted. Explain the analytic decisions that connect records to a reported finding, in terms consistent with your method.
If your chosen approach uses a codebook, keep its version and record the definitions, inclusion or exclusion boundaries and changes that matter. If you work in a reflexive approach that does not use a fixed codebook or agreement score, do not add those fields merely to make the worksheet look more formal.
Check permissions before using real interview material in a tool
Interview material may contain direct or indirect identifiers, confidential details or information covered by an approved protocol. Before entering it into an external service, check participant consent, ethics or IRB approval, institutional data rules, contracts and the service’s current processing and retention terms. Removing names alone does not establish that an upload is authorized.
Institutional policies differ. Cornell, for example, requires researchers to use institution-approved tools for specified data classes; Western Washington’s human-research guidance discusses consent, protocol and tool terms. Those are examples of local requirements, not universal legal advice. If the approval or data classification is unclear, ask the responsible supervisor or research office and keep the transcript out of the service until you know what is allowed.
This worksheet works offline in a spreadsheet or text editor. It does not require an AI tool, upload transcript content or certify that data are de-identified. If approved use includes AI assistance, record what the tool actually received and verify every proposed label against the source and your method.
Use the record that matches the material you are analyzing
This worksheet is for original interview material when the selected approach uses coding. The research-article reading worksheet is for understanding a published paper’s question, methods and results. The systematic-review screening log records whether publications meet eligibility criteria. A literature matrix compares inspected sources. Those activities can connect in a project, but their records are not interchangeable.
Begin with the research-question worksheet. If your project is a literature review, plan the search and screening before comparing included studies. If it analyzes interview data, follow the approved method and data-handling requirements for that project.
Questions about this topic
What should a qualitative interview coding worksheet include?
For an approach that uses coding, keep the research question, analytic method, transcript ID and version, contextual locator, selected segment, code or analytic note, rationale, uncertainty and next check. Adapt these fields to the method and data-handling rules; no single template fits every qualitative analysis.
Do all qualitative projects need a codebook?
No. Whether to code and whether to use a codebook depend on the methodology. Some approaches use written definitions and boundaries; reflexive thematic analysis, for example, should not be treated as a coding-reliability method by default.
Do qualitative researchers need inter-rater reliability?
Not as a universal requirement. Reporting and collaboration procedures should follow the chosen methodology. Agreement measures may suit some coding schemes and conflict with assumptions of other approaches.
Can I upload interview transcripts to an AI tool for coding?
Check participant consent, the approved protocol, institutional rules and the service’s data terms first. Deleting names does not alone establish permission. Use only an authorized route for the data you have, and verify any suggested analysis against the source.
Is the worked interview example real?
No. The excerpt, participant label and coding notes are fictional teaching material. No interview was collected or analyzed, and the example reports no finding about students.
Sources and editorial notes
The supporting reading below informs our editorial guidance. Exercises and scenarios illustrate a method; they do not report a completed product test or measured learning outcome. Read our editorial policy or send a correction with a supporting source to info@ai-essay.com.
- University of Illinois Library: Qualitative Data Analysis — Coding Data
- CDC Field Epidemiology Manual: Collecting and Analyzing Qualitative Data
- Braun and Clarke (2024): Supporting best practice in reflexive thematic analysis reporting
- Cornell University: Responsible and Ethical Use of AI in Research and Scholarship
- Western Washington University HRPP: AI tools in human-participant research