Skip to main content
Turns a list of rows into a binary XLSX spreadsheet, the file format used by Microsoft Excel and similar tools. Use this when you need to produce a real spreadsheet file to attach to an email or upload to another system. Give it a list where each item is one row, and each row is itself a list of cell values; those values are written into the first worksheet, left to right, top to bottom. Because the result is a binary file rather than text, you usually pass it straight on to be written to disk or sent as an attachment.

​
Sample data

The result of this mapper is a binary spreadsheet file, not readable text, so there is no text output to show. The input is a list of rows: the first row below holds the column headers, and each following row is one line of data. That data would be written into the cells of the first worksheet. This is a complete example configuration. There are no settings to fill in.
Configuration
{
  "prototype": "serialize-xlsx",
  "parameters": {}
}
Example input (a list of rows): 
[
    ["SKU", "Name", "Price"],
    ["SCARF-01", "Wool scarf", 24.95],
    ["BELT-02", "Leather belt", 39.50]
]
The mapper turns this into a binary .xlsx file whose first worksheet contains the three rows above, with SKU, Name, and Price as the header row.