How to Convert Form 26AS Text File to Excel File

By | December 26, 2018
(Last Updated On: December 26, 2018)

Converting Form 26AS Text File to Excel File

•Tax Payer can view/download 26AS from TRACES from A.Y 2009-10 onwards . 26AS is available for download from

Zip file will be downloaded

Extract the Text file

:-Password to open for Form 26AS in PDF/Text Format is “ Date of Birth of Taxpayer“ in DDMMYYYY format.

Where transactions are 2000 or more than 26AS would be available only in text file. Deductee has to place the download request and need to convert it into excel


Select the complete text and Copy the data to MS Excel Worksheet

Select the entire first column “A” in the worksheet
 Click on Data written in the header of MS Excel Worksheet
 Select option Text to columns a small window will pop up
 Select “Delimited” and click on next
 Then select “Others” and Place “^” in the box and click on next
 Click on “Finish” and data will get converted to Excel format

One thought on “How to Convert Form 26AS Text File to Excel File

  1. Pingback: How to Check 26AS ( Income Tax TDS ) Online - Tax Heal

Leave a Reply

Your email address will not be published.