Importing data into SPSS

May 3rd, 2006 andris

Importing some data

If you have a small amount of data you want to get into SPSS, the most easy way is to simply Copy Paste it into SPSS. Be aware to check if everything ends up in the right cell, and if  you really have all the data you need. The most safe way to get this data into SPSS, would be to import it. Especially if you have a lot of data.

Importing a lot of data

There are a number of file formats SPSS can import data from. In general it is handy – but optional – to have a header row in the top of your file with descriptions of the columns. This means that you add one line before all the cases, where you put the name of the column (or variable).

Importing data from an Excel file
Importing data from an ASCII file
Importing data from a tab delimited text file

Entry Filed under: 0. SPSS, where to start,Questions and answers

5 Comments

  • 1. SPSSlog.com » Impor&hellip  |  May 3rd, 2006 at 5:09 am

    [...] First refer to Importing data into SPSS. If you have read it, than you can continue below. [...]

  • 2. SPSSlog.com » Impor&hellip  |  May 3rd, 2006 at 6:19 am

    [...] First refer to Importing data into SPSS. If you have read it, than you can continue below. Before you start the actual import process, please keep in mind that the Excel file should not be opened in Excel. [...]

  • 3. SPSSlog.com » Impor&hellip  |  May 3rd, 2006 at 7:00 am

    [...] First refer to Importing data into SPSS. If you have read it, than you can continue below. Typically, columns of data in an ASCII file are separated by a space, tab, comma, or some other character. SPSS has a Text Import Wizard that will help you import data in an ASCII file format: [...]

  • 4. shir  |  June 30th, 2006 at 3:43 pm

    thank you

  • 5. Scott Olds  |  August 15th, 2008 at 9:09 am

    I have an excel file that i am trying to import into SPSS MAC 15. The data are coming in but several of the variables in the excel file that are text/string show up in SPSS as . or missing. i have changed the SPSS system file to reflect these data as string and have changed the excel file variables from General to text in hopes of capturing the original string/text data but neither is working. This cannot be that hard but i seem to be succeeding in making it so.

    Help!


Calendar

May 2006
M T W T F S S
« Apr   Aug »
1234567
891011121314
15161718192021
22232425262728
293031  

Most Recent Posts