Excel allows you to import data from various file formats. You can import data from websites, text files, XML files and many types of database files. Here is a simple text file that contains the following data. In this dataset, each field is separated by a comma and each record starts in a new line. To import above text file into an excel worksheet: 1. Select the cell where you want the data to be pasted. 2. Click the Data tab > click From Text > Text Import Wizard dialog box opens 3. There are two options here, keep the default option selected. Check My data has headers . 4. Uncheck Tab and Select comma. Click Next. 5. In step 3 of the Text Import wizard dialog, select the first column and select text option, select the second column and check the text option and repeat for the third. 6. Click finish. A Import Data dialog appears, click OK to accept the default. 7. Now you should have successfully imported the comma separ...
Education for everyone!