Free editable resource / Excel

Qualitative codebook template for market research

Define codes clearly, retain the participant evidence and record boundary decisions. An editable Excel starting point for structured codebook-based analysis of market-research interviews and groups.

Blank template + worked example + instructions · No email or demo required

Fictional market-research example

Everyday Packs

All people, quotations and findings in these examples are fictional market-research teaching examples.

Research objective: Understand when consumers choose small or large personal-care packs and the trade-offs they describe.

A participant meaning unit within a turn. A full turn can hold more than one meaning unit. Multiple codes may apply when distinct meanings are explicit. Keep the full turn as evidence and note the meanings supporting each code.

Four example codes and their boundaries

C01 / Portability · Agreed

Participant says a small pack is convenient to carry or keep while travelling.

Include: An explicit link between the small pack and carrying, a bag, commuting or travel.

Exclude: Size mentioned without carrying context; storage at home.

Example: “For travel, the small pack fits in my bag.”
DEMO-R2-IDI01 / I02 / P01

Near miss: A participant says only that the pack is small; no carrying benefit is stated.


C02 / Larger pack for home · Agreed

Participant explicitly prefers or chooses a larger pack for use at home.

Include: Both home use and a preference for a larger pack are stated.

Exclude: Preference for a large pack without a home-use context; carrying a small pack.

Example: “At home I buy the bigger one.”
DEMO-R2-IDI01 / I02 / P01

Near miss: A participant says the big pack lasts longer without saying where they use it.


C03 / Higher unit cost · Agreed

Participant says the smaller pack costs more relative to its quantity.

Include: A price comparison tied to the amount or quantity received.

Exclude: A quoted price without comparison; budget constraints without a quantity comparison.

Example: “The small one costs more for the amount.”
DEMO-R2-FGD01 / F05 / P02

Near miss: A participant says a pack costs INR 20 but makes no quantity or price comparison.


C04 / More frequent purchase · Draft

Participant says the smaller pack leads to more frequent purchases or extra shopping trips.

Include: A clear statement about buying more often or extra trips because of the small pack.

Exclude: Purchase location alone; how often the product is used without a purchase implication.

Example: “I buy the small one more often, so I make extra trips.”
DEMO-R2-FGD01 / F08 / P03

Near miss: A participant says they buy it at a supermarket, with no statement about frequency.


Six selected coded excerpts

These are selected worked examples, not exhaustive coding of the two transcripts. C04 is Draft and provisional pending pilot review.

Source / turn / speakerExact excerptCodesCoding decision
DEMO-R2-IDI01 / I02 / P01For travel, the small pack fits in my bag. At home I buy the bigger one.C01, C02One turn contains two distinct meaning units. Apply both codes; this is not two respondents.
DEMO-R2-IDI01 / I04 / P01It costs more for the amount, and I have to buy it more often.C03, C04Both unit-cost and purchase-frequency meanings are explicit. C04 is a draft code awaiting pilot review.
DEMO-R2-FGD01 / F02 / P02On the bus, the small pack is easy to carry.C01Carrying benefit is explicit.
DEMO-R2-FGD01 / F03 / P03For home, I choose the big pack because it lasts longer.C02Home context and choice of the big pack are explicit.
DEMO-R2-FGD01 / F05 / P02The small one costs more for the amount.C03The participant compares cost with quantity.
DEMO-R2-FGD01 / F08 / P03I buy the small one more often, so I make extra trips.C04Extra shopping trips are explicit. Review the draft code in the pilot.

These examples illustrate coding decisions, not population prevalence. Do not infer a missing word, identify an unknown speaker or code a moderator prompt as a participant view. Example v1.0; C04 remains Draft pending pilot coding. The sample is a starting framework, not a universal list of codes.

What we do not code

Source / turnReason
DEMO-R2-IDI01 / I06The opening feature is unclear. Keep the uncertainty marker and review the audio; do not infer a feature code.
DEMO-R2-FGD01 / F06Words and speaker are unknown during overlap. No topic or participant attribution can be supported.
DEMO-R2-FGD01 / F04Moderator question, not a participant opinion.

A blank structure ready for your study

The workbook starts with project, objective, coding unit, multicode policy, version and owner fields. Its reusable blank codebook contains 30 editable rows.

Code IDCodeDefinitionInclude whenExclude whenExample excerptSource referenceNear missStatus
[Enter][Enter][Enter][Enter][Enter][Enter][Enter][Enter][Enter]

There are no automatic counts or scores. Add or extend rows as your framework develops; retain definitions and source references.

Pilot, settle boundaries and keep a change record

  1. Set the research objective and coding unit before adapting the blank codebook.
  2. Define inclusion and exclusion rules; add an exact example and a near miss for each code.
  3. Code a small pilot subset. Compare interpretations with another coder where appropriate.
  4. Record revisions and revisit excerpts affected by a changed definition.

Fictional change-log example · 1.0

Added C04 as Draft after pilot excerpts described repeated purchases and extra trips.

Check whether both meanings should stay under one code before applying the framework more widely.

Affected excerpts: E02 and E06

Pilot with another coder and record the decision; if the code changes, revisit the affected excerpts.

Choose the next resource

Explore qualitative research analysis if you need an analysis deliverable configured around your study.