How to export only active records from JSON to CSV

2026-05-05
Problem

JSON has active and disabled entries. You only need to unload those where active is true.

Short answer

Use the export table editor: configure the CSV columns and add an export condition based on active.

Sample task

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

It was

[
  { "sku": "SKU-1", "active": true, "price": 1200 },
  { "sku": "SKU-2", "active": false, "price": 900 },
  { "sku": "SKU-3", "active": true, "price": 1500 }
]

It became

sku,price
SKU-1,1200
SKU-3,1500

How to set up

  1. Upload JSON and choose CSV as the result format.
  2. Go to the export table editor. Its rows and columns show the future CSV, and the gear under a header opens column settings.
  3. Open column settings and in the "Export conditions" block choose the condition for the whole row: C. active equals true.
  4. Save the settings and download the CSV.

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up