Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

How to export conso file in excel and how to open

abhi choudhary (accountant) (31 Points)

26 April 2018

how to convert my tds conso file in to excel or any other formet to read it.

Reply
Follow
Share

7 Replies

@VaibhavJ (Believe!! Live your dreams!) (33516 Points)
Replied 26 April 2018

Right click on file and open with excel.

Upgrade to CAclubindia Pro. Subscribe Now!

ARJAV SANGHVI (Self employed) (28 Points)
Replied 14 August 2018

its not working.. please suggest me what to do

Brajesh Accounts (19 Points)
Replied 16 September 2018

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.

3 Like

BHUVANESWARI PARAMOUNT (2 Points)
Replied 29 July 2021

Thank you soo much. Really very useful post.

kaliaraju (Accounts Executive) (22 Points)
Replied 06 January 2023

Thanks for solution......

Upgrade to CAclubindia Pro. Subscribe Now!

Ayush (Executive ) (6760 Points)
Replied 26 June 2023

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.