'Convert a spreadsheet to JSON' Tool step

​

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

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

• 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).

spreadsheet_to_json.rows
spreadsheet_to_json.rows[0]

​

Common errors