---
title: "Save Data Table To Excel File Step"
url: "https://docs.robotiq.ai/en/article/save-data-table-to-excel-file-step"
language: "en"
last_updated: "2025-12-24T15:03:20.719Z"
---

# Save Data Table To Excel File Step

The "Save Data Table To Excel File" step takes data from a Data Table variable and puts it into an Excel file. Use this when you want to export organized data from your automation process into a spreadsheet.

## How to Use Save Data Table To Excel File

This step saves what's in a Data Table variable to a specific Excel file and sheet.

### Step 1: Add the Step to Your Process

1.  Drag the "Save Data Table To Excel File" step into your process workflow.
2.  Click on the step to set up its properties.

### Step 2: Set Up the Step Parameters

1.  **Datatable variable name:** Pick the Data Table variable that has the data you want to save.
2.  **File Path:** Give the full path to the Excel file. You can use a variable you've already set up or just type the path directly.
3.  **Sheet name:** Type the name of the sheet in the Excel file where the data will go. You can use a variable or type the sheet name directly.

**Important:**

-   If the Excel file isn't at the path you gave, the system will make a new one. This new file will have your Data Table data in the sheet you named.
-   If the Excel file already exists, it needs to have the sheet name you specified.
-   The column names from your Data Table variable go into the first row of the Excel sheet.
-   The actual data starts on the second row of that Excel sheet.

## Parameters Explained

**Step name** (Optional)

-   A custom name for this step in your process. This helps you find the step in the editor.
-   Example: `Save Customer Data to Excel`

**Datatable variable name** (Required)

-   The name of the Data Table variable that holds the data you want to save.
-   Example: `myCustomerDataTable`
-   When to use it: Always pick a Data Table variable that already has data in it.

**File Path** (Required)

-   The full path to the Excel file.
-   Example: `C:\Reports\CustomerData.xlsx` or a variable like `excelFilePath`
-   When to use it: Tell the system where to create or update the Excel file.

**Sheet name** (Required)

-   The name of the sheet inside the Excel file where the data will be written.
-   Example: `Customer List` or a variable like `reportSheetName`
-   When to use it: Choose which sheet will get the Data Table's contents.

## Related Articles

-   [Excel To Data Table Step](https://docs.robotiq.ai/en/article/excel-to-data-table-step) - Learn how to load data from an Excel file into a Data Table variable.
-   [Open Excel File Step and Close Excel File Step](https://docs.robotiq.ai/en/article/open-excel-file-step-and-close-excel-file-step) - See how to open and close Excel files.
-   [Define Variable Step - Robotiq.ai Help Center](https://docs.robotiq.ai/en/article/define-variable-step) - Learn how to make new variables for your processes.

## Need Help?

Can't find what you're looking for? Join the [Robotiq Community](https://community.robotiq.ai/home/) to get help from other users and the Robotiq team.

![](https://cdn-assets.productfruits.com/ce18a1ec-96fc-4d85-aa7a-d314476d6f3f)