Use these steps to share your test results with your team members by exporting them to Excel. |
This article applies to: UserTesting
On this page:
- About the Excel export
- How it works
- What's included in your report
- Combine multiple tests in on Excel workbook
About the Excel export
Exporting your completed test to Excel allows you to:
- Quickly search for keywords across multiple test participant responses.
- Copy results for reporting and presentations to partners.
- Share the file with others on your team so that they can scan for interesting points.
How it works
Export a whole test
- Find the test you'd like to export.
- From the test list view, click the Options (...) menu and select Export to Excel.
Alternatively, from the Sessions tab, click the Actions button and select Export to Excel. - 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.
Export an individual session
From the Sessions tab of your test, click the Actions button next to the session you want.
Alternatively, go to the video player of the session, click the share button, and select Export to Excel.
What's included in your report
Your file, presented in Simplified Formatting, will include details about the test you exported, including:
- Transcripts
- Participant demographics
- Written responses
- Multi-select responses
- Clips and notes you marked "Important" and tagged with a sentiment
Combine multiple tests in one Excel workbook
- From your dashboard, click the checkbox next to each study you want to export.
- Select the Options (...) menu, and click Export to Excel.
- Choose All selections to one Excel workbook, then Export.
When your file is available to download, you'll see clearly labeled Excel tabs that display session details, metrics, notes, and video clips from the studies you selected.
Related content
|
|
Want to learn more? Check out these Knowledge Base articles... |
Interested in growing your skills? Check out our University courses... |
|
|
Need hands-on training?
|
Can't find your answer?
|
Please provide any feedback you have on this article. Your feedback will be used to improve the article and should take no more than 5 minutes to complete. Article evaluations will remain completely confidential unless you request a follow-up.