Downloading Survey results and opening them in Microsoft Excel is a great way to view and organize your collected data.
In the Control Panel of your course, go to the Grade Center. Select Full Grade Center.
Scroll until you find the Survey assignment column.
Click the contextual menu icon to the right of the Survey name. Choose Download Results.
The Download Results screen will appear. It is easiest to leave the settings as default; any changes made here will alter the file to your preferences. When satisfied with your settings, choose Click to download results.
The Download window will appear. From this you can open the file directly with Microsoft Excel, and then save it to your computer for further editing.