SPSS, SAS and Stata each keep data in their own file format, and each costs hundreds of dollars a year. That leaves a lot of people with a .sav, .sas7bdat or .dta file they can't open: students handed a course dataset, journalists and researchers downloading public survey data, anyone sent results by a statistician. Excel and Google Sheets don't read these files, and the usual advice - install R, Python or PSPP - is a lot of setup to look at one table.
This page reads them with ReadStat, the open-source library behind R's haven package and Python's pyreadstat, compiled to run in your browser. You see the data as SPSS shows it, with value labels such as "Male" and "Female" in place of 1 and 2, the variable labels, formats and missing values, and a first look at the numbers: descriptive statistics and frequency tables. Save it as an Excel workbook or CSV to work with it anywhere. R .rds and .RData files open in the RDS & RData Viewer.
- Can I open an SPSS file in Excel?
- Not directly: Excel does not read .sav files. Open it here and choose Save as Excel. The workbook has the data with its value labels, a second sheet with the numeric codes for analysis, and a sheet listing every variable with its label, format and missing values.
- What are value labels and user-defined missing values?
- SPSS stores answers as numbers and keeps the words separately: 1 might be labelled "Strongly agree". Value labels shows the words; untick it to see the codes. User-defined missing values are codes such as 99 or -1 that mean "no answer"; they are shown greyed and left out of the statistics, as SPSS does.
- Is this a replacement for SPSS or PSPP?
- For looking at data and a first summary, often yes. For analysis - crosstabs, t-tests, regression - use PSPP (the free SPSS look-alike), R or Python, or open the Excel export in a spreadsheet. This page reads files; it does not run SPSS syntax.
- Why are some SAS values numbers instead of labels?
- SAS keeps value labels (formats) in a separate catalog file, usually formats.sas7bcat, not in the .sas7bdat itself. Choose both files together and the labels appear.
- Can I open an .spv file without SPSS?
- Yes. An .spv file is the output SPSS saves from its Viewer window - the tables and charts from your analysis, not the data. Drop it here to see the outline and the output the way SPSS shows it, with hidden items (such as the Notes tables) behind "Show hidden items". Pivot tables in the format SPSS and PSPP write today are shown in full. Older-style (legacy) tables, which earlier SPSS versions wrote, are drawn too - their rows, columns, layers, groups, number formats, title, caption and footnotes, without SPSS's colours and fonts - and one using a part of that format this page does not read is listed by name with a note, as are charts SPSS kept as chart data rather than a picture. Password-protected output, and .spo files from SPSS 15 and earlier, do not open here.
- Can I open a JMP file without JMP?
- Yes, a JMP data table (.jmp) saved by JMP 11 or later opens here like the other files, and saves as Excel, CSV or JSON. Only the table's data comes across: JMP's scripts, formulas (their results are kept as values), and saved reports and graphs are not read. Tables from versions before JMP 11 use an older format: save them again in JMP, or export them from JMP as CSV.