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 file—REQUIRED

Source Excel file to read from.

Parameters

Sheet name—REQUIRED

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 mappings—REQUIRED

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.