> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.itential.com/itential-platform/2023-2/studio/tasks/reference/excel-to-json/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.itential.com/_mcp/server.

# excelToJson

> Use the exceltojson task to convert a Base64-encoded Excel file to JSON format.

The `excelToJson` task converts a Base64-encoded Excel file to JSON format.

## Properties

| Incoming          | Type    | Description                                            |
| :---------------- | :------ | :----------------------------------------------------- |
| `input`           | String  | Required. The Base64-encoded Excel content to convert. |
| `headersIncluded` | Boolean | Required. Whether the input includes headers.          |
| `headerRow`       | Array   | Optional. An array of headers to use for mapping.      |

| Outgoing   | Type   | Description                                      |
| :--------- | :----- | :----------------------------------------------- |
| `response` | String | The spreadsheet values converted to JSON format. |

## How to configure

In this example, an Excel spreadsheet is uploaded as the workflow input. The `input` reference variable is the uploaded spreadsheet (static), and `headersIncluded` is set to `true`.

You can convert an Excel spreadsheet to Base64 format using an online converter tool of your choice.

![](/_fern-img/a04d1192a57b103e87bb97d69f0505673fb7140d369b2c03d28723ba7562ad4a.webp)

The `response` returns the spreadsheet values in JSON format. View the outgoing properties in **Job (Operations) Manager** after the task completes.

![](/_fern-img/bb0e5ac8df048a47a2a8e5b2d604bbe65c6dd05fab5c706bf3b4544ba78a6bf2.webp)

## Potential use case

Suppose you are building a workflow and need to convert user inputs to JSON. Instead of filling out a JSON form to provide job variable inputs, you can upload a spreadsheet with the workflow input variables. After the spreadsheet values are converted to JSON with `excelToJson`, the variables can be queried from the output and used in further tasks.

## References

For related information, see the [excelToJson API reference](https://apidocs.itential.com/2023.2/api/app-workflow_engine/excelToJson/).

> Use the exceltojson task to convert a Base64-encoded Excel file to JSON format.