Creating an Excel template

When creating Excel templates, use Microsoft Excel in Windows operating system.

  1. Open a blank workbook from Microsoft Excel.

    Verify that the Developer menu tab is enabled. If the tab is disabled,

  2. In the XML section, click Source.
  3. In the XML Source panel, click XML Maps.
  4. In the XML Maps window, click Add.
  5. Select the file you want to import and click Open.
  6. Select the XML file you imported and click OK. The XML source panel shows the XML file.
  7. Select the desired cell or location you want to map.
  8. In the XML Source panel, double-click <value>. Or you can also right-click <value> and select Map Element.
    From the Header Options, select where you want the XML headers to be displayed. You can place the XML headers at the top or at the left of the column.
  9. Save the file in .xlsx format.