'Convert a spreadsheet to JSON' Tool step

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