========================
Form Excel Import
========================

:url:`/meg-admin/megforms/auditform/import_audit_xls/`

:task:`26960`

`Excel Template <https://docs.google.com/spreadsheets/d/1ke5_F7db7tyQMjpvfNYloq64gnVBsC_RUVxABG_sZZ8/edit#gid=1653759160>`_.

When importing a form through excel, a first sheet in the excel file can be configured with the following fields

Sheet should be named ``Config`` and should be the first one in the excel file

form layout
    either ``Accordion`` or ``Default``

next button functionality
    ``True`` or ``False``

Enable QIP
    ``True`` or ``False``

Merge submit preview
    ``True`` or ``False``

If any of those is not specified, it will be set to it's default value in the system.

If such a sheet is not there as the first sheet, values of those attributes will be
set as their default values.