Microsoft Office Tutorials and References
In Depth Information
IMPORT A TEXT FILE
Many software applications have an option you can
use to export the application’s data to a text file.
You can import text files from other applications into
Excel by using the Text Import Wizard. You can then
use Excel to analyze the data. In fact, after you
import data, you can use it in a PivotTable, create
charts with it, or manipulate it just as you would
any other Excel data.
On the first page of the Data Import Wizard, you can
use the Start Import at Row field to specify the row
in your text file with which you want to begin the
import. If your data has titles or other information
you do not want to import at the top of the file, this
feature gives you the ability to skip those rows.
The Text Import Wizard can handle any delimited
or fixed-width file. A delimited file uses a comma,
semicolon, tab, space, or other character to mark the
end of each column. A fixed-width file aligns each
column and gives each column a defined width.
Click the Data tab.
Click From Text in the Get
External Data group.
The Import Text File dialog box
Click here and locate the folder in
which you stored your text file.
Click the file.