ThemescapeC · Also used in the viewer

Coding template

The Themescape spreadsheet, a Google Sheet or Excel workbook with one row per coded quote, that the viewer reads to draw your map.

On this page
  1. In more detail
  2. In Themescape
  3. A short example
  4. Where to read more

In more detail

The template has seven tabs. Instructions is for reading. Data is where the coding happens and is the only tab the viewer needs, with one row per coded quote: its ID, the participant's pseudonym, the verbatim quote and its theme, and usually a code and sub-code. Framework, Connections and Settings are optional and add working definitions, links between themes and codes, and a title. Model elements and Model relationships are for Model mode only.

The hierarchy is inferred from the columns, so nobody draws a tree by hand. Repeating the same theme and code names on each row is what groups the quotes. Names are matched as plain text, so a theme spelt two ways becomes two themes.

In Themescape

Make a copy of the template or download the Excel version, code into the Data tab, then download each tab you have used as a CSV file and open them in the viewer, which reads them in your browser. The current version is 2.6.

Boundaries andOverworkBlurredhoursNo offswitchEmail atnightWeekendworkBoundaries and Overwork
The viewer with a theme selected, its codes around it and its definition in the panel. Sample data.

A short example

From the Working Well dataset

Boundaries and Overwork

Working definition: One Data row: quote_id P01-018, participant P01, quote "Back-to-back calls leave nothing for the actual work.", theme Boundaries and Overwork, code Meeting Overload.

Meeting Overload

Made up data about working from home. Nothing in it comes from a real study.

Where to read more

The Themescape spreadsheet template ›

Tutorial: Load your first file ›

Related terms

The words that sit closest to this one.

See your own themes come to life

Try the live demo or start a 7 day free trial. Your data is read in your browser and never leaves your computer.