Converting 26AS to Excel: Procedure for conversion


Converting 26AS to Excel: Procedure for conversion



There are situations where taxpayers want to see or use the date of 26AS in excel whereas the income tax portal gives it in HTML or PDF format.

Here is procedure to convert 26AS in excel format. One can do it by following the procedure.

At present, taxpayer can view/download 26AS from the income tax portal  in following two formats:

  1. a) PDF
  2. b) Text

At present, there is no Password required to open for Form 26AS.

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

The procedure to convert the 26AS in to excel is as under:

  1. Login to TRACES site
  2. Taxpayer needs to open text file by giving password as “Date of Birth of Deductee” in DDMMYYYY format
  3. As a result of above, Zip file will be downloaded
  4. Now, Extract the Text file
  5. Select the complete text and Copy the data to MS Excel Worksheet
  6. Select the entire first column “A” in the worksheet
  7. Click on Data written in the header of MS Excel Worksheet
  8. Select option Text to columns a small window will pop up
  9. Select “Delimited” and click on next
  10. Now, select “Others” and Place “^” in the box and click on next
  11. Click on “Finish” and data will get converted to Excel format



Income Tax Act on Your Mobile Now Android Application For Income Tax Act – 1961 with Cost Inflation Index and other tools on Mobile now at following link:




Whatsapp Group at