Xml to macro enabled excel

This query is : Resolved

Querist : Anonymous

Querist : Anonymous (Querist)

21 February 2014 can anyone help me i submitted itr 1 of a.y 13-14, and some notification is received from IT department i.e error in return filed, the macro enabled return is deleted by me istakenly, i h've return in xml format how can i convert into macro enabled excel format please help me

thanks

Nikhil Kaushik

Nikhil Kaushik (Expert)
Follow

21 February 2014 instead of wasting time on wondering how to do this, you can download the pdf version of the return you filed from the tax website and refill the excel sheet using the details provided in the pdf file

Message likes : 1 times

Querist : Anonymous

Querist : Anonymous (Querist)

22 February 2014 thanks nikhil, but i dont won't to refill the excel sheet again this is not only the one case....
And from excel sheet i import the data in new sheet & fill the missing things...
if u hve a xml converter please posted here thanku so much

Aashok Kumar Sharma

Aashok Kumar Sharma (Expert)
Follow

03 August 2025 Converting XML of ITR back into the exact macro-enabled Excel form issued by the Income Tax Department isn’t straightforward because the Excel ITR forms are specially designed with macros and validations, and there’s no official tool from IT Dept that converts XML to macro-enabled Excel form directly.
But here are some practical approaches:

1. Use the Official Income Tax E-Filing Website
The IT Department’s e-filing portal allows you to upload your XML file and then you can download the filled Excel (or PDF) form again.
Go to: https://www.incometax.gov.in/iec/foportal/
Login → e-File → Upload XML of ITR → After successful upload, you can download the filled form (Excel or PDF).
This method is usually the easiest to get back the data-filled Excel (macro-enabled) form.
2. Manual XML Import (If You Have Excel Skills)
You can open XML in Excel via Data → From XML (depending on Excel version).
But this imports raw data and you will lose all the macros, formatting, and validation present in the original ITR form.
You can create a new sheet, import XML there, and then copy the values to the official macro-enabled Excel template you download fresh from the Income Tax site.
This is somewhat technical and tedious for multiple returns.
3. Backup Habit for the Future
Always keep backup of macro-enabled Excel form before submission.
Save XML separately as you did.
When the original form is lost, use the above method (portal upload and download) to get it back.

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now