.. _bulk-load-template-export:

Bulk load template export
--------------------------


Overview 
..........

You can use the MS Excel format spreadsheet bulk load template of a model to
easily create a template of a sheet from the user interface. See :ref:`bulk-load-sheet-layout`. 

The Automate multi-domain core supports the ability to generate a MS Excel
format spreadsheet bulk load template for any of the resources in the system
directly from the user interface.

You can populate the template sheet with data and then load it using the *Bulk Load* tool.

Excel bulk load operations using spreadsheets support multiple (tabbed) worksheets
that are loaded in tab sequence. Defined configuration templates on the system
can be referenced in the sheets and applied during the bulk load operation. 

The field specific help of the product can be used to assist the user with
populating the bulk loaders with the correct data. See :ref:`bulk-load-sheet-layout`.


.. _carry-out-a-bulk-load-template-export:

Perform bulk load template export
.........................................

The export of a bulk load template of a model is available on 
the list view.

#. Choose the hierarchy where the model is available.
#. Choose the required form and choose the export option **Bulk Load Template**.

A MS Excel sheet is created that contains the bulk load template for the selected model.
The sheet is available in the download directory of the browser application.
 
Use the bulk load template sheet to enter data. 

Use the Bulk Load system tool to upload the bulk load template sheet.
