---
title: Creating an Excel Tabular Report (Perfect for CSV)
description: "This article shows you how to create an Excel report from a **Tabular** data source. Each column is one value, which makes the output easy to save as CSV or load into other tools. > **Applies to:** System administrators (`admin`…"
url: "https://support.symbiant.co.uk/kb/tabular-excel-report/"
updated: "2026-10-30"
category: Reporting Suite Tutorial
tags:
  - Add
  - Excel
  - Reports
  - Spreadsheets
---

# Creating an Excel Tabular Report (Perfect for CSV)

This article shows you how to create an Excel report from a **Tabular** data source. Each column is one value, which makes the output easy to save as CSV or load into other tools.

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

## Opening Reports

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)

1. Click the **+** at the top right to start a new report.
   ![The + button](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-add-plus-d8c64f.png)

## Report Details

1. In **Resource**, choose the module the report pulls data from, for example **Register-Risks**. Type to search the list.
   ![Choosing the Resource](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-new-resource-4eb776.png)
2. In **Name**, enter the report's name as users will see it, for example `Risk Register (Acme)`.
   ![Naming the report](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-new-name-468e92.png)
3. In **Type**, choose **Excel (.xlsx)**. The full list is Word (.docx), Excel (.xlsx), PowerPoint (.pptx), XML and JSON.
   ![The Type list](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-new-type-0e893f.png)
4. Under **Assignments**, tick who can generate the report: users, roles and/or divisions. In this example, the **admin** and **risk_admin** roles. See [Reporting Permissions](https://support.symbiant.co.uk/kb/reporting-permissions/).
   ![Assigning the report to roles](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-new-assign-7012c9.png)

Once a type is chosen, the **Preferences** panel on the right is where you set up the data and the template.

## Adding a Tabular Data Source

1. Under **Data sources**, click **Add New**, then **Tabular**.
   ![The Add New list of data source types](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-addnew-4833c6.png)
2. Click **Columns...** next to the new data source. The ✗ turns into a ✓ once columns are set.
   ![Columns... on a tabular data source](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-tabular-columns-296864.png)
3. Click the **+** at the top right of the window to add a column.
   ![The + that adds a column](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-tabular-plus-35ec1a.png)
4. In the column's lower box, search for the field and pick it, for example `risk/reference`.
   ![Searching for a field](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-tabular-search-f8f552.png)
5. In the upper box, enter the column's tag name, for example `Reference`. This becomes the marker name. Click the **⊖** at the top right of a column to remove it.
   ![A column with a tag name and field](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-tabular-card-d37a05.png)
6. Repeat for each column, then click **OK**.

> **Tip:** The **Show translated attribute names** icon next to the **+** shows friendly field names.

## Getting the Markers

Click **Show available markers...**. Tabular markers use the data source name and the tag name. For a data source called `rl` with a column tagged `Reference`, the marker is `{{rl:Reference}}`.

## Building the Template

In Excel, put your headings in one row and the markers underneath, one per column, the same way as in [Creating an Excel Report](https://support.symbiant.co.uk/kb/basic-excel-report/).

## Uploading the Template

1. Under **Document template**, click **Choose File** (or drag the file onto **Drop file here**) and pick your template.
   ![Uploading the template](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-doc-template-new-058b91.png)
2. 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

- [Creating an Excel Report (Basic Data Output)](https://support.symbiant.co.uk/kb/basic-excel-report/)
- [Reporting Permissions](https://support.symbiant.co.uk/kb/reporting-permissions/)
