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 online

Aashok Kumar Sharma online

(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

Join the CA Students WhatsApp Community for ICAI Updates, Trending Courses & Notes!

Similar Resolved Queries

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

Somnath Maiti

Shantaveeresh Manur

S D Kannan

adarsh chaturvedi

Dinesh kumar

Subscribe Now

Xml to macro enabled excel

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

Senior Executive

Manager- Finance and Compliance

GST CONSULTANT

GST CONSULTANCY

Accountant

CA Final

Article Assistant

Associate CA