Most of the time, dataset available on internet is in text file. This text file might have extension as .csv stands for Comma Separated Values or .tsv stands for Tab Separated Values. To process this data in efficient manner we may want to store this data in excel. So here are steps to convert your text file to excel.
Step 1 : Open empty excel book and visit 'data tab' of book and click on 'From Text' option from it.
 |
| Opening empty excel book and selecting data, From Text |
Step 2 : Select the file from appropriate location and click on 'Import button'.
 |
| Importing File |
Step 3 : Now select Delimited option to indicate values in text file are delimited by character such as white spaces or commas and click on Next button
 |
| Indicating values are delimited by characters |
Step 4 : Now select exact separator for like tab, semicolon, comma, space. In our case we have to select comma.
 |
| Indicating exact separator of values |
Step 5 : You can select datatype for each column. By default it is general. You can change it as per your requirement. Then select Finish button.
 |
| Specifying data type for each column |
Step 6 : You will get comma separated values in excel book.
 |
| Data in excel |
EmoticonEmoticon