Say that a list of salespeople with their order dates and order amounts is updated weekly in the source database. You'd want to create a report in Excel that you can update every week, to keep it current.
If there's any chance that you might eventually want to — or have to — update the imported data if the external data changes, you should import the external data by using the Data menu method:
On the Data menu, you point to Import External Data, and then click Import Data. Follow the rest of the steps to open the file as shown in the picture. After you click Open, the Text Import Wizard will open. You'll see next how to use the wizard.
Note In this case, when you import a .csv file, it won't open directly in Excel as it does when you use the File menu, it will open the Text Import Wizard. This way, you can use the options in the wizard to make the data look tidy, if necessary, before you import it into Excel.