# Import excel data in reconciliation template **URL:** \ **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:** 7\ **Page:** 1
**Author:** ![Ugis](https://avatars.discourse-cdn.com/v4/letter/u/bc8723/32.png) [@Ugis](https://community.silverfin.com/u/Ugis)\ **Post date:** [August 29, 2019, 11:10am UTC](https://community.silverfin.com/t/import-excel-data-in-reconciliation-template/1556/1 "2019-08-29T11:10:13Z")
Hi, I have a various exchange rates in excel. I want to get rates in reconciliation template and apply them to other reconciliation templates. Is there a way to import rates in a reconciliation template to avoid typing them manually every month? Thanks, Ugis ---
**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")
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. ---
**Author:** ![Ugis](https://avatars.discourse-cdn.com/v4/letter/u/bc8723/32.png) [@Ugis](https://community.silverfin.com/u/Ugis)\ **Post date:** [August 30, 2019, 12:43pm UTC](https://community.silverfin.com/t/import-excel-data-in-reconciliation-template/1556/3 "2019-08-30T12:43:42Z")
Hi Sven, Thanks for the reply. It was useful. I managed to link imported exch rates in one template to template where based on selected currency it gives me the rate. I want to push it a little further and see if I can use exchange rates that I imported in client A to apply them in client B. Is this possible? Many thanks, Ugis ---
**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 30, 2019, 2:31pm UTC](https://community.silverfin.com/t/import-excel-data-in-reconciliation-template/1556/4 "2019-08-30T14:31:57Z")
Hi @Ugis, Well, yes you can 😏 > [@CASE reference values across templates by using result tags](https://community.silverfin.com/t/case-reference-values-across-templates-by-using-result-tags/1157): > > If you want to reference a certain value or variable from recon template A in another template, there’s a way to do it with the so-called result tags in STL. They work like this (bulb just type in result and press TAB to get this preformatted code bulb): {% result 'name' content %} where the name is a shortname you can choose, and the content is the value or variable you want to reference to. Let’s say we have this variable done\_prepayments in our recon template Prepayments (which is al… Hope that case is enough to tackle this further. If not, let us known ---
**Author:** ![Ugis](https://avatars.discourse-cdn.com/v4/letter/u/bc8723/32.png) [@Ugis](https://community.silverfin.com/u/Ugis)\ **Post date:** [September 3, 2019, 9:15am UTC](https://community.silverfin.com/t/import-excel-data-in-reconciliation-template/1556/5 "2019-09-03T09:15:10Z")
Hi @sven, Thanks for the article. I managed to get value from template A and display it in Template B. When I change company form company C1 to company C2 I want to get value from C1-\> template A and display in company C2 -\> template B. Without the option to pin point company to look at template A I think it will not work. I have many companies. I want to upload exchange rates in company A and then other companies (B, C etc.) to pick that exchange rates from company A. Can it be done? Thanks, ---
**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:** [September 3, 2019, 9:18am UTC](https://community.silverfin.com/t/import-excel-data-in-reconciliation-template/1556/6 "2019-09-03T09:18:06Z")
Hi @Ugis, You can not access data from one client file to another. Related to `rates`: we are aware that an integration with Silverfin that would add this info (automatically or not) would be beneficial, and we are looking at possibilities but for now, I’m afraid to disappoint you. ---
**Author:** ![Ugis](https://avatars.discourse-cdn.com/v4/letter/u/bc8723/32.png) [@Ugis](https://community.silverfin.com/u/Ugis)\ **Post date:** [September 3, 2019, 9:48am UTC](https://community.silverfin.com/t/import-excel-data-in-reconciliation-template/1556/7 "2019-09-03T09:48:20Z")
Thanks for the update @sven. Glad to hear it is on your road map 🙂 Ugis