Posted by: tonyteaching | February 2, 2009

Importing data from EXCEL

We can import data from Excel (or other databases).

Before we import make sure the data in Excel is in one table and laid out in the same way as in SPSS’ Data View (variables as the columns, the column’s order, etc)

then…from SPSS Aplication:

File > Open > Data …..> choose “*.xls” and

on the panel, define the Worksheet, Range, and thick ‘Read variable names from the first row of data’ if we want to import the Headings as well.

Then..check on the ‘Variable view’ maybe there are some properties need to be modified.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: