# XLSX Module
#### Definition
The **XLSX** utility module, a standard **Skyone Studio** module available for use in any flow, was created to convert data between JSON and XLSX (Excel) formats using Base64-encoded files.
The **XLSX** module consists of two operations:
* **Convert JSON to XLSX**
* **Convert XLSX to JSON**
***
#### XLSX Module Configuration
The **XLSX** module appears under the **Tools** option when editing a flow.\
When added to a flow, it provides two operations:
* **Convert JSON to XLSX**: Converts JSON content into an XLSX file, returning the result in Base64.
* **Convert XLSX to JSON**: Converts a Base64-encoded XLSX file into JSON format.
***
#### Convert JSON to XLSX Operation
This operation allows you to convert **JSON** content (such as API responses, product lists, customer data, etc.) into **XLSX** format, enabling the generation of Excel spreadsheets from structured data.
**How to use**
1. Open your integration flow.
2. Select the **Convert JSON to XLSX** operation.
3. Click **Save**.
4. When editing the module, the variable configuration area will be displayed.
***
**Configuration fields**
**Worksheet name**
Enter the name to be assigned to the generated XLSX worksheet.
**JSON**
Provide the JSON-formatted content to be converted.
If preferred, click the plus icon **( + )** to configure a **SMOP** or use data coming from another module in the flow (for example, an API response).
**Converted XLSX (Base64)**
After clicking **Validate**, the generated XLSX file will be displayed in Base64 format.
{% hint style="info" %}
The module does not provide a direct download of the XLSX file. The result is always generated in Base64.
{% endhint %}
***
**Using the generated Base64**
The returned Base64 can be:
* Saved for later use;
* Used directly in the application response;
* Converted into a physical file using:
* **JSONata**
* Transformations in the **Data Transformation** module
* External implementations that consume Base64
**Example of use in the flow response**:
* Drag the parameter generated by the XLSX module into the **Return** module.
* Define a name for the field.
* The Base64 value will be available as the API output.
***
#### Convert XLSX to JSON Operation
This operation allows converting a Base64-encoded XLSX file into JSON format, enabling the reading and manipulation of spreadsheet data within the flow.
**How to use**
1. Select the **Convert XLSX to JSON** operation.
2. Click **Save**.
3. When editing the module, the variable configuration area will be displayed.
***
**Configuration fields**
**Worksheet name**
Enter the name of the worksheet that will be used to read the XLSX file.
**XLSX (Base64)**
Provide the content of the XLSX file encoded in Base64.
This field accepts Base64 only, including files generated by the XLSX module itself.
**XLSX converted to JSON**
After clicking **Validate**, the worksheet content will be displayed in JSON format.
***
#### Parameters
Each operation of the **XLSX** module provides a parameter corresponding to the conversion result:
* **Convert JSON to XLSX** → returns an **XLSX Base64**
* **Convert XLSX to JSON** → returns a **JSON**
These parameters:
* Are available on the left side of the configuration modal;
* Can be used in subsequent modules in the flow;
* Can be manipulated by the **Data Transformation** module or by **SMOPs**.
***
#### Final considerations
The **XLSX** module was designed to simplify conversion between **JSON** and **Excel**, following the **Base64** usage standard adopted by **Skyone Studio**.
Currently supported:
* **JSON → XLSX**
* **XLSX → JSON**
To finalize the module configuration, click **Save**.
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.skyone.cloud/english/skyone-studio/integrations/flows/tool-modules/xlsx-module.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.