Excel: Sheet to dictionary

Convert a sheet's data to a dictionary.

Help Centre › Building Processes

Convert a sheet's data to a dictionary.

Runs on: macOS and Windows only.

Add it to a process

In the process designer, open the Add step tab. Find Sheet to dictionary under Excel › Export, or type its name in the search box, and drag it onto the canvas.

Fields

FieldRequiredWhat it does
File pathNoEnter the file path, or use a variable such as {folder::desktop::path}\file.xlsx.
SheetYesName of the sheet in the Excel file. Supports wildcards: * matches any characters.
VariableNoName of the variable where the result will be stored

See all Excel steps.

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or go live in 7 days.