Microsoft Office Tutorials and References
In Depth Information
Import Data from a Text File
Chapter 7: Importing Data into Excel
Finish the Text Import
Wizard
1 Click a column.
2 Click to select the data
format you want Excel to
apply to the column.
1
If you select the Date
option, you can use this
drop-down list to select
the date format your data
uses.
3 Repeat steps 1 and 2 to
set the data format for all
of the columns.
4 Click Finish.
The Import Data dialog
box appears.
5 Select the Existing
Worksheet option.
2
4
5
6
If you want the data to
appear in a new sheet,
you can select the New
Worksheet option,
instead.
6 Click OK.
Excel imports the data to
the worksheet.
More Options!
Some text files may contain numbers that
use a comma instead of a dot as the
decimal separator, or a dot instead of a
comma as the thousands separator. To
import such data, click the Advanced
button in the Text Import Wizard – Step 3
of 3 dialog box to display the Advanced
Text Import Settings dialog box. Use the
Decimal Separator drop-down list to click
the text’s decimal separator, and use the
Thousands Separator drop-down list to
click the text’s thousands separator.
Important!
If you make a mistake when importing a
text file, you do not need to start the
import from scratch. Click any cell in the
imported data, click the Data tab, click the
Refresh All drop-down arrow, and then
click Connection Properties. Click the
Definition tab and then click Edit Query.
The Import Text File dialog box appears.
Click the file you want to import and then
click Import. Excel launches the Import
Text Wizard to enable you to run through
the wizard’s options again.
 
Search JabSto ::




Custom Search