Is it possible to somehow get the information, which number the participant chose instead only receiving passiver, promoter or detraktor in the excel sheet. Thanks.
I used the NET PROMOTER SCORE and I am now interested to analyze 1-10 and not only Promoter etc.
Best answer by lizb311
Yes, this is possible - and should happen automatically when you download your data in Excel. If you download your data, you should see two columns for your net promoter score question. One will be the group (detractor/passive/promoter), and will be called something like Q1_NPS_Group. The following column immediately after that should be the raw score (on a scale from 0 to 10) and will be called something like Q1 (again, depending on what the question number is in your particular survey).
To get the 0-10 numbers to display as a chart in your reports:
- Add a new visualization from the Net Promoter Score question. Click on the new graph.
- Change the data source for the new graph from "NPS Group" to "Numeric value." This should be the first option that comes up in the top right sidebar when you have your visualization selected.
Change the visualization type to a bar chart (or table or whatever you like).

Sign up
Already have an account? Login
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login to the Community
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
