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 https://tdscpc.gov.in
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
Pingback: How to Check 26AS ( Income Tax TDS ) Online - Tax Heal