SoyaTools

SOYATOOLS / GUIDES

How to open a .sas7bdat file without SAS (and convert it to Excel)

A .sas7bdat file is a SAS data set. You often get one from a research project, a public data portal or a colleague who uses SAS, and without SAS there is usually nothing on a Windows PC that opens it. Here are the free code routes and a viewer that needs no SAS or programming.

Get it from Microsoft Store

SAV & DTA File Viewer for Windows, by SoyaTools. Viewing is free; Pro (one-time, no subscription) saves Excel and CSV copies. Files stay on your PC.

Updated November 16, 2026 · 5 minute read

Free options if you write code

Both are free. If you just need to look at the data or hand an Excel copy to someone, a viewer is quicker.

Open it with SAV & DTA File Viewer

  1. Install the app from Microsoft Store.
  2. Open the .sas7bdat, .xpt or .por file in the app. No SAS is needed.
  3. Read the variables with their labels, sort and search. File info shows the row and variable counts, the file label and the encoding.
  4. With Pro, save the data to Excel (.xlsx) or CSV.

SAS dates are shown as dates, and common SAS number formats such as DOLLAR, COMMA and PERCENT are applied. Korean text in CP949 or EUC-KR files is shown correctly.

FormatWhat is readAccuracy check (cells compared with pyreadstat 1.3.7)
.sas7bdat32- and 64-bit files, little and big endian, uncompressed and compressed (RLE and RDC)54 files, 29,416,727 cells, 0 differences
.xpt (SAS transport, XPORT v5 and v8)The first data set in the file17 files, 879,106 cells, 0 differences
.por (SPSS portable)Data, variable names and labels6 files, 208,077 cells, 0 differences

In total, 77 test files and 30,503,910 cells matched pyreadstat with no differences, including variable names, labels, formats and encodings.

Large files

Files are read in the background, so the window does not freeze. On our test PC, a 104 MB uncompressed .sas7bdat with 1,088,682 rows × 10 columns opened in 0.89 seconds, and a 105 MB RLE-compressed file with 184,480 rows × 100 columns in 0.97 seconds. When a data set has more rows than one Excel sheet holds, the Excel copy continues on a second sheet (“Data (2)”).

.xpt and .por files

SAS transport files (.xpt) in XPORT version 5 or 8 open the same way; the app reads the first data set in the file. SPSS portable files (.por) open with their variable names and labels. The text encoding choice is not used for .por files.

Limits

Free and Pro

Opening and viewing are free. Saving Excel and CSV copies, saving the variable list, copying several rows and converting many files at once are part of Pro, a one-time purchase in Microsoft Store (check the Store for the current price). The same app opens SPSS (.sav, .zsav) and Stata (.dta) files.

Files are processed on your PC and never uploaded. See the Privacy Policy.

FAQ

Can I open a .sas7bdat file without SAS installed?

Yes. SAV & DTA File Viewer reads .sas7bdat files on its own, and pandas (Python) or haven (R) can read them with code.

How do I convert sas7bdat to Excel?

Open the file in the app and save an Excel (.xlsx) copy with Pro. Very large data sets continue on a second sheet.

Why do my values show codes instead of labels?

SAS keeps format labels in a separate catalog file (.sas7bcat), which the app does not read. Values are shown as stored.

Can it open compressed SAS files?

Yes. Files compressed with RLE (CHAR) or RDC (BINARY) are read; both were part of the accuracy check.

Do .xpt and .por files work too?

Yes. SAS transport files (XPORT v5 and v8; the first data set) and SPSS portable files open the same way.

Get it from Microsoft Store

Related