IT Connect
Your connection to information technology at the UW

Import WebQ Data Into SPSS

Service notice: All Catalyst Web Tools–except WebQ Survey and GradeBook–have been retired. 

Follow these steps to import data from WebQ into SPSS 14.0. Please note that steps may differ for other versions of SPSS.

  1. StepsActions
  2. Navigate to the WebQ results page. There are two ways to get to the results page. On the WebQ home page, click the number in the submissions column, or from the summary page, click Results in the global navigation.
  3. On the results page, click Download SPSS file. You will move to the “Download SPSS File” page.
  4. Select the date range and type of data, and specify missing data codes. When you are done, click Download.
  5. Use the dialog box to save the .sav file to your computer.
  6. Open SPSS from the Start Menu or from a shortcut to the application itself.
    Note: If you attempt to open SPSS by double clicking the WebQ-generated .sav file, your data may open in the SPSS Syntax Editor instead of the SPSS Data Editor.
  7. From the File menu, point to Open, then click Data. This will open the “Text Import Wizard” with some of your data as a sample. There are six steps in the Text Import Wizard.Step 1
    Unless you have a saved template of the WebQ format, select No when prompted “Does your text file match a predefined format?” Click Next >.

    Step 2
    For the question “How are your variables arranged?” select Delimited. For the question “Are variable names included at the top of your file?” select Yes. Click Next >.

    Step 3
    For the question “The first case of data begins on which line number?” select 2. For the question “How are your cases represented?” select Each line represents a case. For the question “How many cases to you want to import?” select All of the cases. Click Next >.

    Step 4
    For the question, “Which delimiters appear between variables?,” select Comma. For the question, “What is the text qualifier?,” select Double quote. Click Next >.

    Step 5
    Adjust variable name, data format, and character fields as necessary. Click Next >.

    Step 6
    If you would like to save a template of the WebQ format, select Yes and click Save as… to browse to a place on your computer to save the format file. When you are done, click Finish to import the WebQ data in the SPSS Data Editor.

Tip: Check out the related documents section of this page to learn more about downloading your results as well as for help in translating SPSS variable codes.