Page 646 - Excel 2013 All-in-One For Dummies

628 External Data Query
✦ Existing Worksheet option button (default) to have the data in the data table(s) selected on the web page imported into the current worksheet starting at the current cell address listed in the text box below.
✦ New Worksheet option button to have the data in the Access data table imported into a new sheet that’s added to the beginning of the workbook.
You can also select the Add This Data to the Data Model check box to have Excel automatically relate the imported web data tables to data lists in the workbook’s existing Data Model.
After you click OK in the Import Data dialog box, Excel closes the box and then imports all the tables of data you selected on the web page into a new worksheet starting at cell A1 or in the existing worksheet starting at the cell whose address was entered in the text box in the Import Data dialog box.
You can only make web queries when your computer has Internet access. So, if you’re using Excel on a device that can’t connect to the web at the moment, you won’t be able to perform a new web query until you get to a place where you can get online.
Retrieving data from text files
If you have a text file containing data you need to bring into your work- sheet, you can import it by clicking the From Text command button on
the Get External Data button’s drop-down menu on the Ribbon’s Data tab (Alt+AZXFT) and then selecting the file to use in the Import Text File dialog box. After you select the text file containing the data you need to retrieve in this dialog box and click its Import button, Excel opens the first dialog box of the Text Import Wizard, which you can then use to tell Excel how to split up (or parse) its data into separate cells of the worksheet.
Most text files containing lists of related data use some sort of standard character to separate each data item (such as a comma or tab) in every line, just as it uses the character for the Enter key to mark the separation of each line of data within the file. Those text files that use the comma to separate data items are known as CSV files (for Comma Separated Values). Those that use tabs to separate the individual data items are known as Tab delimited files. Note that some programs use the generic term, delimited files, to refer to any text file that uses a standard character, such as a comma or tab, to separate its individual data items.
The Text Import Wizard uses these facts about text files to analyze the struc- ture of incoming text files to help you to determine how to parse the data in the text file. Because the Text Import Wizard always imports the parsed text data into the current worksheet starting at the active cell and then uses as many subsequent columns and rows as necessary, you should always select