Page 100 - Excel Data Analysis

06 537547 Ch05.qxd 3/4/03 12:11 PM Page 86

EXCEL DATA ANALYSIS

IMPORT A DELIMITED TEXT FILE

data analyst commonly needs to use data from Next, Excel displays the Text Import Wizard, which helps
programs other than Excel. Because you can export you to specify any import options you want to apply to the
A text files with most programs, text files become the file. The first thing you must decide is whether you want to
surest method for importing any data into Excel for analysis. delimit your imported text with a character, such as a
You can import any text file directly into Excel, which allows comma or tab, or organize it in fixed-width columns.
you to open data from different programs, including those Options in the Import Wizard either place the character of
that have file formats that Excel cannot open. You create a your choice between columns of data or align fields with
text file by exporting only the text portion of a file, omitting spaces between them.
any formatting and graphics in the file. After you have your To aid you in laying out the file, Excel displays a preview
data in Excel, you can edit and format it to suit your with any changes you apply. The preview window numbers
worksheet.
each row of data so you can determine which rows you
When you import a text file, Excel displays the Select Data want to import, thus eliminating the unwanted text that
Source dialog box, which you use to locate the file. After some programs place at the beginning of a text file. After
you specify the type of file you want to import, only files you select a row number, Excel imports the text file from
that match that type display in the dialog box. the specified row to the end of the file.

IMPORT A DELIMITED TEXT FILE

Text Files (*.txt; *.prn; *.csv; *.teb;*

⁄ Click Data ➪ Import ■ The Select Data Source ¤ Select the Text Files file ‹ Locate the folder
External Data ➪ Import Data. dialog box displays. type. containing the text file to
import.
■ You can click New Source
to start a Wizard that connects
to remote data sources.

86