Parse Excel File to JSON Flow Step

Use the Parse Excel File to JSON flow step to output JSON from a supplied Excel file.

This flow step supports .xls, .xlsx, .xlsb, and .csv file types.

Step Inputs

In the Edit Step menu, you can add details about the step configuration as needed for your flow.

• File ID: Required. Enter an expression that evaluates to the ID of the Excel file you want to parse.

• Worksheet: Enter the name of the worksheet your data is on. Only 1 worksheet can be parsed at a time. If left blank, the first worksheet will be used.

• Has Header Row: Enable this if your Excel data includes a header row.

• Starting Row Number: Enter the row number where your data starts. It will default to starting from row 1 if no value is entered.

• Columns To Include: Enter a comma-separated list of columns to include from your Excel data. If left blank, all columns will be included. If your data doesn’t have a header row, you can use numbers to indicate which columns to include. When doing so, the JSON will be output with property names like column1, column2, etc.

Step Outputs

The output of the step is a JSON object representing the Excel file.

Was this helpful? Give us feedback.