Q. How can I get Quatrics data in an Excel report, with student's answers on separate row per student?

Here is how to download Qualtrics survey data with student responses in rows:

1) From the home screen of Qualtrics, either:
a) click the “view results” tab at the top of the screen and select the appropriate survey, or
b) look at your list of surveys and click the “results” button (the graph icon) for the appropriate survey.
2) Click “Download Data” (floppy disk icon) in the light grey bar at the top of your screen.
3) No need to manipulate any settings: just click on the hyperlink for CSV file (“This is a Comma Separated Values format…”)
4) The CSV file should download to your computer (it may or may not arrive as a zip file depending on whether that option is clicked in the field above).