I have several questions in my survey that are multiple choice, with each choice having a clickable URL to gain more info about that selection. Upon survey completion, I export the data to a Google Sheet. However, the HTML of the link goes into the cell, rather than the text of the choice only.
Any ideas on how to remove the URL link code before export? I'm also open to other ways to present these links within the question while still offering the multi-choice. Thanks!
Solved
How to remove HTML/URL from selected choices?
Best answer by rondev
We can update the Variable Naming of the options to the text we want to get exported for respective options.
+22We can update the Variable Naming of the options to the text we want to get exported for respective options.
This is great, rondev!
My only lingering issue is that it won't let me pipe the text of those new Variable Names into post-survey flows (such as exporting to a new line on a Google Sheet). It outputs the recode value only. I have reached out to Qualtrics support about this but would welcome your thoughts as well.
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.