In order to test a layout, you have to upload another source file. When a layout is tested, it parses the uploaded file as per the structure defined in the layout and generates the output and error files.
Follow the below steps to test the Excel layout:
- Click the Test Layout
button from the toolbar. By default, this displays the defined excel layout which are parsed successfully in XML View tab.
- Click
Test button and browse the file which you want to upload. Ensure that the uploaded file extension is .xls/.xlsx. - This will test and display the uploaded file according to the defined layout.
- You can view the the error records by clicking Error View tab.
You can also download the XML file by clicking the Download XML 
button.
You may be interested in...