Excel Delimited file

This is a common technique Developers.Testers.DB admin come across most of the time.

You got a delimited files with a comma or a space or a Tab and you want to make that to a separate column.
Open the text file in Excel.Excel->Open->View all files and select the file.If it is Excel 2007 it will automatically pops up a window that says Text Import Wizard Mode.

otherwise if it is older excel version Click on Data->Text to Columns
It will open a Wizard Select it as Delimited and Click on Next and Select the Delimiters and click Next and Finish.The final conversion will be the values in delimited file are seperated as Column.