Skip to main content

Mapping: Excel to JSONL

Read a sheet from an Excel file and convert each row into a JSON line. Useful to turn a spreadsheet into a streamable JSONL file that can be sliced, filtered or piped into another mapping.

Input​

Excel filerequired
Source Excel file to read from.

Parameters​

Sheet namerequired

Name of the tab to read inside the source Excel file (ex: Orders).

Start row

The first row to read from the sheet. Rows are numbered from 1. Leave empty to start from the first row. Useful when the file has a header row to skip.

Column mappingsrequired

For each Excel column you want to keep, configure:

  • Column: the Excel column letter (ex: A, B, AC).
  • JSON key: the key the cell value will be written under in the generated JSON object. Dot-notation is supported to create nested objects (ex: customer.email).
  • Type: how to interpret the cell value. Supported types:
    • Text
    • Number
    • Boolean

Output​

JSONL file

Generated JSONL file — one JSON object per row read from the sheet, restricted to the configured column mappings. Each emitted object also carries an auto-generated uuid field.