---
title: Removing a column in an Excel Report
description: "This article shows you how to remove a column from an existing Excel report. > **Applies to:** System administrators (`admin` role) · **Module:** Set up > Reports ## Opening the Report 1. Click the **Set up** spanner at the bottom…"
url: "https://support.symbiant.co.uk/kb/removing-an-excel-column/"
updated: "2026-10-30"
category: Reporting Suite Tutorial
tags:
  - Delete
  - Excel
  - Reports
  - Spreadsheets
---

# Removing a column in an Excel Report

This article shows you how to remove a column from an existing Excel report.

> **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.

## 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 and delete the whole column you don't want, for example **Details** (column D): right-click the column letter and choose **Delete**.
   ![The Details column to delete](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-remove-column-template-1666ca.png)
3. Save the file.

> **Tip:** You don't need to change the data source. A field with no marker in the template simply isn't shown.

## 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

- [Adding a new column to an Excel Report](https://support.symbiant.co.uk/kb/adding-a-new-excel-column/)
- [Creating an Excel Report (Basic Data Output)](https://support.symbiant.co.uk/kb/basic-excel-report/)
