Extract Domain from Email in Google Sheets (Easiest Way in 2023)

Click here to Send an Email From a Lido Spreadsheet

In this article we will show how to extract a domain name from an email address in google sheets in just a few simple steps using REGEXEXTRACT. Simply follow the steps below:

Extract a Domain Name from an Email Address

1. Identify the Cell Containing the Email

For our example, we have two columns: Column A for the name and Column B for the email.

The cells containing the emails in Column B start at B2. We then set Column C as the column for the domains that we want to extract from the emails in Column B.

extract domain from email google sheets

2. Insert Formula =REGEXEXTRACT(cell, "@(.+)")

The formula that we will use to extract the domain from the emails is the following:

=REGEXEXTRACT(cell, "@(.+)")

Where you replace cell with the reference to the cell containing the email. In our example we will change “cell” to B2 in the formula.

=REGEXEXTRACT(B2, "@(.+)")

extract domain name from email google sheets

3. Press Enter

You will now see the domain extracted from the email!

extract domain name from email address google sheets

4. Apply the Formula to Entire Column

In order to extract the domain from all of the emails in the column there are two methods you can follow: 

Click on the cell and double-click the round blue dot to autofill the column with the formula.

auto fill formula

Click on the cell and Click-drag the round blue dot in the lower-right corner of the cell.

auto fill formula

Either way, the results will be the same:

domain names extracted from an email address

You have now successfully extracted a domain from an email in Google Sheets!

Attach a Google Sheet to an Email

Create an Email List in Google Sheets

Send Email from Google Sheets

Tired of constantly monitoring your spreadsheets? Scale operations with Lido automations and free up time to focus on what really matters.