# Import excel data in reconciliation template

**URL:** <https://community.silverfin.com/t/import-excel-data-in-reconciliation-template/1556>\
**Category:** Templates\
**Created:** [August 29, 2019, 11:10am UTC](https://community.silverfin.com/t/import-excel-data-in-reconciliation-template/1556 "2019-08-29T11:10:12Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![sven](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/sven/32/1495_2.png) [@sven](https://community.silverfin.com/u/sven)\
**Post date:** [August 29, 2019, 3:13pm UTC](https://community.silverfin.com/t/import-excel-data-in-reconciliation-template/1556/2 "2019-08-29T15:13:06Z")

</div>

Hi @Ugis,

You’ll just have to use a reconciliation template and create a custom collection in that with a fori-loop.

Here you’ll find a case, although a bit different as it explains how to setup a collection that should be unavailable for excel-import:

> [@CASE: disable importing reconciliation data for a specific collection](https://community.silverfin.com/t/case-disable-importing-reconciliation-data-for-a-specific-collection/1492):
>
> In a account or reconciliation template, there is always the option to import reconciliation data automatically based upon the ledger (in case of an account template) or an excel file (works for both template types): [Screenshot-2019-05-23-at-09-32-03] But what if you wish a certain collection cannot be used for automatic reconciliation? We automatically fetch and display every fori-loop there is in the template. Disabling a fori-loop can actually be done by (mis)using the [addnewinputs-tag](https://community.silverfin.com/t/case-order-a-drop-or-custom-collection-on-certain-object/1108), l…

Let us known if it works out for you.

---

_[View the full topic](https://community.silverfin.com/t/import-excel-data-in-reconciliation-template/1556)._