Convert AIS JSON to Excel

Online Converter: turn your income tax Annual Information Statement (AIS) JSON into a clean Excel workbook

Your AIS file

Password (optional)

Used once to unlock the file for this conversion. It is not saved to your account.

Private by default · files deleted in 24hCapterra Best Ease of Use 2025

Start Conversion

You may help others to find this website - Share your experience!

Convert AIS JSON to Excel from your AI agent

Ask your agent: “Convert the AIS file ais.json to Excel with Conversion Tools.”
It runs this same converter, so you get the same result
Right from your workflow, no browser needed

Connect it to:

Set up your agent

Need a different result? Build your own converter with AI

Describe the result you want in plain words, no coding
Other columns, a different layout, or a format we don't list
Test it on your own file before you use it
Free to build and test, then runs on your plan's limits

Try AI Converter Studio

More Converters

JSON Converters Excel Converters Office Converters

Turn the Annual Information Statement (AIS) you download from the income tax e-filing portal into a clean, readable Excel workbook. Upload the AIS JSON, enter your AIS password, and download a spreadsheet with every entry of your statement: TDS and TCS, interest and dividends, sales of shares and mutual funds, taxes paid and more, ready to filter, sort and total.

How to convert AIS JSON to Excel

Log in to the income tax e-filing portal and open Annual Information Statement (AIS) under Services.
On the AIS tile, download the JSON (the file made for the AIS Utility).
Upload the .json file above and enter your AIS password: your PAN followed by your date of birth as DDMMYYYY, for example ABCDE1234F01011990.
Click Run Conversion and download the Excel workbook.

You do not need to install the AIS Utility, and there is nothing to set up.

Why convert your AIS to Excel?

The AIS lists what banks, employers, companies, mutual funds and other reporting entities told the income tax department about you for the year. Before you file your return it pays to check it line by line, and a spreadsheet makes that easy:

Reconcile before filing - match salary, interest and dividends against your own records and your ITR.
Check every deductor - see the TDS from each employer, bank and payer, quarter by quarter.
Capital gains - list every sale of shares and mutual fund units with its sale value and cost.
Share with your CA - send a workbook anyone can open, instead of a file only the AIS Utility reads.

Example: TDS on salary

The salary your employer reported in Part B1 becomes rows like these on the B1 Salary sheet (sample values):

Information Source	Information Code	Quarter	Date of Payment/Credit	Amount Paid/Credited	TDS Deducted	Status
SAMPLE EMPLOYER PVT LTD (ABCD12345E)	TDS-192	Q1(Apr-Jun)	30/06/2025	300,000.00	30,000.00	Active
SAMPLE EMPLOYER PVT LTD (ABCD12345E)	TDS-192	Q2(Jul-Sep)	30/09/2025	300,000.00	30,000.00	Active

Related converters

Working with GST returns too? Our GSTR JSON to Excel converter gives you one sheet per section of the return. For a CSV file per table instead of a workbook, use AIS JSON to CSV.

Frequently Asked Questions

Which AIS file do I need?

The AIS JSON from the income tax e-filing portal: log in, open Annual Information Statement (AIS) under Services, and download the JSON from the AIS tile (the file made for the AIS Utility). Upload that .json file as it is. You do not need the AIS Utility.

Do I need a password?

Yes, for the file you download from the portal: it is locked with the same password the AIS Utility asks for. That is your PAN followed by your date of birth as DDMMYYYY, with no spaces, for example ABCDE1234F01011990. Companies, firms and other non-individuals use the date of incorporation or formation instead. Enter it in the Password option before you run the conversion. It is used only to unlock the file for this conversion and is not saved to your account. If the file does not open, check the date of birth as it appears on your PAN, and download the AIS JSON again if the file was changed or cut short.

What does the Excel file look like?

The workbook opens with a Summary (PAN, assessment year, financial year and a record count per sheet), General Information (Part A) and an Information Summary with one row per information source: category, code, source, count and amount. Then comes one sheet per part and information category, for example B1 Salary, B1 Interest from deposit, B2 Interest from savings bank or B3 Payment of taxes, with one row per transaction and the source that reported it. Amounts are numbers, so you can total and filter them straight away, while codes, account numbers and dates stay exactly as written.

Which parts of the AIS are included?

All of Part B as it is in your file: TDS and TCS information (Part B1), specified financial transactions or SFT (Part B2), payment of taxes (Part B3), demand and refund (Part B4) and other information. Every column is kept, and transactions marked inactive stay in, with their status, so nothing is left out.

Can I convert several AIS files at once?

Yes. Put the .json files into one .zip and upload it - each file inside is converted to its own workbook. All files in one .zip are opened with the one password you enter, so this works for one person's AIS for several years. Converting an archive of multiple files needs a free account, so sign up and confirm your email first.

Can I convert the AIS PDF instead?

This converter reads the AIS JSON. For the AIS PDF, use our AI PDF to Excel converter, which accepts the PDF password.

Are my tax files kept private?

Yes. All files uploaded to our service are encrypted and automatically deleted after 24 hours. Your tax data is never shared.

Sign in to work securely with your files. Sign in or Sign up for full access.
Conversion time varies by file size; thank you for your patience.
Limits apply to maximum conversions and file size. See available plans on the Pricing page.
Unregistered users: up to 5 conversions/day, up to 50 conversions/month, and 10 MB per file. Sign up to extend your limits.
Need help converting files? Contact us.