Export your questions, poll results, quiz leaderboard, and ideas

  • 24 August 2020
  • 43 replies
  • 34340 views

Userlevel 3
Badge

Once your event is over and you wish to work with the information you collected, the easiest way to do this is to download your data.

 

Available in our Engage plan and higher.

 

In this article:

 

To see all the features you used in the Export, please make sure they're enabled in your Event settings.

 

 

Export Audience Q&A

 

You can export Slido Questions into an Excel spreadsheet file.

  1. Go to Analytics
  2. Click Export
  3. Select Questions
     

file.php?view=Y&file=i7sp11d6jcvj9y689x2msh5zf7tqo9rb.gif

 

This automatically generates a file with questions - it includes timestamps, names (if provided), and the number of upvotes.


This is what an export file looks like:


An example of an Excel export file

 

If you have Multiple rooms, each one of them will have a separate sheet within the export (along with a sheet for your overall export)


Question exports columns explained:

  • Question text - This column consists of the complete texts of submitted questions
  • Score - Each question has a score which is the difference between the upvotes and downvotes it received, i.e. how popular the question was
  • Upvotes - The number of upvotes which a given question received
  • Labels - If you're using our Labels feature, you can see those in exports as well
  • Downvotes - The number of downvotes which a given question received
  • Highlighted You can see whether a question has been highlighted or not (1 means yes and 0 means no)
  • Starred - You can see whether a question has been starred or not (1 means yes and 0 means no)
  • Status - You can see the current status of each question at the time of the export
    • Rejected - The question wasn't approved
    • Live - The question was approved and is currently live
    • Answered - The question was approved and then marked as answered
    • Archived - The question was approved and then archived (not marked as answered)
    • Pending - The question is still under review (it hasn't been approved or rejected yet)
  • User ID - Each user has their own randomly generated user ID assigned
  • User name - If you've asked for the name of your participants, you can see it here (they can still choose to remain Anonymous)
  • Room If you're looking at overall exports, this column tells you in which room a certain question has been asked
  • Sentiment - Thanks to our in-house built machine learning model, we can assign a tone to each question (Positive, Negative, Neutral)
  • Submission date - The date on which the question was posted
  • Submission time - The time when the question was posted

Please note that if your Q&A exceeds 1000 questions, your event analytics won’t load and you won’t be able to export questions yourself. Please contact support@slido.com or your dedicated account manager, and they can assist you with the export.

This is to ensure optimal performance of Slido. 


Export Ideas

 

You can export Slido Ideas into an Excel spreadsheet file.

  1. Go to Analytics
  2. Click Export
  3. Select Ideas
     

file.php?view=Y&file=sn73g09zlsqv8lhwsp5n7qkn42l87c2s.gif

 

If you're using Ideas Replies, those aren't available in our exports.

 

This is what an export file looks like:

 

file.php?view=Y&file=kl90ne4tcs5wr4j38jzcj0ktywrigf3d.png


Export Poll results

 

You can download your poll results as PDF or Excel spreadsheet files.

  1. Go to Analytics
  2. Click Export
  3. Select Poll results to see overall results or Poll results per user to see how each of the participants voted
     

file.php?view=Y&file=rr15bezuhu4r5oxny1swl2bmgv3ssigg.gif

 

Export of overall results:


This export simply shows the results of all your polls and surveys. Here are some examples of what it looks like:

 

Export of results per user:

 

Exports per user allow you to match the answers or votes with respective participants. Each of them has a unique User ID that you can track. 


If you asked your participants to enter their name and/or email when joining your event, you’ll see their data in this export. This can be especially useful when you're using polls with correct answers.

 

Here's an example of the export file when participants filled in their names:
 

Example of Poll results per user export with multiple rooms

You can see how your participants voted in individual polls by clicking the sheets named by the room number.

 

Poll exports columns explained:

  • Poll ID - Each poll has its unique randomly created ID
  • Poll type - The type of poll which you're looking at (Open text, Word cloud, Rating, Multiple choice, Quiz)
  • Poll question - The full text of your poll question
  • Poll option - The answer to the poll question in that row
  • Count - The total number of people who voted for that specific answer (if it is either an open text poll or a word cloud, the answer will be 1)
  • Total votes - The total number of votes received in that poll
  • Results - For multiple-choice polls, you can see the percentage of votes which each answer received. For rating polls, this will be the average score of submitted answers.
  • Survey name - If the poll was created under a survey, you can see what the name of that survey was
  • Room - If you're looking at overall exports, this column tells you in which room a certain poll has been asked
  • User ID - Each user has their own randomly generated user ID assigned
  • User name - If you've asked for the name of your participants, you can see it here (they can still choose to remain Anonymous)
  • Submission date - The date on which the poll answer was submitted (in the Export all tab)
  • Submission time - The time when the poll answer was submitted (in the Export all tab)

Please note that if your Polls exceeds 1000 poll responses, your event analytics won’t load and you won’t be able to export the poll responses yourself. Please contact support@slido.com or your dedicated account manager, and they can assist you with the export.

This is to ensure optimal performance of Slido. 

 

Export your data using Google Sheets

 

If you prefer, instead of downloading a .PDF or .XLS file, you can stay online using Google Sheets - choose Export to Google when exporting your data. 

This will create a new spreadsheet under your Google account with the respective data.
 

file.php?view=Y&file=gme19e3ehnwzcr6qwthkxdr4xqyg0sxm.gif



Curious about more?

 


43 replies

Thank you @Meggie from Slido for offering the suggestion! I was able to print several questions at a time that way, but had trouble getting all questions. Someone mentioned ‘resetting’ the quiz so it can be used a second time, so I think my best option is to take the quiz, export the information, then reset the quiz for the ‘real’ event. Thank you!

Userlevel 5
Badge

Hey @aprilm,

Great questions!

You can see the names of participants instantly in open text polls (if you enable it) and in the Q&A. For other polls, you can only see participants’ names when you export the results.

The Analytics tab in your admin updates automatically and you can export results at any point during or after the event. As I mention above as well, results will also show up in your admin straightaway after you activate a poll and participants vote in it.

Hope this helps! :)

