File Excel. It is quicker lightweight and safer. Stores vba macro code or excel 4 0 macro sheets xlm.
Import a text file by opening it in excel go to file open and browse to the location that contains the text file. Select the text file you want to import. Click on the text file you want to convert to excel and click the get data or open button in the file navigator pop up.
Select the text file you want to import.
Locate and double click the text file that you want to open. This will open the text import wizard in a new pop up window. Select the text file you want to import. The binary file format biff12 for excel 2010 and excel 2007.