How To Download Xml File To Excel

Once you have downloaded the xml file you need to import the file in the appropriate itr excel utility form and the.

How to download xml file to excel. Click run conversion button. Browse and select the downloaded pre fill xml file and click on open button. Open the file in excel. Change the file type to csv. When the file is converted download excel file.

Open a new workbook. That saves quite a lot of time. To import an xml file open a blank workbook on the developer tab in the xml group click import and select the xml file. In this example we will use a simple xml file containing mock contact information with names emails cities and countries. Open the itr java utility and click on open button from the menu bar.

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. If you don t see the developer tab see show the developer tab. Select get data found in the get transform data section. Save your file as data set xml and press enter. Download the xml file.

You will get the options dialogue window as above example. Click developer import. Click on from other source then click on from xml data import now select the xml file. Choose the dialog box import. On the developer tab in the xml group click export.

First convert xml to excel format using our free xml to excel online converter. How to convert xml file to excel open the tool developer. Click on the data tab on the ribbon bar. Click on the download xml button to download the pre filled xml by default it will be in downloads folder of the system. In the import xml dialog box locate and select the xml data file xml you want to import and click import.