Import data from a tab delimited text file

May 3rd, 2006 andris

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

1. Select File -> Open -> Data
2. Choose Text as the File Type
3. Select the file you want to import and click Open

Open tab delimited text file

4. The next thing that will pop up is the Import text wizard. First click Next if your file does not match a predefined format. It probably doesn’t, so click Next. :)  

Importing a tab delimited text file step 1

5. In step 2, you can set the first question to Delimited. In the second question you choose wether you have a header row or not (are variables names included in the top of the file). After setting the options right, choose Next.

Importing a tab delimited text file step 2

6. In step 3, set the line where the first case of your data begins (normally on line 1), set how your cases are represented (normally each line represents a case), and how many cases you want to import (choose for yourself, normally you import All of the cases. Click Next.

Importing a tab delimited text file step 3 

7. In step 4, set the delimiters of your file (Tab it would be). If your text has quotes (or anything else) around it, than specify this. In most cases you can just set it to None. As you can see, based on the choices you make here, SPSS already formats the file in the small screen in the bottom. There you can check if everything is set correctly. Choose Next when it looks fine.

Importing a tab delimited text file step 4 

8. In step 5 you can set the specifications for the variables, but you can just skip it if you have already defined your variables or want to do it later. Choose Next.

Importing a tab delimited text file step 5

9. In step 6 you can just leave all the options as they are, and click Finish. You’re done!

Importing a tab delimited text file step 6

Entry Filed under: 1. Getting data into SPSS,Questions and answers

3 Comments

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

    [...] Importing data from an Excel file Importing data from an ASCI file Importing data from a tab delimited text file [...]

  • 2. John  |  November 4th, 2007 at 9:41 pm

    Thanks mate. Helped me out of a bind there. Thanks for putting the effort in to make this faq

  • 3. Jon  |  July 8th, 2011 at 11:44 am

    What if equipment specs are in the top most row and variable names are the second row, how do I get it to recognize those variable names.


Calendar

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

Most Recent Posts