What CSV preserves and loses
CSV represents rows and columns as text. It can preserve variable names and chosen displayed values, but the format has no standard place for SPSS measurement levels, print/write formats, multiple-response sets or user-defined missing values.
- Choose raw codes or displayed labels consciously
- Select a stable delimiter and text encoding
- Export the codebook alongside the data
- Keep the original SAV as the authoritative source
- Document filters and selected columns
Codes versus labels
A satisfaction value of `1` may mean “very satisfied”, but that meaning lives in the SAV dictionary. Exporting labels makes a CSV easier to read; exporting raw codes is often safer for analysis and joins. In many handovers, the best result is a raw-code CSV plus a separate codebook.
User-defined missing codes need equal care. A value such as 99 can look like a real number after conversion unless the missing rule is documented.
Local conversion for sensitive files
SAV Inspector Local reads and exports in the browser. The source file does not need to be sent to a generic online converter. Always inspect the resulting CSV in the destination tool and compare row counts, columns and representative values.
- Inspect the dictionary
Check variable names, labels, value labels and missing rules before choosing an export representation.
- Choose columns and value display
Decide whether the destination needs codes, labels or both in separate artefacts.
- Export data and codebook
Download the CSV and a metadata report so meanings are not separated from values.
- Verify in the destination
Compare row count, header, encoding, decimal representation and selected cases.
Frequently asked questions
Does CSV preserve SPSS value labels?
No. CSV has no standard value-label dictionary. Export a codebook or choose a label-rendered data representation deliberately.
Can Excel open the resulting CSV?
Yes, but delimiter, encoding, dates and decimal conventions must match the Excel locale or import settings.
Is CSV a lossless SAV backup?
No. Keep the original SAV or a verified SAV/ZSAV copy. CSV is a data interchange representation, not a complete SPSS archive.
Is the conversion uploaded?
Not in SAV Inspector Local. Reading and export run on the device in the browser.