Convert Form 26AS to Excel: Check This First

Before converting anything, open the TRACES download screen and look at the format list. Excel is on it.

The official e-tutorial says so in one line: Form 26AS "is available for download in three formats: a) PDF b) Text c) Excel". Most people asking how to convert the text file into Excel are solving a problem they do not have, because the file they wanted was one option further down the same menu.

Do you actually need to convert anything?

Form 26AS downloads as an Excel file already, and the text route exists for one specific case: a statement too large to serve any other way.

The TRACES tutorial puts a number on it. If a file holds "transaction entries more than 1000", the system warns you and the statement has to be requested from TRACES as a text file, which then needs converting. Below that, the Excel download is right there.

That threshold matters because a lot of what ranks for this question is out of date. Published guides still describe Form 26AS as available in two formats, and still put the cutoff at 2,000 transactions. Both figures come from an older version of the same government deck, and both are still being copied. One converter's own step-by-step tells readers to choose between PDF, HTML and text, leaving Excel off the list entirely, which is convenient for a page that exists to sell you a conversion.

So the first step is not a step. It is a check. Count your entries, look at the format menu, and if Excel is offered, take it.

What is actually inside the text file?

The file is not a table. It is two different kinds of row stacked together, separated by the caret character.

That structure is why the conversion trips people up, and no page we read explains it.

The first few lines carry header information: file creation date, your PAN, its status, the financial year, the assessment year, your name and your address. Below that, the body alternates between two shapes.

A deductor summary row appears once for each employer or bank, and carries their name and TAN. Then, underneath it, a run of transaction rows carrying the section, transaction date, booking status, date of booking, amount paid or credited, tax deducted and tax deposited.

The transaction rows do not repeat the deductor's name. They do not carry it at all.

Convert it here, without uploading it

This runs entirely in your browser. Your file is never sent anywhere, and there is no server involved at any point. If you want to check that rather than take our word for it, turn off your internet connection and use it anyway. It will still work.

Your Form 26AS text file

This needs the .txt file, not the PDF. On the TRACES download screen, check the format list first: if Excel is offered, take that and skip this entirely. If you were given a ZIP, extract it and pick the .txt inside.

Why is splitting on the caret not enough?

Text to Columns will split the file correctly and still leave you with something you cannot use.

The mechanical part is easy enough. Open the text file, select everything, paste it into a blank worksheet, then Data, then Text to Columns, then Delimited, then tick Other and type a caret. Excel divides the rows into columns.

Every published guide stops there. The official deck's final slide is captioned only as a sample of the statement in Excel format, and the articles copying it end at "click Finish".

What you are left with is a sheet where one row says Acme Industries Private Limited and MUMA12345B, and the six rows beneath it say things like 192, 30-06-2025, F, 15-07-2025, 250000, 12500, 12500, with no indication of who paid any of it.

Sort that sheet and the employers detach from their transactions. Pivot it and there is nothing to pivot by. Try to reconcile it against your Form 16 and you cannot match a single entry to an employer. Which is the problem, because reconciling against Form 16 is the main reason anyone wants this in a spreadsheet.

What is the step that makes it usable?

Fill the deductor name and TAN down into the blank rows beneath each summary row. That is the whole fix, and it takes one formula.

Say the split puts the deductor name in column B and the transaction rows leave that column empty. In a new column, on the first data row, put a formula that carries the value down: if column B has something in it, use that, otherwise use whatever the cell above resolved to. Copy it down the sheet, then paste the result back as values. Do the same for the TAN.

Every transaction row now carries its employer. The sheet sorts, pivots and filters, and a SUMIF by deductor finally returns something meaningful.

The open-source parsers that handle this file do exactly the same thing internally. They hold the current deductor's name in a variable, watch for the next summary row, and attach the held value to every transaction line in between. The formula above is that logic, done in a spreadsheet.

Are free online Form 26AS converters safe?

Treat them as unsafe unless you can verify otherwise, and be aware that the free ones are the ones taking your data while the paid ones generally are not.

Consider what is in the file. Your PAN. Your name and address. Every employer and bank that deducted tax from you, by TAN. What each of them paid you. What each of them deducted. It is one of the most complete financial pictures of you that exists in a single document.

On 26 August 2026 we read the published code behind one free converter that advertises itself, in its own page description, as a "Free, secure, and browser-based tool". Browser-based would mean the file never leaves your machine. Its code does something else: it reads your file, takes the base64 payload, and posts it to the operator's own server for processing. The parsing does not happen in your browser at all, which you can tell because the caret delimiter the file uses appears nowhere in the page's code. There is a second transmission too. To get the download, you supply a name, company, email and phone number, and the file is sent again alongside those details, tagged with where the lead came from.

