# Designing tabular report templates

With tabular reporting, you can design Excel-based reports containing large, detailed datasets. You design these templates in the Qlik add-in for Microsoft Excel. Generated reports can be in .xlsx or PDF format.

[Building report templates with the Qlik add-in for Microsoft Office](https://play.vidyard.com/tHdRWQAMTu5JC3hMTTUgcP)

Tabular report generated from Qlik Cloud Analytics

Tabular report generated from Qlik Cloud Analytics

Tabular report generated from Qlik Cloud AnalyticsQlik Cloud Analytics ![Tabular report (.xlsx file) generated from a Qlik Sense app in Qlik Cloud Analytics](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Resources/Images/ui_gen_CloudTabularReport.png)

## What is tabular reporting?

Tabular reporting is built for spreadsheet-style report authoring and consumption. Using the Qlik add-in for Microsoft Excel, develop report templates based on your Qlik Sense application. When templates are ready, upload them into the Qlik Sense application for use in scheduled and on-demand reporting.

Data can be added in a number of ways, including:

* Chart images

* Column-level tabular data from a chart

* Variables defined in the source Qlik Sense application

* Expressions using the native Qlik Sense calculations

* Native Excel calculations applied to tabular data

You can loop the report elements over field and chart values, creating new filtered sections and worksheets based on these discrete values.

## Developing tabular report templates

The following help topics can help you learn about creating tabular report templates.

### Installing the Qlik add-in for Microsoft Excel

* [Deploying and installing Qlik add-ins for Microsoft Office](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Install/reporting-install-add-ins.htm)

### Activating and getting started with the add-in

* [Getting started with using Qlik add-ins for Microsoft Office](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/OfficeCommon/add-in-get-started.htm)

### Adding content to your template

* [Adding content to report templates with Qlik add-ins for Microsoft Office](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/OfficeCommon/add-in-content.htm)
* [Adding charts as images to report templates with Qlik add-ins for Microsoft Office](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/OfficeCommon/add-in-chart-images.htm)
* [Adding tabular data to report templates with Qlik add-ins for Microsoft Office](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/OfficeCommon/add-in-tabular-data.htm)
* [Formatting properties for tabular data in Excel report templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/Excel/add-in-excel-tabular-properties.htm)
* [Working with native Excel tables](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/Excel/add-in-excel-native-tables.htm)
* [Removing rows with the Deleterow tag](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/Excel/add-in-excel-deleterow.htm)
* [Handling Qlik application data in tabular reports](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/Excel/add-in-excel-handle-data.htm)
* [Using variables and expressions in report templates with Qlik add-ins for Microsoft Office](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/OfficeCommon/add-in-variables-expressions.htm)
* [Working with levels and pages in tabular report templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/Excel/add-in-excel-levels-pages.htm)
* [Removing content from report templates with Qlik add-ins for Microsoft Office](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/OfficeCommon/add-in-remove-content.htm)

### Example

* [Example - Creating a tabular report](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/Excel/tabular-report-example.htm)

Related learning:

* [Qlik Reporting: Introduction to PixelPerfect Editor & Tabular Reporting](https://help.qlik.com/lnk/Qlik_Reporting_PixelPerfect)

## Learn more

* [Qlik Reporting: Introduction to PixelPerfect Editor & Tabular Reporting](https://help.qlik.com/lnk/Qlik_Reporting_PixelPerfect)