Skip to main content
Version: Next

Excel To Json

Converts an Excel file to JSON

Description​

Converts an Excel file to JSON. Each line of the Excel file in Sheet Name sheet will be represented as a JSON object.

Example​

(For readability purposes, the Excel file is represented as CSV)


Excel file:

firstname,lastname
john,doe
jane,doe

Resulting JSON:

[
  {"firstname":"john", "lastname":"doe"},
  {"firstname":"jane", "lastname":"doe"}
]

Inputs​

  • Control Flow (Control Flow)
  • source (File): The Excel file
  • sheet name (String): The name of the sheet in the Excel File. If not specified, the first sheet is read.
  • range (String): Where the data should be read from, and optionally where it should be read until. If not specified, the entire sheet is processed. Ex: 'A2' reads from line 2, 'A2:F4' reads from cell A2 until cell F4.

Outputs​

  • Control Flow (Control Flow)
  • output (List): The resulting JSON
  • Error Flow (Error Flow): Error Flow