How to export conso file in excel and how to open

Right click on file and open with excel.

its not working.. please suggest me what to do

Dear Mr. Choudhary,

First you need to unzip the file and you will get the .txt file, save it and open a new excel sheet then go to data tab and click on from txt- select delimated- and in other, type "^"- click next.

there you go, your data is in excel format.

Thanks.

Thank you soo much. Really very useful post.

Thanks for solution......

Have tried. it works. 

Here are the steps :

• Unzip the file to access its contents.
• Locate the resulting .txt file that you obtained after unzipping. Save the .txt file to a desired location on your computer.
• Open a new Excel sheet. Go to the "Data" tab in Excel. Click on the "From Text" option.
• Select the .txt file and click on import.
• 
• Choose the file type - Delimited and click "Next" to proceed.
• 
• Click "Finish" to import the text file data into the Excel sheet.

Well explained in steps. Thanks 👍👍👍👍