Procedure of Converting Form 26AS text file to excel file

Form 26AS is most important document for tax payers as it is a tax payment and deduction ledger for them. It shows Tax deducted /collected amount by deductors, Amount paid with TDS against form 15G/15H, tax paid by tax payer like advance tax,self assessment tax etc. Further it also shows refund amount . Every tax payer should match tax amount shown in form 26AS with tax claimed in Income Tax return before filing of income tax return. Now income Tax department have given automatic population of TDS entries in Income tax return from pan ledger/Form 26AS.

Form 26AS can be downloaded by three methods:

1. Through Income Tax India efiling login password.

2. Through online Banking account login password.

3. Through TIN-CPC website.

Form 26AS can be viewed online in HTML format and can also be downloaded in PDF or text format. The password for form 26AS file is Date of Birth provided in PAN database in ddmmyyyy format.

Click here to view the etutorial on how to convert the downloaded Form 26AS text file to excel file. 

5 thoughts on “Procedure of Converting Form 26AS text file to excel file

  1. Sundeep

    2-Aug-2016: The TRACES web-site gives error if you try to generate 26AS as text format. If you choose PDF format, it pops up a dialog saying you should choose HTML format. The HTML format shows correctly in browser but cannot be saved or printed correctly. In a country that prides itself on its IT knowledge and manpower, why can’t the IT department fix such an obvious problem on a site that is used by millions of people?

  2. Midhun

    Income tax department has made the entire process cumbersome. As usual the income tax dept has complicated this process also and i hope they will continue this in the future!!!


Leave a Reply

Your email address will not be published. Required fields are marked *