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​

  • source (File): The Excel file
  • sheet name (String): The name of the sheet in the Excel File (defaults to the first one)
  • range (String): A specific range within the Excel sheet to read from. If not specified, the entire sheet is processed.
    Ex.: 'A1:F4'

Outputs​

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