# CASE creating export file: export all used accounts to XLS

**URL:** <https://community.silverfin.com/t/case-creating-export-file-export-all-used-accounts-to-xls/1160>\
**Category:** Cases\
**Tags:** export, use\_case\
**Created:** [August 28, 2018, 3:55pm UTC](https://community.silverfin.com/t/case-creating-export-file-export-all-used-accounts-to-xls/1160 "2018-08-28T15:55:12Z")\
**Posts on this page:** 1\
**Page:** 1

<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 28, 2018, 3:55pm UTC](https://community.silverfin.com/t/case-creating-export-file-export-all-used-accounts-to-xls/1160/1 "2018-08-28T15:55:12Z")

</div>

If we want to export all used accounts and their mapped info (name and number), even if there are no bookings on them, to Excel f.i., we can create an export-file on firm level. This acts as a template, where you can access all data in Silverfin through STL.

 ![54](https://canada1.discourse-cdn.com/flex030/uploads/getsilverfin/original/1X/e80d5855d39a749bc3c7c647bab9b1e1ee49fce9.png)

When creating the export file, you can give it a random name, but most importantly, give it a file name where the extension can be defined:  
 ![55](https://canada1.discourse-cdn.com/flex030/uploads/getsilverfin/original/1X/1d3fb47eccee0616d768781330727e809ac74a7e.png)

In above example the object `{{ company.name }}` will even be used as a name of the file!

To export all the needed data (f.i. if we want a list of all accounts, mapped accounts and their respective data), we just need to use double quotes for each object we want and separate them with an `;`-sign: that way, when opening the file in MS Excel f.i., each object will be a separate column:

```auto
{% stripnewlines %}
"Account_nbr";"Account_mapped_nbr";"Account name";"Account mapped name"
{% for acc in period.accounts.include_zeros %}
{% newline %}
"{{ acc.number }}";"{{ acc.original_number }}";"{{ acc.name }}";"{{ acc.original_name }}"
{% endfor %}
{% endstripnewlines %}

```

Now you can use this export file in the working papers under the option Download data, which overviews all possible export files and custom export files that can be made:  
 ![58](https://canada1.discourse-cdn.com/flex030/uploads/getsilverfin/original/1X/414adb9ae1296c2e8e86e13f84e996f110ec0d25.png)

All known formats can be used this way: xml; csv, xls or even xbrl!