Create a Data Connector for SPSS format files

For anyone landing here from a search while this idea waits for votes: there is a way to read .sav files in Power Query today with nothing installed. I wrote a pure M reader for SPSS system files: https://github.com/Hugoberry/powerquery-driverless/tree/main/spss It is plain M source. Paste it into a blank query named Spss.Document, then: let Source = File.Contents("C:\data\survey.sav"), Doc = Spss.Document(Source), Data = Doc{[Name = "Data"]}[Data] in Data No R, no Python interpreter, no ODBC driver, no admin rights. Because there is no script host involved, it also refreshes in the Service. On the labels problem several people raised above: that was the part I cared about most. The result is a navigation table with three rows. Data is the cases. Variables is the dictionary (name, variable label, type, format, measurement level, user-missing declarations). ValueLabels is one row per variable/value/label, so the code lists arrive as a table you can join or use as a lookup dimension. If you want the labels in place of the codes instead: Spss.Document(Source, [ApplyValueLabels = true]) and to treat user-missing values as null the way SPSS does in analysis: Spss.Document(Source, [UserMissingToNull = true]) It handles uncompressed and bytecode-compressed .sav plus .zsav, long variable names, string variables wider than 255 bytes, and the SPSS date/time formats. The limitations are in the README: big-endian and EBCDIC files raise a clear error, case weights are reported but not applied, and the whole file is buffered, so it suits survey-sized files rather than multi-GB extracts. The decode is verified cell by cell against pyreadstat/ReadStat, the same engine behind R's haven. The same repo has readers for Stata .dta, dBASE/FoxPro, Access, SQLite and others on the same no-install principle.