---
title: Adding a new column to an Excel Report
description: "This article shows you how to add a column to an existing Excel report, for example a **Category** column on a risk register. > **Applies to:** System administrators (`admin` role) · **Module:** Set up > Reports ## Opening the Report…"
url: "https://support.symbiant.co.uk/kb/adding-a-new-excel-column/"
updated: "2026-10-30"
category: Reporting Suite Tutorial
tags:
  - Excel
  - Reports
  - Spreadsheets
  - Updating
---

# Adding a new column to an Excel Report

This article shows you how to add a column to an existing Excel report, for example a **Category** column on a risk register.

> **Applies to:** System administrators (`admin` role) · **Module:** Set up > Reports

## Opening the Report

1. Click the **Set up** spanner at the bottom left of the screen.
   ![The Set up spanner at the bottom left](https://support.symbiant.co.uk/wp-content/uploads/2026/10/kb-common-setup-spanner-c03de5.png)
2. Under **System**, click **Reports**.
   ![Reports in the Set up menu](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-setup-reports-ab6dd7.png)
3. Type part of the name in the **Name** filter and click the report.

## Adding the Field to the Data Source

1. Click **Graph...** next to the data source.
2. Tick the new field. For a drop-down, tick the field and its **text** value underneath, as shown here for **Level**. Click **Show translated attribute names** at the top right if the keys are hard to read.
   ![Ticking a drop-down field and its text value](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-graph-85561c.png)
3. Click **OK**.

## Getting the New Marker

Click **Show available markers...** and copy the new marker, for example `{{data:risk/category:risk.category/text}}`.

![Show available markers...](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-show-markers-link-49a0df.png)

## Updating the Template

1. Click the template's file name under **Document template** to download it.
   ![The current template](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-doc-template-existing-3a9557.png)
2. Open it in Excel. Add the column heading, and paste the marker in the row underneath.
   ![The new Category column with its marker](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-add-column-template-ada7cf.png)
3. Save the file.

## Replacing the Template

1. Click the bin icon next to the old template to remove it.
   ![The bin icon](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-template-bin-6b8250.png)
2. Click **Choose File** and pick your updated template.
   ![Uploading the template](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-doc-template-new-058b91.png)
3. Click **Save** at the top right.
   ![The Save button](https://support.symbiant.co.uk/wp-content/uploads/2026/10/translators-save-f3437f.png)

## Generating the Report

1. Click the **Set up** button at the bottom left to leave Set up.
   ![Leaving Set up](https://support.symbiant.co.uk/wp-content/uploads/2026/10/kb-common-exit-setup-a986db.png)
2. Click **Reports** at the bottom of the menu on the left.
   ![Reports in the main menu](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-front-nav-d62952.png)
3. Find the report (type part of its name in the **Name** filter) and click **Generate**. The file downloads to your computer.
   ![Generate](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-front-generate-372a86.png)

> **Tip:** Click **Filter** next to **Generate** to limit which records go into the report. See [Advanced Filtering on Reports](https://support.symbiant.co.uk/kb/advanced-filtering-on-reports/).

## Related articles

- [Removing a column in an Excel Report](https://support.symbiant.co.uk/kb/removing-an-excel-column/)
- [Creating an Excel Report (Basic Data Output)](https://support.symbiant.co.uk/kb/basic-excel-report/)
