> For the complete documentation index, see [llms.txt](https://docs.infotopics.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.infotopics.com/supertables/configuration/configuration-screen/export-tab.md).

# Export Tab

On the Export tab you decide how your users can export a SuperTable, what goes into the exported file and how it's formatted.

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2Fgit-blob-1277531fc3aca9018ffaebe53da1eddd9b3c5af6%2Fimage.png?alt=media" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
The Export tab isn't shown when your SuperTable gets its data from the [Data Service](https://docs.infotopics.com/supertables/configuration/setting-up-supertables-with-data-service.md). Exporting is turned off in that mode.
{% endhint %}

## Layout options

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2Fgit-blob-a3fd84fc2b4e4bd5633f4c44624ac6fe224e8d67%2FSuperTables_Export_LayoutOptions.png?alt=media" alt="Layout options on the Export tab"><figcaption></figcaption></figure>

#### **Show button to export the data**

Adds a floating export button to your SuperTable, so your users can export the table without opening the context menu. Below it, tick **Export Excel**, **Export CSV** and **Export PDF** to choose which file types the button offers.

For every file type you selected, users can choose between two exports:

* **Export All Rows**: exports every row in the table.
* **Export Selected Rows**: exports only the rows the user selected. This option is greyed out until at least one row is selected.

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2Fgit-blob-aed14fcb19801a83b34da4066bdc53e38a21edd7%2FSuperTables_Export_FloatingDropdown.png?alt=media" alt="Export dropdown with All Rows and Selected Rows options for xlsx, csv and pdf" width="460"><figcaption></figcaption></figure>

#### Export button display type

Select how the export button is displayed in the table: as a dropdown menu or as icons.

{% tabs %}
{% tab title="Show button as icon" %}
Shows a separate icon for each export: All Rows and Selected Rows for every file type you selected. Hover over an icon to see what it exports.

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2Fgit-blob-603b3fabd5ee466a17593e3291ae2e24f27d224b%2Fimage.png?alt=media" alt=""><figcaption><p>Icon mode for export buttons</p></figcaption></figure>
{% endtab %}

{% tab title="Show button in dropdown menu" %}
Shows a single **Export** button that opens a menu with all the export options.

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2Fgit-blob-fa0ef404677f6642cbeb078bcb5b1836fe5c1e30%2Fimage.png?alt=media" alt=""><figcaption><p>Dropdown menu mode for export buttons</p></figcaption></figure>
{% endtab %}
{% endtabs %}

#### Export button position

Choose where the export button appears in the table: **Bottom right** (default), **Bottom left** or **Top right**.

## Styling options

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2Fgit-blob-fd77d038815b5b25823eae76c01f39c9e74d0ef9%2FSuperTables_Export_StylingOptions.png?alt=media" alt="Styling options on the Export tab"><figcaption></figcaption></figure>

#### **Export without SuperTable/dashboard styling (clean, neutral output)**

Enable this option to export the table without the styling applied in SuperTables or inherited from the Tableau dashboard. Excel and PDF exports then skip dashboard colors, backgrounds and other theme styling. CSV exports are always unstyled.

Use this when the exported file should contain the table structure and data without dashboard-specific colors and styling.

#### **Differentiate even and odd rows**

Use row banding in your Excel export.

#### **The first line are column header names**

Export the column header names as the first row of the export.

#### **Include header column groupings**

If you use column groups, you can choose to include the column group headers in your export.

#### **Export visible columns only**

In SuperTables you can show and hide columns. This option lets you export only the visible columns instead of all available columns.

#### **Export all rows except last level (only applicable when grouping)**

Use this option to keep the lowest level of your grouping out of the export. The row-level data isn't exported; the export only contains the aggregated data of your grouping structure.

This option isn't available when **When group is expanded, hide the parent row** is turned on in the [Appearance tab](https://docs.infotopics.com/supertables/configuration/configuration-screen/appearance-tab/grouping-options.md).

#### **Include groups with blank or null values in the export (only when grouping)**

When you group rows, some groups can have a blank or null value. Turn this option off to leave those groups out of the export.

#### **Include formatting in values (CSV only)**

On the [Data tab](https://docs.infotopics.com/supertables/configuration/configuration-screen/data-tab.md) you can set the formatting of your measures. This option lets you include that formatting in your CSV export, or export the raw values instead. It only affects the formatted values, not the look of the table in your dashboard.

#### **Include formatting in copied values**

This option lets you include or exclude the measure formatting from the Data tab when you copy selected cells (or rows) to the clipboard from the context menu. Open the context menu with a right mouse click.

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2Fgit-blob-f23bc0be9e996f03db180766af202f1e6632f536%2Fcontext%20menu.png?alt=media" alt=""><figcaption></figcaption></figure>

#### **Include URL actions**

Turns the cells of columns with a URL action into clickable hyperlinks in your Excel export. Links longer than 255 characters are exported as plain values, because Excel doesn't support longer hyperlinks.

#### **Hide column range label in PDF export**

When a table is too wide for one PDF page, SuperTables spreads the columns over several pages and shows a "Columns X to Y" label above each page. Enable this option to hide that label.

## Export name

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2Fgit-blob-3e845ab67d0b0d718dc1c0cfed038c8b417d6202%2FSuperTables_Export_Name.png?alt=media" alt="Export name settings for CSV, Excel and PDF" width="560"><figcaption></figcaption></figure>

Set the file name for each export type separately: **CSV**, **Excel** and **PDF**. By default the files are called `export.csv`, `export.xlsx` and `export.pdf`.

* **Static name**: type a fixed name in **File name**, for example `Sales overview.xlsx`.
* **Use parameter value**: pick a string parameter from your workbook. The exported file gets the current value of that parameter as its name, so you can make the file name dynamic.

{% hint style="info" %}
Add the file extension to a static name (for example `.pdf`), so the exported file opens in the right application.
{% endhint %}

#### **Limit Exporting**

Limit the number of rows that can be exported. The export then only contains the top rows, up to the number you set.

## Enterprise Only

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2Fgit-blob-1e22e1fde18caf2eed861c5d9b10b1854f6431e3%2FScreenshot%202024-07-30%20at%2015.22.36.png?alt=media" alt=""><figcaption></figcaption></figure>

#### **Logging Options(Enterprise Only)**

Audit export and copy actions in SuperTables in a log file on the server where SuperTables is hosted. The log file will be found in the folder where the SuperTables binary is running. Log rows exist out of: Who, When, What (Number of Rows, Number of Columns), Type (Export, Copy), Dashboard, Workbook.

#### **Set usernames(Enterprise Only)**

Select a worksheet and column containing the username(). enable/disable audit on export and audit on copy. To create the user name you can create a calculated field and name it ‘Username’ with the calculation ‘USERNAME()’ Drag this to the marks pane of your datasheet.

#### Export Image

SuperTables enterprise enables you to export images that are present in your table to Excel. Click the include images in export option to enable this functionality.

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2Fgit-blob-6a2fc3007fd0388e04970dfa80dd2395d7d5329b%2FScreenshot%202024-07-29%20at%2016.28.54.png?alt=media" alt=""><figcaption></figcaption></figure>

**Note: Only PDF does not support text styles. This means any text styles set for both the column header and column values such as BOLD, ITALICS etc in the SUperTables view will not be included in the PDF export.**


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.infotopics.com/supertables/configuration/configuration-screen/export-tab.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
