Write data to a Excel sheet step

# What to use the Write data to an Excel sheet step for

Use this step to output data generated by your automations into an Excel sheet.

You can use this step to:

  • Write scraped data to an Excel sheet.
  • Transfer data stored in CSVs into an Excel sheet.
  • Output reporting data into an Excel sheet.

# How to configure this step

# Spreadsheet

Enter a URL for the sheet that you wish to write to, or enter the name in the search box.

# Sheet name

The name of the sheet within the workspace to write data to.

# Data

The data token that contains the data that you wish to write to the Excel sheet.

# Write options

Add to existing data: write data to the next available row within your sheet.

Clear data before writing: clear the spreadsheet, and then write the data into the newly cleared spreadsheet.

# Starting cell

The cell that you wish to start writing on. Note: failure to change this will cause the cell to be re-written during subsequent runs.

# Write method

To write formulas, set this option to "User entered".

Prev: Reference