Copying output into other applications

Output objects can be copied and pasted into other applications, such as a word-processing program or a spreadsheet. You can paste the output in various formats. Depending on the target application and the selected output objects, the following formats can be available:

Metafile
WMF and EMF metafile format. These formats are available only on Windows operating systems.
RTF (rich text format)
Multiple selected objects, text output, and pivot tables can be copied and pasted in RTF format. For pivot tables, in most applications this means that the tables are pasted as tables that can then be edited in the other application. Pivot tables that are too wide for the document width is either wrapped, scaled down to fit the document width, or left unchanged, depending on the options settings in pivot tables. See the topic Pivot Tables options for more information.
Image
JPG and PNG image formats.
BIFF
Pivot tables and text output can be pasted into a spreadsheet in BIFF format. Numbers in pivot tables retain numeric precision. This format is available only on Windows operating systems.
Text
Pivot tables and text output can be copied and pasted as text. This process can be useful for applications such as email, where the application can accept or transmit only text.
Microsoft Office Graphic Object
Charts that support this format can be copied to Microsoft Office applications and edited in those applications as native Microsoft Office charts.

Because of differences between SPSS® Statistics charts and Microsoft Office charts, some features of SPSS Statistics charts are not retained in the copied version. Copying multiple selected charts in Microsoft Office Graphic Object format is not supported.
If the target application supports multiple available formats, it may have a Paste Special menu item that allows you to select the format, or it may automatically display a list of available formats.
Notes:
  • Microsoft Word may not display extremely wide tables properly.
  • Microsoft Office version 16 (or higher) is required when you copy and paste Boxplots and Histograms.
  • Due to limitations in web browsers and restrictions in the clipboard API, you cannot copy charts as Microsoft Office Graphic Objects and paste them into web view of Microsoft Office 365 applications.

Copying and pasting multiple output objects

The following limitations apply when pasting multiple output objects into other applications:

RTF format
In most applications, pivot tables are pasted as tables that can be edited in that application. Charts, trees, and model views are pasted as images.
Metafile and image formats
All the selected output objects are pasted as a single object in the other application.
BIFF format
Charts, trees, and model views are excluded.

You can also use Export output to export multiple output objects to other applications or formats.

Copy

You can select one or multiple objects in the Output Viewer, right-click, and select Copy to copy the selected items in all available formats. Alternatively, you can select one or multiple objects in the Output Viewer and select Edit > Copy.

Copy as

You can select an object in the Output Viewer and select Edit > Copy as to copy to the most popular formats (for example, Microsoft Office Graphic Object or Image). If Copy as is disabled or not present for a selected object, this copy format is not available for that particular object.