The Source for Crime and Justice Data

How do I use Excel to import tab-delimited ASCII data?

SAMHDA produces and makes available for download ASCII data files in two formats. The first of these is a fixed-format data file (da99999-9999.txt) to be used in conjunction with a setup file for SAS, SPSS, or Stata. The second format is a tab-delimited data file (da99999-9999.tsv).

Note: The Import Wizard for SAS, SPSS, and Stata can read the tab-delimited file into the statistical package. However, if using one of these statistical packages SAMHDA encourages you to use the fixed-format (.txt) data file to read in the data with its' accompanying setup file.

Warning: An error will occur if you try to read in a data file with more than 65,536 cases or 256 variables. These are the maximum limits that an Excel spreadsheet can handle.

Instructions

1. Download the tab-delimited ASCII data file from the SAMHDA Web site.

2. Most of the files downloaded from the ICPSR Web site will be compressed. You will have to decompress the files using WinZip or other decompression software. More information about decompressing files can be found at the help page, How do I decompress the files I download from your site?

3. Open Excel for Windows.

Screen Shot

4. Open the tab-delimited ASCII data file.

Screen Shot

5. This will open Excel's text Import Wizard Step 1 of 3.

Screen Shot

6. Go to Import Wizard Step 2 of 3.

Screen Shot

7. Go to Import Wizard Step 3 of 3.

Screen Shot

8. Review imported data file.

Screen Shot

You now have completed importing the data file. Row 1 will contain the names of the variables. Column A will be the CASEID variable. To confirm the import worked properly scroll across and down to check on the number of variables and cases imported. Compare these numbers against those provided by SAMHDA in the file manifest. This file can be accessed by going to the bottom of the study's Description and Citation or Browse Documentation pages.

Creative Commons License This work is licensed under a Creative Commons Attribution-Noncommercial 3.0 United States License.