Skip to main content

Notifications

Dynamics 365 Community / Forums / Human Resources forum / Export Excel from Ques...
Human Resources forum
Suggested answer

Export Excel from Questionnaire Answers

Posted on by 40

Hello everyone, 

Is there a way of exporting the answers provided on a questionnaire to an excel spreadsheet? I can't seem to find such an option or any table within the database. 

Thank you in advance for your help. 

  • Suggested answer
    Parag Chapre Profile Picture
    Parag Chapre 12,265 Most Valuable Professional on at
    RE: Export Excel from Questionnaire Answers

    Hi Lou,

    I checked the above forms and unfortunately, there is no entity available in Data management. I am afraid you cannot extract the information in excel.

  • RE: Export Excel from Questionnaire Answers

    Hi Parag,

    Thank you once again for your time, attention and expertise.

    I have designed a questionnaire with 8 questions (for testing purposes) and they have been answered 3 different times now.

    I'm looking to export all these answers to excel but none of the available options (like the one you mentioned) seem to refer to these answers.

    When accessing the tab Learning > Links you can find the following links under the "View and analyze results", namely:

    • Answers
    • Answers by person
    • Questionnaire respondents
    • Questionnaire results

    However, upon going to each one of these pages individually and pressing the "Open in Microsoft Office" button, it always exports something irrelevant.

    For example:

    Answers Page

    pastedimage1634576996311v1.png

    Answers by People

    pastedimage1634577270849v3.png

    Questionnaire Respondants

    pastedimage1634577114229v2.png

    Questionnaire Results (No Download Option)

    I wonder where one is allowed to find and export all the answers provided in one table for further data work. 

    Thank you once again for your time. 

  • Suggested answer
    Parag Chapre Profile Picture
    Parag Chapre 12,265 Most Valuable Professional on at
    RE: Export Excel from Questionnaire Answers

    Hi Lou,

    Do you see this option enabled on the form ?

    pastedimage1634574520085v1.png

    If yes then you can export the data otherwise you need to find a data entity in the system.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans