We help IT Professionals succeed at work.

Exporting to SPSS Format

digraj asked
Medium Priority
Last Modified: 2013-11-15
How do I save an Excel file or any data file in SPSS format withouth having to go through SPSS.
Watch Question

Short answer: You can't.  Best option is to save as an Excel 2003 XLS and open that directly within SPSS.

Long answer: SPSS saves in a binary proprietary format (opposed to plain text).  If the SAV files were in plain text, you could reconstruct them line by line with an Excel macro.  Unfortunately, they're not.  So unless you personally can reverse engineer the code contained in an SPSS SAV file in order to figure out what all of their binary codes mean (and no one seems to have done so yet), you would never be able to create a properly constructed (i.e. non-corrupt) SAV file.

SPSS does have a fairly robust import engine, however, so there are many formats you can simply open within SPSS (including XLS and even XLSX as of SPSS 13, I believe).

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.