Convert your Form 26AS (Form 168) text file into a structured Excel workbook in seconds. Get deductor-wise summary, section-wise TDS breakup, monthly trend, and full transaction details, extracted automatically from the raw TXT file downloaded from the Income Tax portal. No login, no registration, no email delivery ,your file is processed entirely in your browser and never uploaded to any server.
Form 26AS & Form 168 to Excel Converter
Convert the original Income Tax Portal statement into a clean, structured Excel report instantly.
Upload your Form 26AS / Form 168 TXT file
Drag and drop the original TXT file downloaded from the Income Tax Portal
How do I get the TXT file?
- Log in to the Income Tax Portal.
- Download your Form 26AS or Form 168 in TXT format.
- Upload the original downloaded TXT file here.
- Review the dashboard and download the processed Excel.
—
PAN: — | AY: —
—
Top deductors by TDS
Net amount appearing in Part IMonthly TDS trend
Based on transaction dateSection / payment-code-wise TDS breakup
Reported code, new Act provision, old equivalent and nature of payment| Reported Code | Applicable Provision | Legacy Section | Nature of Income / Payment | Transactions | Amount Credited | Tax Deducted | TDS Deposited |
|---|
Deductor summary
Click the + sign to view transactions for a deductor| Sr. | Deductor | TAN | Amount Credited | Tax Deducted | TDS Deposited |
|---|
Transaction details
Corrections/reversals are retained as negative values| Deductor | TAN | Code / Section | Transaction Date | Status | Booking Date | Remarks | Amount | TDS | Deposited |
|---|
Note: Form 26AS Is Now Called Form 168
Under the Income-tax Act, 2025, Form 26AS has been renumbered Form 168, effective from Tax Year 2026-27 (income earned on or after 1 April 2026). If you’re working with an AY 2026-27 statement, you’re using the familiar Form 26AS layout — this tool applies exactly as before. From Tax Year 2026-27 onward, statements are issued as Form 168, with the same TXT format and structure, so this converter works for both.
How to Convert Form 26AS / Form 168 TXT to Excel
- Download your Annual Tax Statement in text format from the Income Tax e-filing portal or TRACES. Log in → e-File → Income Tax Returns → View Form 26AS/168 → download the text file for the relevant year.
- Unzip the file. It’s a password-protected ZIP — the password is your PAN Date of Birth in DDMMYYYY format,
01011990. Extract to get the plain .txt file. - Upload the .txt file using the button above, or drag and drop it.
- Review the summary — deductor count, gross amount credited, and total TDS appear instantly.
- Click “Download Excel” for the full structured workbook.
Can I Download Form 26AS Directly in Excel?
Yes, if you log in to TRACES directly (not through the e-filing portal or net banking redirect, which only offer PDF/HTML), an Excel option is available, but only if your Form 26AS/168 has fewer than roughly 1,500–2,000 transactions. Above that limit, TRACES forces you to download in TXT format only, regardless of which option you select.
Even where the portal’s Excel option is available, it isn’t a clean dataset, it replicates the PDF’s print layout in a single sheet, with merged cells and inconsistent columns from one section to the next, so Excel’s own Sort, Filter, and PivotTable tools won’t work on it properly. If you’ve hit the transaction limit, or want a workbook you can actually filter and analyze, upload your TXT file below and this tool will convert it into a properly structured Excel workbook in seconds.
What You Get in the Excel Workbook
- Top deductors by TDS — see which deductors account for the bulk of your credit
- Monthly TDS trend — spot seasonality or gaps across the year
- Section-wise TDS breakup — amount credited, tax deducted, and tax deposited by section/payment code
- Deductor summary — expandable rows showing every transaction per deductor, with TAN
- Full transaction details — transaction date, booking date, status, remarks, and amounts, with reversals retained as negative values for accurate netting
Why This Tool Is Still Needed — Even Though the Portal Now Offers “Excel” Too
The Income Tax portal has started offering a native Excel download for Form 168 statements. In practice, it isn’t a usable dataset — it’s a print layout dropped into a spreadsheet: one long sheet replicating every PDF page (including page-break markers, the full section/payment-code glossary, and notes) with merged cells and inconsistent columns from one section to the next. Excel’s own Sort, Filter, and PivotTable tools won’t work on it without manually rebuilding the structure first. This tool gives you what that file doesn’t: a clean, consistently structured workbook you can filter, sort, and analyze immediately.
A Note on TXT vs PDF vs the Portal’s Excel
Form 26AS/168 can be downloaded as PDF, TXT, or (for Form 168) a native Excel file. PDF and the portal’s Excel are fine for a quick look, but neither can be properly sorted, filtered, or reconciled — once your transaction count crosses roughly 2,000 rows, the portal restricts you to TXT only anyway. This tool works with the TXT file specifically, converting it into a genuinely structured, analysis-ready Excel workbook.
Frequently Asked Questions – Convert 26AS or Form 168 Text file to Excel
Q: What is the password for the Form 26AS/168 text file?
Whether you download Form 26AS/168 as a TXT file, PDF, or Excel, the file is password-protected using the same format: your PAN Date of Birth in DDMMYYYY format — for example, 01011990.
Q: Is Form 168 the same as Form 26AS?
Yes — Form 168 is the renumbered version of Form 26AS under the Income-tax Act, 2025, applicable from Tax Year 2026-27. The layout, TXT format, and password remain the same.
Q: Can Form 26AS/168 be downloaded directly in Excel?
The portal now offers an Excel option for Form 168, but it replicates the PDF’s print layout rather than providing structured, filterable data. This tool converts the TXT file into a properly structured workbook instead.
Q: How do I find the TDS certificate number in Form 26AS?
The TDS certificate number isn’t listed in Form 26AS/168 itself — it appears on the Form 16/16A issued by your deductor. Form 26AS/168 shows the deductor’s TAN and the TDS amount, which you can cross-check against your certificate.
Q: Can I convert multiple files at once?
Currently this tool processes one file at a time, ensuring accurate, verifiable output per year.
Q: Is my data uploaded anywhere when I use this tool?
No. The entire conversion happens in your browser — your data never leaves your device.
A Note on Convert 26AS or Form 168 Text to Excel File Tool
This tool has been built in-house with the help of AI, and while we’ve tested it carefully, it may occasionally make mistakes. If you run into any issue while using it, please Contact Us we’ll do our best to look into it and update the tool.
Contact Us
