26 AS in Excel
This query is : Resolved
07 June 2023
Dear sir,
Can we Download 26-AS In Excel ?
If yes then who to download ?
Can we Download 26-AS In Excel ?
If yes then who to download ?
07 June 2023
Login to TRACES & download form 26AS in text format.
Taxpayer needs to open text file by giving password as “ Date of Birth of Deductee” in DDMMYYYY format.
Zip file will be downloaded.
Extract the Text file.
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.
Taxpayer needs to open text file by giving password as “ Date of Birth of Deductee” in DDMMYYYY format.
Zip file will be downloaded.
Extract the Text file.
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.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Treatment of Pension ?annuity returns on PMVY
- ITR filing- non tax audit cases- Asstt.Year 2026-2027
- Soyabean hsn code and gst rate
- TAN for Partnership
- NON- SUBMISSION OF LLP FORM 3
- Long Term Service award taxability in hands of company
- What is provisional receipt number for generation of form 16A
- Last year TDS Claim
- CA IPCC Registeration in 2012, Is my registration Active or Expired
- LTCG for Assmt year 26-27
- Form 27Q Correction statement taking too long to update on IT Portal
- ITR selection for salaries and capital gain less than L
- Showing Gift from relative in ITR for this year
- Gst invoice numbering and delivery challan numbering
- Standard Deduction claim for EPFO Pension and ICICI Prudential Life Annuity
- Small dealers gst returns filing
- Sales amount in Gstr1
- CG after sale of flat
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
