How to turn CSV strings into JSON objects

Problem

There is a CSV with products. You need to get a JSON array, where each line will become an object.

Short answer

Use a JSON editor: select the desired node, set transformations and upload the result to the target structure.

Sample task

The data below is educational. They show the conversion form, not the users' actual files.

It was

sku,name,price
SKU-1,Product 1,1200
SKU-2,Product 2,900

It became

[
  { "sku": "SKU-1", "name": "Product 1", "price": 1200 },
  { "sku": "SKU-2", "name": "Product 2", "price": 900 }
]

How to set up

1. Upload CSV or XLSX as a table source.
2. Open the table editor and check that the column headings are recognized correctly.
3. In the settings of the desired column, open the block "Transformations".
4. If the entire line must be excluded, set the rule in a block "Unloading conditions".
5. Save the settings and download the result in the desired format.