Microsoft Office Tutorials and References
In Depth Information
In some cases, you can access data on the web by using a Web Query (Data ⇒ Get Ex-
ternal Data ⇒ From Web).
Importing XML files
XML (eXtensible Markup Language) is a text file format suitable for structured data. Data is enclosed in tags,
which also serve to describe the data.
Excel can open XML files, and simple files will display with little or no effort. Complex XML files will require
some work, however. A discussion of this topic is beyond the scope of this book. You'll find information about
getting data from XML files in Excel's Help system, and online.
Importing a text file into a specified range
If you need to insert a text file into a specific range in a worksheet, you might think that your only choice is to
import the text into a new workbook and then to copy the data and paste it to the range where you want it to ap-
pear. However, you can do it in a more direct way.
Figure 16-2 shows a small CSV ( c omma- s eparated value) file. The following instructions describe how to im-
port this file, named monthly.csv, beginning at cell C3.
Figure 16-2: This CSV file will be imported into a range.
1. Choose Data ⇒ Get External Data ⇒ From Text to display the Import Text File dialog box.
2. Navigate to the folder that contains the text file.
3. Select the file from the list and then click the Import button to display the Text Import Wizard.
4. Use the Text Import Wizard to specify how the data will be imported. For a CSV file, specify Delimited
with a Comma Delimiter.
5. Click the Finish button. Excel displays the Import Data dialog box, shown in Figure 16-3.