This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?

Microsoft Excel 2007/2008

Importing an External Data File

Importing data into an Excel worksheet is helpful if you want to use Excel to view, process and/or analyze data stored in another file. For example, many people store data as tab-delimited text files or comma-separated values (csv) files because they can be opened from practically any computer.

  1. Windows: From the Data command tab, in the Get External Data group, click FROM TEXT
    Macintosh: From the Data menu, select Get External Data » Import Text File...
    The Import Text File/Choose a File dialog box appears.
    Import Text File dialog box

  2. Windows: From the Files of type pull-down menu, select All Files
    Macintosh: From the Enable pull-down menu, select All Files

  3. Navigate to and select the file to import

  4. Windows: Click IMPORT
    Macintosh: Click GET DATA
    The Text Import Wizard appears.
    Text Import Wizard - Step 1 of 3

  5. Select Delimited or Fixed Width
    The Text Import Wizard automatically selects the display type that it thinks best fits your data.
    A delimiter is a character that separates pieces of data and was specified when the data was created.

  6. Click NEXT

  7. If your data is delimited, change and/or confirm the delimiters and click NEXT
    NOTE: The Text Import Wizard automatically selects the delimiter that it thinks is being used (usually Tab). However, you can specify a different delimiter such as, Semicolon, Comma, or Space.

  8. Click FINISH
    The Import Data dialog box appears.
    Import Data dialog box

  9. To place the data in a new worksheet, select New worksheet
    To place the data in the existing worksheet
    1. Select Existing worksheet
    2. Click COLLAPSE DIALOGCollapse Dialog button
    3. Select the cell where the imported data will begin
    4. Click RESTORE DIALOGRestore Dialog button

  10. Click OK
    The data appears in the designated location.

Excellence. Our Measure. Our Motto. Our Goal.