Why SPSS Output Needs Managing Before It Reaches Word
Run any analysis in SPSS and the Output Viewer fills up fast: a title, a notes block, a case processing summary, the table you actually need, a footnote or two, and a warning you did not ask for. Copy that whole window into Word and your results section turns into a mess of oversized tables, stray notes, and formatting that fights your document.
This guide covers four ways to get SPSS output into Word, from a quick copy-paste of one table to a repeatable syntax workflow you can rerun on a revised dataset. It works in recent versions of IBM SPSS Statistics, including versions 27, 28, and 29.
Before You Export: Tidy the Viewer First
Exporting is easier when the Viewer contains only what you want to keep. A few minutes of tidying saves far more in Word later.
Delete what you do not need
Click an object in the outline pane on the left of the Viewer to select it, then press Delete. Notes, warnings, and the case processing summary are the usual candidates. If you delete the wrong thing, use Edit > Undo, or simply rerun the analysis — the Viewer is a record of your run, not your data, so nothing in your dataset is at risk.
Hide objects you want to keep but not export
Right-click an object in the outline pane and choose Hide. Hidden objects stay in the Viewer but are excluded from most exports. This is useful when you want to keep a table for your own reference but not send it to your supervisor.
Reorder objects by dragging
Drag items in the outline pane to put your tables in the order they will appear in your results section. The export follows the outline order, so the sequence you set here is the sequence Word receives.
Method 1: Copy-Paste a Single Table (the Quick Way)
For one or two tables, copy-paste is the fastest route — and, done properly, it produces a fully editable Word table.
- In the Output Viewer, click once on the table to select it. A red border appears around it.
- Copy it with Edit > Copy, or right-click and choose Copy, or press Ctrl+C.
- Switch to Word and place the cursor where the table should go.
- Paste with Ctrl+V. Word inserts the table as a real, editable table, not a picture.
Two tips make this work much better. First, before copying, double-click the table to open the Pivot Table Editor and apply a clean TableLook — Format > TableLooks, and pick the Academic style or a similarly plain one. A table that starts plain needs far less reformatting in Word. Second, if pasting produces an image instead of an editable table, use Paste Special in Word (Home > Paste > Paste Special) and choose Formatted Text (RTF).
Copy-paste has one real weakness: it is manual. For a thesis with forty tables it is slow and error-prone, which is where the export methods below earn their keep.
Method 2: Export the Whole Viewer with File > Export
When you want everything — or everything visible — in one Word file, use the built-in export dialog.
- In the Output Viewer, go to File > Export.
- Under Objects to Export, choose All, All Visible, or Selected. All Visible is usually the right choice: it respects the objects you hid in the tidying step above.
- Under Type, choose Word (*.doc).
- Click Browse and choose a file name and location, for example Results_Tables.doc.
- Click OK.
SPSS creates a Word document containing each exported object in outline order: tables arrive as editable Word tables, charts arrive as images. Open the file and check the first table before formatting the rest — if it looks right, the rest will too, because they were all exported the same way.
If your tables are very wide, they may run past Word’s margins — widening the page to landscape, or setting a smaller font in the TableLook before exporting, usually fixes it.
Method 3: Export Selected Objects Only
Sometimes you want a subset of the Viewer — say, the three tables for Chapter 4, but not the exploratory output that came before them. Select the objects first, then export only those.
- In the outline pane, click the first object you want.
- Hold Ctrl and click each additional object to add it to the selection.
- Go to File > Export.
- Under Objects to Export, choose Selected.
- Set Type to Word (*.doc), choose a file name, and click OK.
Only the objects you selected are written to the Word file, in outline order. This is the cleanest way to produce one Word file per results section — for example, one file for descriptives, one for the t-tests, one for the regression — without deleting anything from the Viewer.
Method 4: Export with Syntax (Repeatable and Documented)
If you rerun your analysis after a data correction, every manual export has to be repeated. Syntax removes that problem: save the export commands in your syntax file and rerun them alongside the analysis. SPSS offers two syntax routes.
OUTPUT EXPORT: export the current Viewer
The OUTPUT EXPORT command writes the contents of the Viewer to a file. The simplest useful form is:
OUTPUT EXPORT /CONTENTS EXPORT=VISIBLE /DOC DOCUMENTFILE='C:\Results\Chapter4_Tables.doc'.
EXPORT=VISIBLE mirrors the All Visible choice in the dialog, so hidden objects stay out. Change VISIBLE to ALL if you want everything, and change the file path to a folder that exists on your computer — SPSS will not create missing folders for you.
OMS: route specific tables to a file automatically
The Output Management System (OMS) is more selective: it captures chosen output as it is produced and sends it straight to a file, before it even reaches the Viewer. This example captures every Frequencies table into a Word document:
OMS /SELECT TABLES /IF COMMANDS=['Frequencies'] SUBTYPES=['Frequencies'] /DESTINATION FORMAT=DOC OUTFILE='C:\Results\Frequencies_Tables.doc'.
After the OMS command, run your FREQUENCIES command as normal. The tables still appear in the Viewer, and a copy is also written to the Word file. When you are done, close the OMS routing with:
OMSEND.
OMS takes a little learning, but for a long thesis it is the most reliable workflow of all: the export is part of the analysis script, so a rerun after a data fix regenerates every table in the right file automatically.
Cleaning Up Tables in Word
Exported SPSS tables are editable, but they rarely look publication-ready on arrival. A short cleanup pass in Word makes the difference.
- Remove the SPSS title rows. Each exported table carries its own title (for example, “Descriptive Statistics”). In a thesis, the table title belongs in the text as an APA table title, so delete the title row from the table body and retype it above the table in APA format.
- Delete empty columns and redundant rows. SPSS tables often include columns you do not need to report. Delete them rather than leaving blank space.
- Apply one consistent table style. Select a table, go to Table Design in Word, and apply a plain format — horizontal lines at the top, below the header row, and at the bottom, with no vertical lines. Repeat the same style for every table.
- Check the numbers against the Viewer. After reformatting, spot-check two or three values in each table against the SPSS output. Reformatting is where transcription errors creep in, and a wrong decimal in a results table is worse than an ugly one.
- Set decimal places consistently. SPSS may export three decimal places where your style guide wants two. Edit the values in place, and keep the same precision across all tables.
Common Problems and Fixes
The table pastes as a picture, not an editable table. Use Paste Special in Word and choose Formatted Text (RTF). If you used File > Export, the tables should already be editable; a picture usually means the copy step took a screenshot-style copy instead.
Tables are too wide for the page. Apply a narrower TableLook in the Pivot Table Editor before exporting, reduce the font size, or switch Word to landscape orientation for the results pages. Long variable labels are a common cause — shorten them in Variable View before running the analysis.
Notes and warnings appear in the Word file. You exported All instead of All Visible, or the objects were not hidden. Hide or delete the notes in the Viewer and export again with All Visible selected.
The export produces an empty or missing file. Check that the folder in the file path exists, that the file is not already open in Word (SPSS cannot overwrite an open file), and that you have write permission for the folder.
Reporting in APA Style (7th ed.)
Exporting a table is only half the job; reporting it correctly is the other half. APA style (7th edition) expects tables to be numbered and titled, with a concise title in italic title case above the table, for example: Table 1, then Descriptive Statistics for Study Variables on the next line. Keep the table itself spare: three horizontal lines (top, under the column headings, bottom) and no vertical lines.
In the text, refer to the table by number — “Table 1 shows the means and standard deviations…” — and report only the values that answer your research question, not every cell. The full table carries the detail; the text carries the story. Report statistics to two decimal places, except p values, which APA reports to two or three decimals (for example, p = .031), or as p < .001 when the value is smaller than that. Never report a p value as .000.
Key Takeaways
- Tidy the Output Viewer first — delete or hide notes and warnings, and order the tables as they will appear in your results section.
- Copy-paste is fastest for one or two tables; use Paste Special > Formatted Text (RTF) if Word gives you a picture instead of an editable table.
- File > Export with All Visible sends a clean, ordered set of editable tables to Word in one step.
- Select objects in the outline pane and export Selected when you want one Word file per results section.
- OUTPUT EXPORT and OMS syntax make the export repeatable, so a rerun after a data fix regenerates your tables automatically.
- Clean up in Word: remove SPSS title rows, apply one consistent table style, set consistent decimals, and spot-check numbers against the Viewer.
Frequently Asked Questions
Can I export SPSS output directly to Word?
Yes. In the Output Viewer, go to File > Export, choose Word (*.doc) as the type, and click OK. Tables arrive as editable Word tables and charts as images. For a single table, copy-paste with Ctrl+C and Ctrl+V works too.
Why does my SPSS table paste into Word as an image?
Word sometimes takes the clipboard content as a picture. Use Paste Special (Home > Paste > Paste Special) and choose Formatted Text (RTF) to force an editable table. Exporting through File > Export avoids the problem entirely.
How do I export only some tables from SPSS to Word?
Select the objects in the outline pane with Ctrl+click, then use File > Export and choose Selected under Objects to Export. Or hide the objects you do not want and export All Visible. For a syntax route, OMS can capture only the tables you specify.
How do I make SPSS tables look APA style in Word?
Apply a plain TableLook such as Academic in the Pivot Table Editor before exporting, then in Word remove the SPSS title row, keep only three horizontal lines, delete unneeded columns, and use consistent decimal places. Add the APA table number and italic title above the table.
Need this done on your data? Get a free quote → /services/