After you have finished editing the Excel Template for Import to your satisfaction, you are ready to save the data as XML. This is required in order to be able to import the data into a CbC report.
To save the Excel data as XML, do the following:
1.Click File | Save As.
3.In the Save As dialog that appears, browse for a folder in which to save the file.
4.In the dialog's Save as Type field, select XML Data.
5.Enter the name of the XML file.
Note down the name and location of the XML file. This will be the file you select when you import Excel data into the report.