Hello there!
At the end of the ppt presentation, I would love to show a “perception vs. reality” summary of what my audience answered vs. what is the actual scenario. How can I display both data in a unique slide? 
Thank you so much for your support

Userlevel 3
Badge

Hey @MarcoG

It sounds like you want to ask your audience a question and reveal the answer at the end of your presentation? 

Your options would be to manually add the data from the poll into a slide or to take a screenshot of the poll answer to go alongside your reality answer. Alternatively, you can export your poll results and add them to the slide. 

Let me know if there’s anything else I can help with!!

I see that you can only use the Quiz feature running live with one question at a time.  We would like to have a series of questions as a quiz that we will get results for after everyone has completed.  I created the quiz in your survey feature but how can I see what scores individuals have achieved (I have marked the correct answer against each individual multiple choice question) and one question is asking participant name?

Userlevel 5
Badge

Hey @LClarke75,

You can see participants’ results when you export Poll results per user. In the Excel sheet, you’ll see how each participant voted in every poll within the survey.

Hope this helps :)

Badge

Hi @Slido Team ,

When opening the Excel export “Poll results per user”, the columns show the question text only. 

If I use several surveys with the same question I’m not able to deifferciate these survey responses as the column has always the same name without naming the survey name.

The usecase is a Webex Webinar with several slots and I want to get a feedback after each slot. In my case with two ratings in a survey: “presentation quality” and “benefit for you”.

Can you expand the export with the survey name please?

Userlevel 5
Badge

Hey @Rouven Webcast Account,

That’s a good catch and I will feed this back.

At the moment, the only way to differentiate between the surveys would be to run them in two different events or to create a room for each survey.

Hope this helps!

Is it possible to export the quiz results, like the “Poll results per user”? I would like to be able to see and save the results of each user - to be able to identify areas where individuals had problems.

Thanks!

Userlevel 3
Badge

Hey @Kris Syvertsen ,

When exporting Poll Results per User, this should also include each Participants response to each of your Quiz Questions.

Could you check that this is working for you?

Best,

I don’t see that option under quizzes, am I looking in the wrong place?

 

Userlevel 3
Badge

Hey @Kris Syvertsen ,

You will need to go to the Analytics tab to export any data from the event, not the poll itself.

And then choosing Poll Results Per User. Both links will have steps and gifs showing you where and how to find these.

Let us know if you have any other questions!

Best,

Hi,

is it possible to export analytics separately per room in a pdf file?

 

 

 

Badge

Hey Giovanna,

You can export all questions and poll results for the whole event or per room. Select the format that works best for you, be it a comprehensive online infographic, Excel file, or pdf. Learn more about the exports in the Export your data article.

When it comes to PDF, it will be one file, but the analytics will be divided there per room.

Hope this helps!

Hello my export functionality is there, however when I download the xls files are blank? can anyone help. I think it might be an xls issue. All the answers are there in the dashboard. Appreciate it. 

Userlevel 3
Badge

Hey @MoffattS ,

Could you check that you have the Polls and Questions features enabled in the Event Settings?

And could you share what XLS export you are attempting that is showing blank? Are all your XLS files exporting blank?

For further troubleshooting please reach out to support@slido.com

Let us know if you have any other questions.

Best,

Can I use slido to order participants who answered all the questions of a quiz in slido correctly to download a certificate?

Userlevel 2
Badge

Hello @Mpota,

this is a nice idea but it is not possible to achieve this with Slido. You would have to manually evaluate these participants and send it to them in a different way.

Reply