A JSON object has optional nodes such as an empty description. The result should not contain description as an empty string; the key should be removed entirely. In the description value settings, open Export condition...
Clean CSV or XLSX product descriptions by removing p, br, strong, and other HTML tags.
Convert XML attributes such as id and code into regular CSV or XLSX columns.
Turn comma- or semicolon-separated values in one table cell into separate result rows.
Collect values from repeated rows into one cell using SKU or another grouping key.
Create a slug column for a site catalog: Latin characters, hyphens instead of spaces, and no extra symbols.
Skip rows where a required value, for example SKU, is missing before exporting CSV or XLSX.
Skip several specific SKUs or brands before importing a supplier file into your catalog.
Filter supplier rows by a clear attribute: brand, category, status, or another column value.
Turn values like 1 250,50 EUR or 99.90 USD into separate price and currency columns.
Use the email column as the source, remove everything before @, remove @ itself, then convert the remaining domain to lowercase.
Use a regular expression to keep only the email address from a text comment and write it to a separate column.
Clean product descriptions with mixed casing: convert the text to lowercase, then capitalize only the first letter.
Normalize mixed-case product names so every word starts with an uppercase letter.
Filter out section headers, totals, and technical rows by requiring a non-empty SKU.
Example: turn “Furniture > Chairs [chairs]” into “chairs” with a regular expression and value transformation rules.
Two replace rules in the XML editor turn 1 200,50 into 1200.50 and exclude zero-price items.
If the receiving system expects different JSON key names, rename result nodes in the template and leave the values unchanged.
To keep disabled records out of CSV, add an export condition by the active flag and apply it to the whole record.
Choose a JSON source and CSV output. Open the Items sheet, move it to the first position, save the template, then run the transformation.
Choose a JSON source and CSV output. In the table snapshot, keep the original JSON paths as sources and rename only the final column headers.
How to extract EAN or UPC from a supplier value, preserve leading zeroes, remove labels, and check barcode length.
How to extract a SKU from a supplier value, keep letters and separators, convert it to uppercase, and avoid breaking product codes.
A practical example: find a phone number in a text value, choose a regex preset, keep the matched number, and normalize it.
Create a free account and use larger files, saved scenarios and team workflows.
