Import Xml Into Excel Zip File And

You can export the customizations into an XML (Extensible Markup Language) file and that XML (Extensible Markup Language) file can be imported to an Excel program running in another computer.

Note that the default name for the Quick Access Toolbar customizations export file is Excel Customizations.exportedUI, which you may change if required.

Note that the custom Ribbon Tab and Group are not available on right-side list.

Select the export file and then click Open button, as shown in below image.

If required, you can revert to the previous state of Excel Ribbon and Quick Access Toolbar (state before the import) using the backup file.

Getty Images It is your responsibility to check all the prefilled details before submitting the form to the I-T department.

When you file income tax return (ITR) using the Excel utility, instead of filling the entire Excel form manually, you can import some of your personal and tax details into the ITR Excel form automatically using the XML file, which can be downloaded from the tax e-filing portal.

However, remember only some of the details required to be filled in your ITR will get pre-filled as the income tax departments software will copy these details from your previous ITR and other sources it has access to such as your Form 26AS.

Further, to download the prefilled XML to prefill the personal and tax details in the ITR excel utility, follow steps from 5 to 12.

Import Xml Into Excel Zip File And

From the download folder, right click on the downloaded zip file and then click on Extract All option.

Double click on the Excel File to open the ITR Excel utility.

Keep the ITR Excel ready before you download and import the personal and tax details from prefilled XML file to the ITR Excel form.

You will have to select the Assessment Year for which you are filing the income tax return.

From the second dropdown, choose the ITR Form which you want to file.

You are required to do so irrespective of whether you have any refund or not.

After that click on the Download XML button to download the pre-filled XML file (The file will get automatically downloaded in Downloads folder of your system).

However, remember that it is your responsibility to check all the prefilled details before submitting and correct them if needed.

For reprint rights: Times Syndication Service To see your saved stories, click on link hightlighted in bold Find this comment offensive Choose your reason below and click on the Report button.

This will alert our moderators to take action Name Reason for reporting: Foul language Slanderous Inciting hatred against a certain community Others Your Reason has been Reported to the admin.

X To post this comment you must Log InConnect with: The Economic Times or Fill in your details: Will be displayed Will not be displayed Will be displayed Share this Comment: Post to Twitter.

Import Xml Into Excel For Mac