Login / Sign up
Table transformations

How to extract a domain from email in Excel

2026-06-20
Task

A table contains email addresses, and another system needs only the domain part: for example, example.test instead of Buyer@Example.TEST.

Short answer

In the final domain column, use email as the source and apply three rules: remove before @, remove @, then lowercase.

Before / After

Before

source data
idemail
1001Buyer@Example.TEST
1002sales@Store.FR

After

result
iddomain
1001example.test
1002store.fr

Where to Open Settings

  1. Opening the domain column settings in Eofferix
    Open the settings under domain; the source column is email.

How to Do It in Eofferix

  1. Add a transformation: condition Contains substring, value @, action Remove before.
    Rule that removes text before @
    After this rule the value becomes @Example.TEST.
  2. Add the next rule: condition Contains substring, value @, action Remove substring.
    Rule that removes @ from the value
    This leaves only the domain text.
  3. Add the final rule: condition Any, action Lowercase.
    Rule that converts the domain to lowercase
    The final domain is normalized to lowercase, for example Example.TEST becomes example.test.
  4. Save the column settings, save the template, then on the final step run the transformation.

Process data faster with Eofferix

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

Sign up