How to code qualitative data in Google Docs
By Jake Marsh · Updated
To code qualitative data in Google Docs, give each code its own named highlighter, highlight the transcript, and collect the coded passages in a spreadsheet. Highlightwell does both: its Interview coding set starts you with Motivation, Barrier, Experience, Suggestion, Emotion and Memorable quote, and Add to a Sheet puts every coded passage from every transcript into one Google Sheet, with a link back and a count per code.
Set up your codebook
- Open Extensions > Highlightwell > Open highlighters in your first transcript.
- Open the Sets tab and pick Interview coding. Or start your own set with Add a highlighter for each code. A set holds up to 9 codes, each with a name up to 40 characters and its own color.
- Rename the codes to match your codebook, for example Trust, Cost, Workaround, Onboarding. Editing a preset saves it as your copy.
- Share it with the rest of the team. Click Share this set and send the code; others paste it under Add a set from a code and get the same names and colors. To make a shared transcript use your codebook for everyone, tick Use this set for everyone who opens Highlightwell in this Doc.
Steps for each transcript
- Read and highlight. Select a passage and click its code in the sidebar, or press Alt+/ (Option+/ on a Mac), type the code name and press Enter.
- Review on the Passages tab. Filter by one code to see whether its passages belong together. Click any passage to jump to it in the transcript.
- Export with Add to a Sheet. The first time, use New Google Sheet; for every transcript after that, choose Add to a Sheet and pick that same Sheet.
- Keep "Show the heading each passage sits under" on if your transcripts use headings for questions or speakers. The Under heading column then shows which question each passage answered.
What the Sheet gives you
Each row is one coded passage, with these columns: Label (the code), Color, Passage, Words, Tab, Under heading, Order in Doc, Link, Source Doc and Exported. The Summary tab counts passages and words per code across every transcript you've added, sorted by the most used code.
From there you can sort or filter by code to read all the Barrier passages side by side, or filter Source Doc to see one participant's codes. The Link column opens the transcript at the passage, so you can check the context before quoting it.
When a code changes
Codebooks change halfway through a study. If you change a code's color on the Sets tab, Highlightwell offers to recolor the passages that still use the old color. If you rename a code, passages keep their color and get the new name in the next export.
What it costs
Highlightwell's free trial covers 10 exports or 14 days, whichever comes first, with no card needed; highlighting and the Passages tab are always included. A study with ten transcripts fits in the trial if you export each one once. After that it's $2.99 a month, $24 a year, or $49 once for lifetime use on one Google account. Install it from the Highlightwell page.
Highlightwell: Highlighter Labels & Export for Docs
Labeled highlighters for Google Docs, and every highlight collected into a Doc or Sheet with links back $2.99 a month or $24 a year per Google account.
Questions
Can two passages that overlap have different codes?
No. A piece of text has one highlight color in Google Docs, so it carries one code. Split a passage into two highlights if two codes apply to different parts of it.
Can more than one person code the same transcript?
Yes. Anyone with edit access who has Highlightwell sees the Doc's attached set and can highlight. Each person's export reads the highlights that are in the Doc at that moment.
Does Highlightwell send my transcripts anywhere?
No. The text is processed inside Google Apps Script under your account and isn't sent to Great Work. The add-on only reads the Doc you open it in and the files it creates.
Can I export one code only?
Yes. On the Export tab, click the label chips to leave out the codes you don't want, then export.
More Highlightwell guides
More Google guides
- How to change icon color in Google Slides (Iconwell)
- How to do dual dialogue in Google Docs (Fadewell)
- How to set up an APA 7 paper in Google Docs (Refwell)
- How to check the reading level of a Google Doc (Crispwell)