In this article:

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

May 8, 2024

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

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->