1.) On the File menu, click Import.

2.) In the Import dialog box, click the option for the type of file that you want to import, and then click Import. 3.) In the Choose a File dialog box, locate and click the CSV, HTML, or text file that you want to use as an external data range, and then click Get Data.  

4.) Follow the steps in the Text Import Wizard, where you can specify how you want to divide the text into columns and other formatting options. When you have completed step 3 of the wizard, click Finish.

5.) In the Import Data dialog box, click Properties to set query definition, refresh control, and data layout options for the external data that you are importing. When you have finished, click OK to return to the Import Data dialog box.