Exporting to Microsoft Excel

Once your responses are categorized, you will probably want to analyze your results using statistical procedures. IBM® SPSS® Text Analytics for Surveys allows you to create a data file that is formatted for use within different products. The following instructions are for exporting into an Microsoft Excel format. SPSS Text Analytics for Surveys will automatically create the multiple-response variable in your exported file. The exact format of the file depends on the data type you select—dichotomies or categories. The resulting file contains the IDs for the responses as well as the category names and labels, but it does not contain the values for any reference variables or the open-ended responses.

To Export Data

  From the menus, choose File > Export Results > Microsoft Excel File. The Export dialog box opens.

 From the Save In drop-down list, select the drive and folder in which you want to save the file.

 Select a Data Type option. See the topic Exporting Categorization Results for more information.

• Dichotomies.

• Categories. This option is not available for the IBM® SPSS® Data Collection data file, and Dichotomies is selected by default.

 From the Question drop-down list, select the question that you want to export. You can choose whether to export the categorization results for a single question or for the entire project. If you want to export each question separately, you must select and export each question one at a time. Or, select Entire Project to export the results for all open-ended questions.

 Select a worksheet naming option to designate how each worksheet generated in the exported Microsoft Excel file should be named. Choose from the following:

• Question names. Uses the open-ended text variable (question) name as the worksheet name. The question name comes from the original data source. If the outputted category variable name doesn't meet variable-naming conventions or exceeds 40 characters, then default names are created (per the Autogenerate option).

• Autogenerate names. Automatically names the worksheets with Q1, Q2, Q3, and so on. Q1 refers to the first question you export, and so on.

• Question labels. Uses the open-ended text variable (question) label, if one exists, as the worksheet name. If the outputted category variable name doesn't meet variable-naming conventions or exceeds 40 characters, then default names are created (per the Autogenerate option).

 If you have response flags in your data, you can also choose whether to export them. To export response flags, select that option. See the topic Flagging Responses for more information.

 In the File Name text box, select the default project name that appears, or enter another name for this file.