Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
Give this a shout over on also! – squillman May 19 '09 at 15:26
up vote 2 down vote accepted

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.

share|improve this answer

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.