---
title: "Gepersonaliseerde statistieken - Excel-sjabloon"
slug: "personalized-statistics-excel-templates"
updated: 2024-04-18T15:00:48Z
published: 2024-04-18T15:00:48Z
canonical: "docs.retailvista.net/personalized-statistics-excel-templates"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.retailvista.net/llms.txt
> Use this file to discover all available pages before exploring further.

# Personalized Statistics - Excel Templates

This article describes how to make a personalized statistics - Excel Template.

-> Start -> Statistics -> Statistics

Select a statistic you want to personalize and click on "Export to Excel".![](https://cdn.document360.io/9cfe1b80-9c32-4b2a-9328-1df667cdd950/Images/Documentation/image-1713452321807.png?sv=2026-02-06&spr=https&st=2026-10-27T03%3A23%3A55Z&se=2026-10-27T04%3A23%3A55Z&sr=c&sp=r&sig=QQ35m1VImyXOrcq8HtmbhZABRJICoFEEpMBa8%2B4BHVg%3D)Open this document and delete the data. We do not need the data, because it is only for formatting the file.

You can add a logo, picture, change the font and colors of the columns, if you like.

![](https://cdn.document360.io/9cfe1b80-9c32-4b2a-9328-1df667cdd950/Images/Documentation/image-1713452349612.png?sv=2026-02-06&spr=https&st=2026-10-27T03%3A23%3A55Z&se=2026-10-27T04%3A23%3A55Z&sr=c&sp=r&sig=QQ35m1VImyXOrcq8HtmbhZABRJICoFEEpMBa8%2B4BHVg%3D)

Save this document with the extension .xltx

![](https://cdn.document360.io/9cfe1b80-9c32-4b2a-9328-1df667cdd950/Images/Documentation/image-1713452359857.png?sv=2026-02-06&spr=https&st=2026-10-27T03%3A23%3A55Z&se=2026-10-27T04%3A23%3A55Z&sr=c&sp=r&sig=QQ35m1VImyXOrcq8HtmbhZABRJICoFEEpMBa8%2B4BHVg%3D)Go to -> Administration -> Excel templates

![](https://cdn.document360.io/9cfe1b80-9c32-4b2a-9328-1df667cdd950/Images/Documentation/image-1713452368912.png?sv=2026-02-06&spr=https&st=2026-10-27T03%3A23%3A55Z&se=2026-10-27T04%3A23%3A55Z&sr=c&sp=r&sig=QQ35m1VImyXOrcq8HtmbhZABRJICoFEEpMBa8%2B4BHVg%3D)Add a new Excel template with the green "+" symbol.

![](https://cdn.document360.io/9cfe1b80-9c32-4b2a-9328-1df667cdd950/Images/Documentation/image-1713452378856.png?sv=2026-02-06&spr=https&st=2026-10-27T03%3A23%3A55Z&se=2026-10-27T04%3A23%3A55Z&sr=c&sp=r&sig=QQ35m1VImyXOrcq8HtmbhZABRJICoFEEpMBa8%2B4BHVg%3D)Fill in the description and upload the template file by clicking on "Bestand kiezen" (This text is a translation issue, which will be fixed)

Click on the "Save" icon.

![](https://cdn.document360.io/9cfe1b80-9c32-4b2a-9328-1df667cdd950/Images/Documentation/image-1713452388674.png?sv=2026-02-06&spr=https&st=2026-10-27T03%3A23%3A55Z&se=2026-10-27T04%3A23%3A55Z&sr=c&sp=r&sig=QQ35m1VImyXOrcq8HtmbhZABRJICoFEEpMBa8%2B4BHVg%3D)When you go back to -> Start -> Statistics -> Statistics, you can select this Excel tempate on tab "Excel".

![](https://cdn.document360.io/9cfe1b80-9c32-4b2a-9328-1df667cdd950/Images/Documentation/image-1713452397805.png?sv=2026-02-06&spr=https&st=2026-10-27T03%3A23%3A55Z&se=2026-10-27T04%3A23%3A55Z&sr=c&sp=r&sig=QQ35m1VImyXOrcq8HtmbhZABRJICoFEEpMBa8%2B4BHVg%3D) If we now click on "Export to Excel", we can see the template with the layout changes.. See also image below.

![](https://cdn.document360.io/9cfe1b80-9c32-4b2a-9328-1df667cdd950/Images/Documentation/image-1713452406258.png?sv=2026-02-06&spr=https&st=2026-10-27T03%3A23%3A55Z&se=2026-10-27T04%3A23%3A55Z&sr=c&sp=r&sig=QQ35m1VImyXOrcq8HtmbhZABRJICoFEEpMBa8%2B4BHVg%3D)It can also be useful to create a filter template. If the filter template is chosen, each time after clicking "Export to Excel" this personalized Excel tempate will be shown.

You can also create a column selection, so you only see the selected columns in the excel file. Please see also guide Filters and Column Templates