# Read, Write, and Append Data in Excel

> Copy ranges from a workbook, paste, and append them to another workbook.

The example below explains how to copy ranges from a workbook, paste, and append them to another workbook. It presents activities such as [Read Range Workbook](https://docs.uipath.com/activities/other/latest/productivity/read-range), [Write Range Workbook](https://docs.uipath.com/activities/other/latest/productivity/write-range), and [Append Range Workbook](https://docs.uipath.com/activities/other/latest/productivity/append-range). You can find these activities in the **UiPath.Excel.Activities** package.

:::note
Download and extract the archive with the project in this example and copy the two **.xlsx** files to your project folder.
:::

This is how the automation process can be built:

1. Open Studio and create a new **Process**.
2. Drag a **Sequence** container in the **Workflow Designer**.
   * Create the following variable:

   | Variable Name | Variable Type | Default Value |
   | --- | --- | --- |
   | `employees` | **DataTable** | **N/A** |
3. Add a **Read Range** activity inside the **Sequence** container.
   * Add the expression `"companyEmployees.xlsx"` in the **Workbook path** field.
   * Add the value **QADep** in the **Sheet** field and set the cells range at **"A1:B5"**.
4. Add a **Write Range** activity below the **Read Range** activity.
   * Add the expression `"employeeIncome.xlsx"` in the **Workbook path** field.
   * Add the value `"DecemberIncome"` in the **Sheet** field and set the cells range at **"A2"**.
   * Add the variable `employees` in the **Data Table** field.
5. Add a **Read Range** activity below the **Write Range** activity.
   * Add the expression `"companyEmployees.xlsx"` in the **Workbook path** field.
   * Add the value **DevDep** in the **Sheet** field and set the cells range at **"A6:B10"**.
6. Add an **Append Range** activity below the **Read Range** activity.
   * Add the expression `"employeeIncome.xlsx"` in the **Workbook path** field.
   * Add the value `"DecemberIncome"` in the **Sheet** field.
   * Add the variable `employees` in the **Data Table** field.

This is how the workflow should look:

![docs image](https://dev-assets.cms.uipath.com/assets/images/activities/activities-docs-image-179487-5821f86a.webp)

7. Run the process. The activities copy data from one workbook and add it into a second workbook.

[Download example](https://docexamples.uipath.com/examples/Activities/Read,%20Write,%20and%20Append%20Data%20in%20Excel%20-%20Example.zip)