'Convert a spreadsheet to JSON' Tool step

Use a Tool step to convert CSVs and XLSXs into JSON

The ‘Convert a spreadsheet to JSON’ Tool step allows you to convert a CSV or XLSX file into JSON for your Tools to use.

Add the ‘Convert a spreadsheet to JSON’ Tool step to your Tool

You can add the ‘Convert a spreadsheet to JSON’ Tool step to your Tool by:

1. Creating a new Tool, then searching for the ‘Convert a spreadsheet to JSON’ Tool step
2. Click ‘Expand’ to see the full Tool step
3. Add the CSV or XLSX file you want to convert to JSON
4. Click ‘Run step’ to run the Tool step
5. Your output will be formatted - click ‘Formatted’ to see the JSON output if needed

Using the Tool output

The output is a dictionary with a key rows.

• spreadsheet_to_json[rows] is a list containing as many rows as included in the uploaded file.
• Each row is a dictionary representing one row of data (i.e. keys are column headers in the uploaded spreadsheet).

Below you can see samples where the default name assigned to the step spreadsheet_to_json is used.

spreadsheet_to_json.rows
spreadsheet_to_json.rows[0]

Common errors

Unsupported file type

The error message similar to the one below indicates that a non-spreadsheet file was uploaded to the Tool step. Only CSV and XLSX files are supported. Unsupported file type: pdf

CSV files added to an agent’s Context are displayed as scrollable tables in the builder, so you can verify the data before running the agent. For structured processing, this tool step converts the file to JSON that your tools can use.