Export output

Export Output saves Viewer output in HTML, text, Word, Excel, and PDF formats. Charts can also be exported in a number of different graphics formats.

To export output

  1. Make the Viewer the active window (click anywhere in the window).
  2. From the menus choose:

    File > Export...

  3. Enter a file name (or prefix for charts) and select an export format.
Objects to Export
You can export all objects in the Viewer, all visible objects, or only selected objects.
Document Type
The available options are:
  • Word/RTF (*.doc). Pivot tables are exported as Word tables with all formatting attributes intact (for example, cell borders, font styles, and background colors). Text output is exported as formatted RTF. Charts, tree diagrams, and model views are included in PNG format. Note that Microsoft Word might not display extremely wide tables properly.
Note: The Paste option is not available for the Word/RTF (*doc) setting.
  • Word (*docx). Pivot tables are exported as Word tables with all formatting attributes intact (for example, cell borders, font styles, and background colors). A *.docx file is an archive of XML files. Text output is XML. Charts, tree diagrams, and model views are included as high-resolution images (*.eps for macOS and *.emf for Windows). Note that Microsoft Word might not display extremely wide tables properly.
  • Excel. Pivot table rows, columns, and cells are exported as Excel rows, columns, and cells, with all formatting attributes intact (for example, cell borders, font styles, and background colors). Text output is exported with all font attributes intact. Each line in the text output is a row in the Excel file, with the entire contents of the line in a single cell. Charts, tree diagrams, and model views are included in PNG format. Output can be exported as Excel 97-2004 or Excel 2007 and higher.
  • HTML (*.htm). Pivot tables are exported as HTML tables. Text output is exported as preformatted HTML. Charts, tree diagrams, and model views are embedded in the document in the selected graphic format. A browser compatible with HTML 5 is required for viewing output that is exported in HTML format.
  • Portable Document Format (*.pdf). All output is exported as it appears in Print Preview, with all formatting attributes intact.
  • Text. Text output formats include plain text, UTF-8, and UTF-16. Pivot tables can be exported in tab-separated or space-separated format. All text output is exported in space-separated format. For charts, tree diagrams, and model views, a line is inserted in the text file for each graphic, indicating the image file name.
  • None (Graphics Only). Available export formats include: BMP, EPS, SVG, JPEG, PNG, TIF, and PDF. On Windows operating systems, EMF (enhanced metafile) format is also available.
Open the containing folder
Opens the folder that contains the files that are created by the export.

Output Management System. You can also automatically export all output or user-specified types of output as Word, Excel, PDF, HTML, text, or IBM® SPSS® Statistics format data files. See Output Management System for more information.