---
title: "Excel Templates"
canonical: "https://docs.getxray.app/space/XRAYCLOUD/44570603/Excel%20Templates"
format: markdown
---
> Macro (ui-expand)
> 
> > Macro (toc)

# Creating Excel Templates

> ℹ️ Check the Excel Templates in the [Xporter Template Store](https://store.getxporter.app/?platf=JIRACLOUD&cats=6&sort=1&order=desc&keyWord=excel).


To create Microsoft Excel Templates (Figure 1), you only need to add [mappings](https://getxraydocs.atlassian.net/wiki/spaces/XRAYCLOUD/pages/44570571) the same way you do with Microsoft Word Templates.

![Figure 1 - Mappings](media://8ab0254f-979e-4091-bdfd-e47653d0df5d)

`${Summary}`, `${fullname:ReporterId}` and `${fullname:AssigneeId}` (Figure 1 - 1) are examples of mappings similar to the ones used on Word Templates.


> ℹ️ You can install this report example via the [Xporter Template Store](https://store.getxporter.app/view/11?platf=JIRACLOUD&cats=6&sort=1&order=desc).

# Iterations

<span style="color: #333333">To define an iteration, you need to merge columns and define the "for" inside those merged cells (Figure 1 - 2). The same thing must be done to determine the "end" of the iteration. All content between the "for" and the "end" (Figure 1 - 2) will be duplicated for each iteration.</span>

# Functions

Differences between the Word and Excel definitions:

- **Word**: `@{title=${Key}|href=${BaseURL}/browse/${Key}}`
- **Excel**: `${link:title=${Key},href=${BaseURL}/browse/${Key}}`

> ℹ️ In Excel, `@` is not allowed as it is considered an invalid formula.

# Use Case

## Problem

To create a chart in a sheet populated by exported data from a different sheet.

## Solution

> Macro (ui-steps)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)


<details>
<summary>Support/Troubleshooting</summary>

If you have questions or technical issues, please [contact the Support team via the Customer Portal (Jira service management)](https://jira.getxray.app/servicedesk/customer/portal/2/user/login?destination=portal%2F2%2Fcreate%2F28) or [send us a message using the in-app chat](https://getxraydocs.atlassian.net/wiki/spaces/XRAYCLOUD/pages/44577312).
</details>