pspp-users
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: importing Microsoft Office Excel files into PSPP


From: Alan Mead
Subject: Re: importing Microsoft Office Excel files into PSPP
Date: Tue, 12 Nov 2019 08:57:21 -0600
User-agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:60.0) Gecko/20100101 Thunderbird/60.9.0

I don't think that's supported. In the past, the advice has been to save
the XLSX file as a supported format (ODT or delimited file) and import that.

I recommend doing this for SPSS as well, because when I import an Excel
file directly in SPSS, it makes guesses about variable types/lengths
that I frequently don't like. I've had it guess wrong about string
length causing data loss. That seems ridiculous.

-Alan

On 11/12/2019 8:47 AM, Dr Richard Fiene wrote:
> Has anyone had problems in importing Microsoft Office Excel files into PSPP?
> *__________________________*
> *Richard Fiene, Ph.D., Research Psychologist*
> [image: iD icon]*orcid.org/0000-0001-6095-5085
> <https://orcid.org/0000-0001-6095-5085>*
> *The Pennsylvania State University*
> *Research institute for Key Indicators*
> *National Association for Regulatory Administration*

-- 

Alan D. Mead, Ph.D.
President, Talent Algorithms Inc.

science + technology = better workers

http://www.alanmead.org

"A human being should be able to change a diaper, plan an
invasion, butcher a hog, conn a ship, design a building,
write a sonnet, balance accounts, build a wall, set a bone,
comfort the dying, take orders, give orders, cooperate,
act alone, solve equations, analyze a new problem, pitch
manure, program a computer, cook a tasty meal, fight
efficiently, and die gallantly. Specialization is for 
insects."

-- Robert A. Heinlein



reply via email to

[Prev in Thread] Current Thread [Next in Thread]