Convert Income Tax JSON (ITR) Files to Excel Free — No Install

The Indian income tax e-filing portal (incometax.gov.in) exports data in JSON format — including prefilled ITR data, AIS (Annual Information Statement), and tax computation outputs. Converting these JSON files to Excel makes it far easier to review figures, spot discrepancies, and share data with a CA or tax consultant. This free browser converter handles the conversion locally on your device — no upload required for sensitive tax data.

Which Income Tax JSON Files Can Be Converted

The income tax portal and offline utilities generate several types of JSON files:

• Prefilled ITR JSON: The portal can prefill your ITR with data from Form 16, 26AS, AIS, and TIS. You can download this prefill JSON and convert it to Excel to review all income and deduction data before filing.
• AIS (Annual Information Statement) JSON: The AIS contains a detailed statement of all financial transactions reported to the income tax department. Converting the AIS JSON to Excel lets you scan for entries to accept or dispute.
• Error JSON: When uploading a return using the offline utility, validation errors are exported as JSON. Converting this to Excel shows all errors in a readable format so you can fix them systematically.
• Tax computation JSON: Some tools export computed tax figures as JSON for audit verification.

All of these follow the same conversion process: the JSON file contains an array of records (or a nested object that can be extracted), which maps to rows and columns in Excel.

Step-by-Step: Convert ITR JSON to Excel

1. Download the JSON file from the income tax portal. For AIS: Log in to incometax.gov.in > AIS > Download JSON. For prefilled ITR: Go to the relevant ITR form > Prefill > Download. Save the .json file to your computer.

2. Open the converter. Go to wildandfreetools.com/spreadsheet-tools/json-to-excel/.

3. Drop or paste the JSON. Drag the .json file from your desktop into the drop zone, or open the file in a text editor (Notepad, VS Code), select all, copy, and paste into the text area.

4. Download the .xlsx. Open it in Excel, LibreOffice, or Google Sheets. Each record in the JSON becomes a row, and each field becomes a column.

Note on nested structures: ITR JSON files from the portal can be deeply nested. The converter will flatten one and two levels of nesting to dot-notation columns. For deeply nested income tax data with multiple levels of detail, you may need to open the JSON in a text editor first and identify the specific array you want to convert (such as the list of TDS transactions or capital gains entries).

Sell Custom Apparel — We Handle Printing & Free Shipping

Why You Should Not Upload Income Tax JSON to Public Servers

ITR and AIS JSON files contain extremely sensitive data:

• Your PAN number
• Bank account details and balances reported to tax authorities
• All income sources and amounts
• TDS deducted by every employer, bank, and payer
• Property transaction details
• Stock and mutual fund transactions

Uploading this data to a free online converter — even a reputable-looking one — creates a risk of data exposure. Most free conversion tools upload your file to their servers for processing.

The WildandFree converter does not upload anything. The conversion runs entirely in your browser tab using JavaScript. Your JSON file is read from your local disk and processed locally — nothing is transmitted to any server. You can verify this by opening your browser's Network tab (F12 > Network) while doing the conversion and observing that no outbound requests are made after the initial page load.

Using Excel to Review AIS Data After Converting

Once you have the AIS JSON converted to Excel, the real work begins — reviewing and reconciling the data:

• Filter by transaction type: Use Excel's AutoFilter (Data > Filter) to show only salary, interest, dividend, or capital gains transactions.
• Sort by amount: Sort the value column descending to quickly identify your largest transactions.
• Cross-check against Form 16 / bank statements: Keep your AIS Excel open alongside your other financial records and highlight discrepancies.
• Share with your CA: Send the .xlsx file to your chartered accountant for review — a formatted spreadsheet is far easier to work with than raw JSON text.

For errors or disputes in the AIS, the portal requires you to submit feedback through the web interface — but having the data in Excel first makes it much easier to identify what needs to be disputed.

Frequently Asked Questions

Will this work with the JSON file from the income tax e-filing offline utility?

Yes, as long as the JSON file contains an array of records or a nested structure with a recognizable array. If the offline utility JSON is a complex nested object rather than an array, you may need to open it in a text editor and extract the specific section (like the TDS list or salary details) as a separate array before converting.

I downloaded the AIS JSON but it looks complex with many nested levels. What should I do?

Open the JSON file in a free JSON viewer (like jsonviewer.stack.hu or similar browser-based viewers) to understand the structure. Identify the specific section you want in Excel — for example, the array under the "annualInformationStatement" key or the "partInformation" section. Copy just that array and paste it into the converter.

Can I convert GSTR JSON files using the same tool?

Yes — the same converter works for both income tax JSON files and GST JSON files. The process is identical. For more detail on GST-specific JSON to Excel conversion, see our dedicated GSTR-1 JSON to Excel guide.