Skip to main content

Mapping: JSONL to Excel

Convert a JSONL file into an Excel workbook. Each JSON line becomes a row in the generated sheet; columns are picked explicitly via mappings so the spreadsheet stays in a predictable shape regardless of how many keys the source contains.

Input​

JSONL file—REQUIRED

Source JSONL file — one JSON object per line.

Parameters​

Sheet name—REQUIRED

Name of the tab created inside the generated Excel file (ex: Orders).

Column mappings—REQUIRED

For each column to write, configure:

  • JSON key: the key to read from each source line. Dot-notation is supported to read from nested objects (ex: customer.email).
  • Column: the Excel column letter to write the value into (ex: A, B, AC).
  • Header (optional): a label written on row 1. If at least one mapping has a header, headers are written on row 1 and data starts on row 2; otherwise data starts on row 1.

Output​

Excel file

Generated Excel file containing a single sheet built from the configured mappings.