Home / server / Questions / 9912
Accepted
Brian
Asked: 2009-05-20 07:10:51 +0800 CST

Create a SharePoint Survey from an Excel spreadsheet

  • 772

Is there a way to import information into a survey from an external datasource? I have a user who has a spreadsheet full of measures (Over 300 of them) who would like to create a few surveys in SharePoint so that he could ask our users to rate some software based on these measures.

Manual data entry of all 300+ measures directly into a survey would take a LOT of time. Is there an easy way to get these measures into a survey?

Thanks to Adam for his answer below. As an admin, some pointers as to how to use these objects from Power Shell or Iron Python would help as well.

sharepoint

2 Answers

  1. Best Answer

    Never done it myself, but perhaps you could combine this code which programmatically creates the basics of a survey with this code which adds the questions. It shouldn't be too hard to do some sort of mail merge to convert your user's spreadsheet into code which will create the questions.

    • 2

  2. I wonder if this tool would be useful to you. It is called SharePoint Survey Loader. It allows you to input possible answers separated by semicolons so I'm thinking save as custom CSV file from your spreadsheet.

    http://sharepointsurveyimportloader.cyberpine.com/

    • 1