Export Tables Dialog Box

You use the Exports dialog box when you want to export your results to other formats. To open the Exports dialog box, choose the following options from the menu:

Fields on the Export Tables dialog box

Export:

• All tables. Select if you want to export all of the tables in this table document.

• Selected tables. Select if you want to export only those tables that you have selected in the Tables pane. You can select multiple tables using Shift+click or Ctrl+click.

Export tables to. Select the export option you require. IBM® SPSS® Data Collection Survey Reporter comes with the following options:

• HTML. This option enables you to export tables and charts to HTML. The HTML export requires Microsoft Office Web Components (OWC) version 10 or later to create charts. However, this is not necessary if you want to export only tables.

• Microsoft Excel. This option enables you to export tables and charts to Microsoft Excel. The export creates output in Microsoft Excel that is suitable for printing and easy to manipulate. To use this option, you need to have Microsoft Office 2007 or later installed on your desktop machine.

• Microsoft PowerPoint. This option enables you to export tables to Microsoft PowerPoint as charts (by default) and tables. Each table or chart is created on a separate Microsoft PowerPoint slide. To use this option, you need to have Microsoft Office 2007 or later installed on your desktop machine. Considering that PowerPoint Export relies on the Microsoft Excel component, you should close all Excel files (to avoid an invalid export result) prior to starting the export.

• Microsoft Word. This option enables you to export tables and charts to Microsoft Word. The export has been designed to create output in Microsoft Word that looks good, is suitable for printing, and easy to customize. To use this option, you need to have Microsoft Office 2007 or later installed.

• Text file. This option enables you to export tables to a delimited text file (typically a .csv file).

Additional options are available depending on which type of export you select:

• HTML Export options

• Microsoft Excel Export options

• Microsoft PowerPoint Export options

• Microsoft Word Export options

• Text Export options