Importing File

Select the Home tab.

In the File group, click Open to display the Open dialog box.

Select a text file (*.txt).

Click the OK button to display the Importing file dialog box.

This dialog box shows the following options:

Option	Description
Import as Spreadsheet	You can import the text file as a spreadsheet.
Delimited	A text file with separators between data elements (for example, tab characters or commas).
Fixed	A text file which has a fixed size for number of characters in each line.
Import as Report	Imports the text file to a report.
Set as default	Select this check box if you want the options selected in this dialog box to always be used as the default when a text file is imported.

Procedure