Help Centre › Building Processes
Copy a single source sheet into many destination sheets in one pass.
Runs on: macOS and Windows only.
Add it to a process
In the process designer, open the Add step tab. Find Copy sheet (many) under Excel, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| File path | No | Enter the file path, or use a variable such as {folder::desktop::path}\file.xlsx. |
| Sheet | Yes | Name of the sheet in the Excel file. Supports wildcards: * matches any characters. |
| Position | No | Placement of the new sheets. Defaults to 'last'. Choices: First, Last, Before, After. Default: last. |
| Reference | No | Reference sheet name when position is 'before' or 'after'. |
| Duplicate | No | Collision policy for destination names that already exist. 'overwrite' deletes the existing sheet; 'rename' appends ' (2)', ' (3)', …; 'skip' leaves it alone; '0' (default) errors on first collision. Choices: Overwrite, Rename, Skip, 0. Default: 0. |
| Variable | Yes | Name of the variable where the result will be stored |
See all Excel steps.