Skip to content

Flow action Format JSON as Excel

Arie J. Godschalk edited this page Nov 15, 2026 · 1 revision

Format JSON as Excel

Home · Flows · Actions

Purpose

Converts JSON into Excel workbook data and returns a result tag.

Arguments

Argument What to enter
json (JSON) Valid JSON; an array of records is a useful shape for tables.
returnType (Excel) Output format; Base64 is encoding, not encryption. Choices: Excel (base64).
schema (Schema) Optional Excel schema for columns, value mapping, and types. Use only a schema you trust.
defaultDate (Default Date) Excel date format for date cells.
stickyRowsCount (Sticky Rows) Number of top worksheet rows to keep visible.
sheetName (Sheet name) Optional worksheet name.

Outputs

Token Type Meaning
result string Excel

How it works

BLL can infer columns from object keys or use an optional schema. Set date format, sticky rows, and sheet name as needed.

Example

Prerequisite: Install Better Logic Library and create the Flow described below. Enter [{"room":"Kitchen","temperature":21.4}], select Excel (base64), and connect the result to a card that accepts Base64 workbook data. Leave Schema blank for inferred columns.

Limitations and tips

The schema is evaluated by the current implementation; only use schema text you trust. Input must be valid JSON.

Related guides

Clone this wiki locally