How to transfer text file data in to exel sheet

Hi
I want to transfer text file data in to an exel sheet.
For example I have data ABCDEFG in an text file and i want to export them in to an exel sheet so that ABCDEFG must appear in each column like A in 1st column, B in 2nd column, C in 3rd column and so on…

Regards,
BDO