survey export

sns 9,226 Reputation points
2020-08-13T07:46:20.287+00:00

I have used export to excel from survey list URL long back, for that I have used list ID and view id, which I forgot on how to get list and view id and apply it in the URL to get export to excel.

Please help me with clear steps in getting this done. Thank you

you can see example in the screenshot attached.
17431-capture.png

SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,883 questions
0 comments
Accepted answer
  1. ChelseaWu-MSFT 6,316 Reputation points
    2020-08-14T02:46:29.253+00:00

    To get the list GUID of a survey list:

    1. Navigate to the list and then go to Settings > Survey Settings.
    2. Right click on "Rating settings", select "Copy shortcut" and then paste the outcome in notepad.
    3. You should get a link formatted as http://<siteURL>/_layouts/RatingsSettings.aspx?List={538ce9a5-d3aa-4694-b758-ba7b92ba0521}.
      So the list ID is: {538ce9a5-d3aa-4694-b758-ba7b92ba0521}.

    To get the list view GUID:

    1. Navigate to “All Responses” view, right click on the page and then select “View source”.
    2. Search for View= on the Original Source page, and you should be able to find a string formatted as View={7910983b-0734-4c81-9eb5-191c4a4bdd88}&.
      So the list view ID is: {7910983b-0734-4c81-9eb5-191c4a4bdd88}.

    Reference: How to Edit SharePoint Survey "All Responses" View?

    ---
    In addition, there is another method to get both GUIDs at once:

    1. Click Actions > Export to Spreadsheet in the Survey list and then save the owssvr.iqy file on your local drive.
    2. Edit the owssvr.iqy file using Notepad and then you will find the GUIDs you need. 17505-annotation-2020-08-14-103249.png
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest