# Excel templates

You can quickly add or update records in the system by importing an Excel file. Simply download the provided template, fill in your data, and upload it through the Import tool 

{% file src="/files/ctnrDUrPl2EMwRm0QlKx" %}

{% file src="/files/lNlQUAqn0yZOVnickFRl" %}

Once you have completed the Excel you can simply import the data by following the steps listed in this article: [Importer](/the-admin-panel/settings/importer.md)

#### Multi-Language Events Templates

{% file src="/files/Hly0lseAmjenqoplozDv" %}

### External QR-codes

If you are wanting to replace your the auto-generated user QR code with an External QR version? Then you can follow the steps below:

1. Add another column to the user Excel sheets and name it **External QR**
2. Fill this column with the URL/barcode of the personal QR-codes of the users.
3. Import the data making sure to map the column External QR to the Let's Get Digital value **External QR**
4. **Make sure you test that the QR code works by logging into the app, shake your phone to open the QR scanner scan a single External QR code and you should see that you are connected to the user.**

{% hint style="warning" %}
We do not support all custom QR codes, therefore it is important to test already in advance whether the LGD QR-codes can be overwritten. 
{% endhint %}

## Additional columns

You can include additional column to the Excel sheet. This is useful if you need to include information that is not a standard value in the system, such as country or dietary preferences. To do this, first create a [additional data field,](/the-admin-panel/settings/additional-data-fields.md) then add a new column in the Excel template with the relevant information. Follow these steps to proceed:

After you have added the additional data field, you can do the import with the additional datafield column in the Excel sheet and enter the corresponding information for each user. Then, import the data and map the column to the correct value to ensure a successful import.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://knowledge-base.letsgetdigital.com/the-admin-panel/settings/importer/excel-import.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.