Millisecond Forums

Import Data in SPSS

https://forums.millisecond.com/Topic19194.aspx

By nbUOS - 6/1/2016

So here we are, data is almost in and i wanted to take a first look
Only now what I feared became true: importing my IAT data into SPSS is a h*** of a task... so my question:
are there any easy ways to do it?
rigth now i:
have one IAT file per subject
so i save these as .xls which i then open and copy paste into SPSS
is there a way to
- create 1 file for all subjects rather than 1 per subject?
- get all the files into SPSS with one step? (even two would be an improvement ;-))

cheers
By Dave - 6/1/2016

- Data files can be merged via File -> Merge Data Files in Inquisit Lab: https://www.millisecond.com/support/docs/v4/html/howto/howtocombinedata.htm
If you use Inquisit Web, data files will be automatically merged when you check multiple files to download.
- Inquisit data files are simple, tab-delimited text files. The can be imported directly by SPSS via its text file import facilities (both via the SPSS GUI as well as via SPSS syntax). Details are available in the SPSS documentation and you can also find various tutorials online:
https://www.google.com/search?q=spss+import+text+files
- There is no need for intermediary XLS files, but SPSS can read those directly as well. There is no reason to copy & paste them.
- SPSS can also merge data files, if that's what you prefer to do. You'll also find that covered in the SPSS documentation and various other sources available online: https://www.google.com/search?q=spss+merge+data+files

Hope this helps.
By nbUOS - 6/7/2016

thank you so much you saved me hours of work!