# Create Pivot Table

> Create Pivot Table activity that creates a pivot table from a specified range in Excel.

`UiPath.Excel.Activities.ExcelCreatePivotTable`

## Description

Creates a pivot table from a specified range.

## Project compatibility

Windows - Legacy | Windows

## Properties

### Common

* **DisplayName** - The display name of the activity.

### Destination

* **Range** - The range where you want the pivot table to be created. This field supports only strings and String variables.
* **Table Name** - The name of the pivot table that is to be created. This field supports only strings and String variables.

### Input

* **SheetName** - The name of the sheet you want to create the pivot table from. This field supports only strings and String variables.
* **SourceTableName** - The name of the source table you want to create the pivot table from. This field supports only strings and String variables.

### Misc

* **Private** - If selected, the values of variables and arguments are no longer logged at Verbose level.

## Example of Using the Create Pivot Table Activity

To exemplify how to use this activity, we have built an automation project which creates a Pivot Table from an Excel workbook.

[Download example](https://www.uipath.com/hubfs/Documentation/WorkflowExamples/18.3%20Examples/Excel/Create%20Pivot%20Table.zip)