Convert your Form 26AS text file to Excel format in seconds
Drag & drop your Form 26AS file here
or click to browse
Only .txt files (max 10MB)
Your data is processed securely.
Files processed in your browser.
Quick and efficient processing.
Form 26AS is a comprehensive tax statement that provides details of tax deducted/collected at source, tax payments, and other financial transactions linked to your PAN. Learn what it contains and how to download it.
Form 26AS is a consolidated tax statement that shows details of TDS, TCS, advance tax, self-assessment tax, refunds, and high-value transactions linked to your PAN.
It includes TDS/TCS details, tax payments, refunds, high-value transactions, details of specified financial transactions, and pending/completed tax proceedings.
Visit the official Income Tax e-filing portal website (incometax.gov.in) and log in with your PAN and password.
After login, go to the e-File menu and select "Income Tax Returns", then click on "View Form 26AS".
Click on "View Tax Credit (Form 26AS)" option from the menu.
Select the appropriate Assessment Year from the dropdown and choose your preferred View Type (PDF, HTML, or Text format).
Enter the verification code (captcha) that appears on screen and click on the "View/Download" button.
If you download in PDF or Text format, you'll need to enter your PAN and Date of Birth (in DDMMYYYY format) as the password to open the document.
For Form 26AS files with 2000+ transactions, you might only be able to download in text format. Here's how to convert it to Excel:
Open the downloaded text file using the password, which is your Date of Birth in DDMMYYYY format.
If the file is downloaded as a ZIP, extract it to get the text file.
Select all the text content (Ctrl+A) and copy it (Ctrl+C). Open Microsoft Excel and paste the data (Ctrl+V) into a worksheet.
Select the entire first column (A) in the worksheet, then click on "Data" in the Excel menu and select "Text to Columns".
In the wizard that appears, select "Delimited" and click "Next". Then select "Others" and enter the caret symbol (^) in the box.
Click "Next" and then "Finish". The data will be properly formatted in columns, making it easy to analyze and work with in Excel.
Note: Steps for conversion may vary slightly depending on your Excel version and operating system.
Manually converting Form 26AS PDF to Excel is extremely time-consuming, requiring careful data extraction and formatting page by page.
Manual data entry increases the risk of errors, which can lead to incorrect tax calculations and financial decision-making.
Form 26AS contains complex tables and sections that are difficult to recreate accurately in Excel without specialized tools.
Important details or footnotes might be missed during manual conversion, potentially leading to incomplete tax analysis.
Skip the tedious manual conversion. Upload your file and let our intelligent system transform your Form 26AS data into actionable insights.
Just upload your Form 26AS text file – no need to worry about complex extraction or conversion steps. Our system handles everything.
Our advanced algorithms instantly parse the data, recognizing patterns and categorizing entries automatically without any manual effort.
Receive both the raw converted data and specially formatted sheets with categorized entries for deeper analysis.
Download your processed Form 26AS data as a clean Excel file with multiple sheets, ready for analysis and reporting.