Convert JSON to Excel file
Convert JSON formatted text to an Excel file. This will create an Excel file with one sheet with the provided JSON data in table format.
Application
Inputs (what you have)
| Name | Description | Data Type | Required? | Example |
|---|
| JSON text | JSON text you would like to convert to Excel file. Example: {“Col1”:”value1”,”Col2”:”value2”} | Text (Long) | Yes | {“Col1”:”value1”,”Col2”:”value2”} |
| Flatten nested JSON? | Convert nested JSON objects to columns. If false, will leave nested objected as JSON | True/False | No | true |
| Excel format | Format of output excel file | Text (Short) | No | xlsx |
| Output filename | Optional custom filename for the output Excel file. | Text (Long) | No | sample.xlsx |
Outputs (what you get)
| Name | Description | Data Type | Required? | Example |
|---|
| Converted Excel file | Converted Excel file | File | No | |
Outcomes
| Name | Description |
|---|
| Success | This status is selected if the job has successfully completed. |
Requirements