# Multisheet excel export[¶](https://www.dataiku.com/product/plugins/multisheet-excel-export/)

## This plugin enables the export of multiple DSS datasets to a single multi-sheet Excel file[¶](https://www.dataiku.com/product/plugins/multisheet-excel-export/)

## Plugin Information[¶](https://www.dataiku.com/product/plugins/multisheet-excel-export/)

|  |  |

| --- | --- |

| Version | 1.0.1 |

| Author | Dataiku |

| Released | 2020-11 |

| Last updated | 2022-03 |

| License | Apache Software License |

| Source code | Github |

| Reporting issues | Github |

This plugin enables the export of multiple DSS datasets to a single multi-sheet excel file (*.xlsx*). For each exported dataset, there will be one sheet in the output file.

## Requirements[¶](https://www.dataiku.com/product/plugins/multisheet-excel-export/)

The installation setup for this plugin follows the standard Dataiku code environment creation procedure. Through code environment creation at plugin install time, the following packages will be installed

* openpyxl==3.0.5

* pathvalidate==2.3.0

## How To Use[¶](https://www.dataiku.com/product/plugins/multisheet-excel-export/)

### Export multiple DSS datasets as one multi-sheet Excel file[¶](https://www.dataiku.com/product/plugins/multisheet-excel-export/)

From your flow, select the datasets you want to merge in a single Excel file,

##[¶](https://www.dataiku.com/product/plugins/multisheet-excel-export/)

Click on the **Multisheet Excel Export** icon in the column at the right of the flow or from the recipe menu,

This plugin contains a single recipe that merges the input dataset in a single (multisheet) Excel worksheet,

Choose a name for the folder that will contain the output file in the flow,

Choose a name for the output excel worksheet. (Do not include a file extension in this name, the extension will always be *.xlsx*)

The resulting folder will appear in the flow as shown in the following screenshot,

You can now click on the folder and download the *.xslsx*file.

Additional instructions are available in our Github repository

### Install In DSS[¶](https://www.dataiku.com/product/plugins/multisheet-excel-export/)

To install the plugin, open the  Apps menu, click Plugins and search for MultiSheet Excel Exporter.

Alternatively, you can download a zipped version here.
