Excel Utility

@ Bikash Ghosh

You have to extract the excel utility from the zip file first.

For ITR-2,3,4, the Utility would be a folder containing one xlsm file + 2 folders.

And you will need to use Windows 10 or Windows 11 , 64bit, with Minimum Office 2019 or later or 365 and a machine with at least 8 GB RAM and fast Intel or AMD processor

Thank you Mr. Ranjan for giving the direction promptly. I have followed the same and now I am getting an alart (pop-up) message while importing JSON file in the Excel Utility.

Heading: "Microsoft Visual Basic for Applications"

Message: "Compile error in hidden module: ImportJson."

Could you please advise me in fixing this issue to proceed further?

@ Bikash Ghosh 

You must enable MACROs in your excel program before using the excel utility of the ITR.

MACRO is enabled and still I am getting the same alert message.

@   Bikash Ghosh

Try updating Java in your machine. Latest one is version 8.61

@ Bikash Ghosh

Your problem is solved ?

Microsoft Office 365 has been installed and import of JSON file is done in Excel Utility. But still few glitches are there after importing JSON file. Thank you for doing follow-up.

@ Bikash Ghosh 

For solving the other glitches, refer to my various other posts in the forum.

Surely, I shall follow the things suggested by you.

Play against CBDT chief

The error relates to the same Form 10-IA acknowledgement number being entered for both the taxpayer’s Section 80U claim and a dependent’s claim. First verify that the return is claiming the correct deduction: Section 80U is for a resident individual with a disability, while a deduction for a dependent with a disability is generally under Section 80DD. Do not remove a valid claim merely to bypass validation; correct the section and Form 10-IA details against the actual claim.

The Excel utility may not be available for the relevant assessment year or may require a compatible Microsoft Excel desktop version; availability and instructions can change, so download the utility for the correct assessment year from the Income Tax e-Filing portal and check its accompanying user guide. If it will not open, confirm that the downloaded file is extracted, enable editing/content if prompted, and try a supported desktop Excel installation rather than a browser or mobile app. Since the offline utility also failed, the precise error and assessment year would help identify the issue.

Correct handling of disability deductions is part of return preparation and validation. Manual checking across forms and utilities is difficult; automation reduces repetitive work while professional judgment remains in control. At Jir AI, our 2,000+ AI agents and 650+ integrations streamline GST, ITR, TDS, TCS and other compliance workflows, helping reduce manual workload by up to 70%. For details on streamlining your compliance workflow, connect with us on WhatsApp: https://wa.me/message/3HVOZ7HIY4ESC1