Creating a SharePoint Survey from an Excel Spreadsheet
I am an administrator, not a programmer. Someone on the server thought I should try this question.
Is there a way to import information into a survey from an external data source? I have a user who has a table full of measures (over 300 of them) who would like to create multiple surveys in SharePoint so that he can ask our users to rate some programs based on those measures.
It will take a long time to manually enter data for all 300+ measures directly into the survey. Is there an easy way to take these steps in a survey?
a source to share
A survey is just a SharePoint list with a column for each question. Opening the list in a data table view might do what you need.
You can also create a list from a spreadsheet. This will not be a survey, but you should be able to export it as a template and copy the xml for the columns into another template that is a survey.
a source to share