We are naming the behaviour rather than the vendor here, because the point is the pattern and not one company. The pattern is easy to check yourself: if a converter is genuinely browser-based, it works with your network disconnected. If it does not, it was never browser-based.

Another operator uploads the file, processes it server-side and emails the finished spreadsheet to you. Its entire privacy claim is that the output is "securely delivered". A third publishes a Security heading for a converter whose page has no file upload on it at all.

The inversion is the useful part. The two options that cost money or require a download, the paid Excel utility and the free macro workbook, both run on your own computer and transmit nothing. They are private by architecture. Neither of them advertises this, because neither seems to have noticed it is the strongest thing about them.

The converter above this section is built to that standard. It reads your file in your browser, does the forward-fill, and hands back a CSV. It makes no network calls at all, which you can verify by disconnecting your internet and using it anyway. We have no tool to sell and no leads to capture, which is the only reason we can afford to build it that way.

What this post deliberately does not cover

It does not walk through downloading Form 26AS or explain what the form contains, which our post on the Form 26AS password and what the form shows covers in full.

It does not cover the Annual Information Statement, a separate and broader statement with its own download and its own password rule. That is in our AIS post.

It does not recommend or review any specific converter, paid or free.

It does not cover reconciling your Form 26AS against your Form 16 or your return, which is where a chartered accountant earns their fee. Getting the data into a spreadsheet is a formatting job. Deciding what a mismatch means is not, and our post on how TDS works explains why mismatches happen in the first place.

A tax statement that does not agree with your records is a conversation for a chartered accountant, not a spreadsheet problem.

Frequently asked questions

Do I even need to convert Form 26AS to Excel?

Probably not. The TRACES e-tutorial states that Form 26AS is available for download in three formats, PDF, text and Excel, so the Excel file is usually a direct download and no conversion is involved. The text route exists for large statements: the same document says that if a file holds more than 1,000 transaction entries, the system warns you and the statement has to be requested from TRACES as a text file. Below that, download the Excel version and skip the whole exercise. A lot of published guidance still describes only two formats and puts the threshold at 2,000, which reflects an older version of the same tutorial.

How do I convert the Form 26AS text file to Excel?

Open the text file, select all of it and paste it into a blank worksheet, then use Data followed by Text to Columns, choose Delimited, tick Other, and enter the caret character. Excel then splits the rows into columns. That is where every published guide stops, and it is not where the job ends. The result is not yet a usable table, because the deductor name and TAN sit on separate summary rows from the transactions beneath them, so the transaction rows arrive with no employer attached.

Why does my converted Form 26AS look wrong in Excel?

Because the file is not a flat table. It interleaves two different kinds of row. A deductor's name and TAN appear once on a summary row, and the transaction rows underneath carry the section, dates, amount paid and tax deducted but not the employer. After splitting on the caret you get a ragged sheet where a transaction cannot tell you who paid it, which is why sorting, pivoting and matching against Form 16 all fail. Filling the deductor name and TAN down into the blank rows is the step that fixes it.

Is it safe to use a free online Form 26AS converter?

Treat it as unsafe unless you can verify otherwise. A Form 26AS contains your PAN, your address, your employers' TANs, what they paid you and what tax they deducted. On 26 August 2026 we read the published code behind one free converter that describes itself as browser-based: it reads your file, base64-encodes it and posts it to the operator's own server, and it posts it a second time bundled with the name, company, email and phone it asks for before the download. The safest route is the one that never transmits anything, which means converting it yourself in Excel or using a utility that runs on your own machine.

What is the password for the Form 26AS text file?

Your date of birth in DDMMYYYY format, as recorded on your PAN, with no slashes. The same password opens the PDF, the text file and the Excel file. The widely repeated rule of PAN followed by date of birth belongs to a different row of the official password table, the one for e-mailed intimations, which is why it keeps failing on Form 26AS.

Sources

The official tutorial was read directly from the TRACES server on 26 August 2026, and the converter behaviour described above was read from the operator's own published code on the same day.

• TRACES taxpayer e-tutorials, and within them the tutorial titled Procedure of Converting Form 26AS/Annual Tax Statement Text File to Excel File, for the three download formats, the 1,000-entry threshold, the caret delimiter and the Text to Columns steps
• Income Tax Department e-filing portal, the route through which Form 26AS is reached before redirection to TRACES

The file structure described here, the deductor summary rows and the transaction rows beneath them, was confirmed against an open-source parser that handles the format, whose logic holds the current deductor in a variable and attaches it to each transaction line.

This is general educational information about a file format and a spreadsheet operation, not tax advice.