How To Download Xml File To Excel

Steps to use xml to excel converter.

How to download xml file to excel. 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. You will get the options dialogue window as above example. Once you have downloaded the xml file you need to import the file in the appropriate itr excel utility form and the. Select get data found in the get transform data section. Choose the dialog box import.

Download the xml file. Click run conversion button. Download xml to excel converter for free. To import an xml file open a blank workbook on the developer tab in the xml group click import and select the xml file. You can download xml file below.

Browse and select the downloaded pre fill xml file and click on open button. Open a new workbook. Let s take another example this time you have local xml not in form of web link. Save your file as data set xml and press enter. We can quickly create a new query that imports the xml file into excel.

When the file is converted download excel file. Open the itr java utility and click on open button from the menu bar. Go to the data tab in the ribbon. Click on the download xml button to download the pre filled xml by default it will be in downloads folder of the system. On the developer tab in the xml group click export.

In the import xml dialog box locate and select the xml data file xml you want to import and click import. First convert xml to excel format using our free xml to excel online converter. Click on the data tab on the ribbon bar. Click on from other source then click on from xml data import now select the xml file. Click developer import.