Export Transcripts to Excel

If you’re familiar with the Transcripts feature, which automatically transcribes verbal comments from user tests alongside videos, you’ll be happy to hear you can now export transcribed studies to excel, making it easy to view written transcripts of your studies in one place and easily search and locate key findings.

Key features

Exporting your Transcripts to Excel allows you to:

  • Quickly search for keywords across multiple test participant transcripts
  • Easily copy direct quotes for reporting and presentations to stakeholders

How it works

Step 1: Export to Excel

From your dashboard, select the test that you’d like to export. You can export from three different places via your dashboard:

List view

PopularFunctions.png

Study view

From the single test view, you can select a single participant’s response, or select all, then select Export to Excel from the Options menu.

OptionsMenu.png


Video player

You can export to Excel right from the video player. Just select Export to Excel from the player controls at the bottom left corner of the player.

Excel3.png

Once your export is ready you’ll have the option to download the file. The file will also be emailed to you for your reference.
Excel3.png

Step 2: Review your Transcripts via Excel

Your file will include details about the study you exported, including any available transcripts of the sessions.

To review your transcripts, scroll to the Study Protocol section of the document on the Session Details sheet, toward the bottom of the page. Each participant’s comments will be transcribed alongside the corresponding task or question.

Excel4.png

You can also find the associated transcripts for any notes or clips you’ve created in the Clips and Notes sheets.

From here you can read through each participant's comments in full search for specific keywords, and copy and paste any memorable feedback to share with your team.

Let us know what you think!

We’d love to know what you think of the Export Transcripts to Excel feature, so give it try and share your feedback with us by emailing support@usertesting.com

Was this article helpful?
5 out of 6 found this helpful

Comments

0 comments

Article is closed for comments.