# Tutorial: Creating a Pivot Table

> In this tutorial, we have an Excel file with data about suppliers and we want to find out how many suppliers there are in each city and what number of employees the suppliers have in each city. To achieve this, we will build an automation that creates a pivot table.

In this tutorial, we have an Excel file with data about suppliers and we want to find out how many suppliers there are in each city and what number of employees the suppliers have in each city. To achieve this, we will build an automation that creates a pivot table.

1. Set up the project and get the necessary files
   1. [Create a new blank project using the default settings](https://docs.uipath.com/studiox/standalone/2024.10/user-guide/creating-your-first-automation-project).
   2. Download and extract the archive with the automation project in this tutorial using the button at the bottom of this page and copy the file `Suppliers.xlsx` to your project folder.
2. Add the Excel file to the project.
   1. Click **Add Activity** ![docs image](https://dev-assets.cms.uipath.com/assets/images/studiox/studiox-image-plus_sign-ad04beef-8e75b25b.png) in the Designer panel, and then find the **Use Excel File** activity in the search box at the top of the screen and select it. A **Use Excel File** activity is added to the Designer panel.
   2. In the activity:
      * Click **Browse** ![docs image](https://dev-assets.cms.uipath.com/assets/images/studiox/studiox-docs-image-browse_files-3f5ed0c5-1431ef7d.png) next to the **Excel file** field, and then browse to and select the file `Suppliers.xlsx`
      * In the field **Reference as**, enter `Suppliers`.

        You have indicated that you will work with the file `Suppliers.xlsx` that is known in your automation as `Suppliers`.
3. Add and configure the Create Pivot Table activity.
   1. In the Use Excel File activity, click **Add Activity** ![docs image](https://dev-assets.cms.uipath.com/assets/images/studiox/studiox-image-plus_sign-ad04beef-8e75b25b.png), then find the [Create Pivot Table](https://docs.uipath.com/activities/docs/create-pivot-table-x) activity in the search box at the top of the screen and double-click it. The activity is added inside the Use Excel File activity.
   2. In the Create Pivot Table activity, define the source range and the range where to create the pivot table:

      a) Click **Plus** ![](https://dev-assets.cms.uipath.com/assets/images/studiox/studiox-image-plus_menu-90e71eaa-8a20ac7d.png) on the right side of the **Source** field, and then select **Suppliers** > **Indicate in Excel**.

      b) In the Excel file, select all the columns in the **Input** sheet and then click **Confirm** in the UiPath tab in the Excel ribbon.

      You have indicated that you want to create a pivot table for columns A-L in the sheet named Input in the Excel file referenced as Suppliers. The Table range field displays your selection as [Suppliers] Input!A:L.

      c) Click **Plus** ![docs image](https://dev-assets.cms.uipath.com/assets/images/studiox/studiox-image-plus_menu-90e71eaa-8a20ac7d.png) on the right side of the **New table name** field and then select **Text**. In the Text Builder window, enter a name for the pivot table, for example `CountByCity` and click **Save**.

      d) Click **Plus** ![](https://dev-assets.cms.uipath.com/assets/images/studiox/studiox-image-plus_menu-90e71eaa-8a20ac7d.png) on the right side of the **Destination** field and then select **Suppliers** > **Output [Sheet]**.

      You have indicated that you want to create the pivot table in the sheet named Output in the Excel file referenced as Suppliers. The Destination field displays your selection as [Suppliers] Output.
   3. In the Create Pivot Table activity, add the pivot table fields:

      a) Click the **Add Pivot Table Field** button, then click **Plus** ![](https://dev-assets.cms.uipath.com/assets/images/studiox/studiox-image-plus_menu-90e71eaa-8a20ac7d.png) on the right side of **Field** and select **Range** > **City**.

      b) From the **Is a** drop-down menu, select **Row**.

      You have indicated that you want the entries in the City column in the sheet named Input in the Excel file referenced as Suppliers to be rows in your pivot table.

      c) Click the **Add Pivot Table Field** button again to add a second field in the pivot table to count the suppliers.

      In the second **Pivot Field**, click **Plus** ![](https://dev-assets.cms.uipath.com/assets/images/studiox/studiox-image-plus_menu-90e71eaa-8a20ac7d.png) on the right side of **Field** and then select **Range** > **Internal Name**.

      d) From the **Is a** drop-down menu, select **Value**, and then, from the **Function** drop-down menu, select **Count**.

      You have indicated that you want to count the suppliers identified by the column Internal Name in the sheet named Input in the Excel file referenced as Suppliers.

      e) Click the **Add Pivot Table Field** button again to add a third field in the pivot table to sum up the number of employees.

      In the third **Pivot Field**, click **Plus** ![](https://dev-assets.cms.uipath.com/assets/images/studiox/studiox-image-plus_menu-90e71eaa-8a20ac7d.png) on the right side of **Field** and then select **Range** > **Number of Employees**.

      f) From the **Is a** drop-down menu, select **Value**, and then, from the **Function** drop-down menu, select **Sum**.

      You have indicated that you want to sum up the number of employees in the sheet named Input in the Excel file referenced as Suppliers.

      g) To make the Pivot Fields more easily identifiable, edit the name in the upper bar of each one. For example, use `Pivot Field City` for the first, `Pivot Field Name` for the second, `Pivot Field Employees` for the third.

      ![docs image](https://dev-assets.cms.uipath.com/assets/images/studiox/studiox-docs-image-350082-40abd767-5190e9c6.webp)
   4. Click **Save** in the StudioX ribbon to save the automation, then click **Run** to execute the automation.The pivot table is created in the Output sheet of the Suppliers.xlsx file. [Download example](https://documentationexamplerepo.blob.core.windows.net/examples/StudioX_V2022.10/ExcelCreatePivotTable.zip)