Exporting SPSS graphs and tables.

Steve Simon


*Dear Professor Mean

Dear Manic,

You can export both graphs and tables from SPSS and use them in other programs

I’ll show you how to export into Microsoft Word

More details

If you want to export a graph

The windows metafile format is usually a good choice

If you want to export a table

Exporting graphs

Once you create a graph in SPSS

wpe1C.gif (10603 bytes){width=“320” height=“319”}

To export a graph

wpe1B.gif (10798 bytes){width=“377” height=“287”}

The figure above shows the dialog box that you get. Click the arrow button next to the EXPORT field to select CHARTS ONLY. Click on the arrow button next to the FILE TYPE field to select WINDOWS METAFILE (.WMF). The windows metafile format is usually a good choice, because you can change the size of your graph later and still keep your lines and fonts looking smooth. Other formats such as bitmap (.BMP)

Click on the FILE PREFIX field to change the file name(s). Make sure that your file names include a drive letter and/or subdirectory that you will easily remember (c://My Documents is a good choice). In this example

Each software program has a different method for importing graph files. In Microsoft Word

wpeD.gif (14893 bytes){width=“620” height=“350”}

Your dialog box should look like the figure above. Click on the arrow button by the LOOK IN field to select the appropriate file location. In this example

wpeE.gif (8590 bytes){width=“320” height=“320”}

If you click on the graph itself

Exporting tables

You have several choices for exporting tables. Start by right clicking on the table you want to save.

wpe1C.gif (10680 bytes){width=“320” height=“318”}

You will then see a pop-up menu like the one shown in the figure above. Select COPY from this menu. This places your table on the windows clipboard. You can then paste inside any windows application. In Microsoft Word

wpe1D.gif (12619 bytes){width=“468” height=“282”}

This is the dialog box you will see. You have three different ways to paste your SPSS table into Word.

wpe1F.gif (6933 bytes){width=“320” height=“239”}

The PICTURE option will create a graphic image inside Microsoft Word (see above figure). This image looks nice

wpe20.gif (7345 bytes){width=“320” height=“239”}


wpe21.gif (7232 bytes){width=“320” height=“239”}


You can find an earlier version of this page on my original website.