# Include Hidden Grid Columns in Exported Excel Files

## Environment

<table>
 <tr>
  <td>Product</td>
  <td>Progress® Kendo UI® Grid for jQuery</td>
 </tr>
 <tr>
  <td>Product Version</td>
  <td>2018.2.516</td>
 </tr>
</table>

## Description

How can I show some of the hidden columns of the Grid in the exported Excel file?

> **Important**
>
> As of Kendo UI R1 2021 the grid columns have an [`exportable`](https://docs.telerik.com/kendo-ui/api/ui/grid/configuration/columns#columnsexportable) configuration, which if enabled, will include the hidden column in the exported file.

## Solution

Use the [`hideColumn`](https://docs.telerik.com/kendo-ui/api/ui/grid/methods/hidecolumn) or [`showColumn`](https://docs.telerik.com/kendo-ui/api/ui/grid/methods/showcolumn) methods to change the visibility of the columns before and after the export and utilize the [`excelExport`](https://docs.telerik.com/kendo-ui/api/ui/grid/events/excelexport) event.

The following code snippet demonstrates the implementation of the suggested approach.

```
var exportFlag = false;
$("#grid").data("kendoGrid").bind("excelExport", function (e) {
    if (!exportFlag) {
        e.sender.showColumn(1);
        e.preventDefault();
        exportFlag = true;
        setTimeout(function () {
            e.sender.saveAsExcel();
        });
    } else {
        e.sender.hideColumn(1);
        exportFlag = false;
    }
});
```

## See Also

* [Exporting Hidden Columns to PDF](https://docs.telerik.com/kendo-ui/knowledge-base/grid-include-hidden-columns-to-exported-pdf)
* [API Reference of the exportable Configuration](https://docs.telerik.com/kendo-ui/api/ui/grid/configuration/columns#columnsexportable)
* [API Reference of the showColumn Method](https://docs.telerik.com/kendo-ui/api/ui/grid/methods/showcolumn)
* [API Reference of the hideColumn Method](https://docs.telerik.com/kendo-ui/api/ui/grid/methods/hidecolumn)
* [API Reference of the excelExportevent Event](https://docs.telerik.com/kendo-ui/api/ui/grid/events/excelexport)