Table editor
How to Split Price and Currency from One Cell
Split price and currency from one cell when supplier data stores the amount as text.
Use cases — Page 7
Table transformations
How to extract a domain from email in Excel
Extract the domain from an email address for grouping contacts, checking suppliers, or CRM import.
Table transformations
How to extract an email address from text in Excel
Extract an email from free text into a separate column when contacts are hidden inside comments or descriptions.
Table editor
How to Capitalize the First Letter of a Product Description
Normalize product descriptions when supplier text starts lowercase or arrives fully uppercased.
Table editor
How to Convert Excel Product Names to Title Case
Normalize product name capitalization when supplier rows arrive uppercased or fully lowercase.
Table editor
How to Remove Rows Without SKU from a Supplier Price List
Remove supplier service rows without SKU so the final price list contains only real products.
Transformations
How to extract the text inside brackets and remove everything else
Keep the value inside brackets and remove the rest when a code or category is hidden in a text string.
XML
XML: how to normalize supplier price with spaces and comma
Two replace rules in the XML editor turn 1 200,50 into 1200.50 and exclude zero-price items.
JSON
How to rename JSON keys without changing values
If the receiving system expects different JSON key names, rename result nodes in the template and leave the values unchanged.
JSON to CSV
How to export only active JSON records to CSV
To keep disabled records out of CSV, add an export condition by the active flag and apply it to the whole record.
Format conversion
How to turn a JSON items array into CSV rows
Choose a JSON source and CSV output. Open the Items sheet, move it to the first position, save the template, then run the transformation.
Format conversion
How to flatten nested JSON into CSV columns
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.
Transformations
How to extract a barcode from text with a regular expression
Extract a standalone 8- or 12–14-digit barcode candidate from text, preserve a leading zero, and reject fragments of longer digit runs.
Interpreter
How to extract a SKU and remove extra characters with a regular expression
Use a regex that matches the real supplier SKU format, keep the match, and only then apply uppercase or other normalization.
Interpreter
How to extract a phone number from text with a regular expression
Find the number with a preset or custom regex, keep the match, then normalize spaces, brackets and hyphens for the CRM format.
Interpreter
How to exclude products with zero price or empty stock
Exclude the entire record when the source price is not positive or the stock value is empty.
Process data faster with Eofferix
Create a free account and use larger files, saved scenarios and team workflows.