Join the top marketers who read our newsletter each week:

Join the top marketers who read our newsletter each week.

How to Extract Domain Name from URL in Google Sheets and Excel

Table of Contents

Interested in getting to the next level of Marketing Automation? Learning Python is the single best thing I’ve done that propelled my career to heights I could not imagine before.
Datacamp is a wonderful place to start this journey of yours. It helped me and millions of other people on their Python adventure so I talk from experience when I say that this is the perfect first step you can take to embark on this journey.

Once in a while, I find myself having to retrieve the root domain from a list of URLs that has been collected in an Excel file or a Google Sheets’ spreadsheet.

While scouring the web to look for such an information, I figured I needed to craft my own formula in both software that I could use and reuse every time I needed it. And today is the day where I finally share this formula so that you can all benefit from this time saving little hack.

How to obtain root domain from URL in Google sheets

For Google Sheets, I use this simple formula to extract the domain + subdomain of any URL I have in one cell.

This formula written below examine an URL in the cell A2 and extracts the domain of the URL by removing the inessential parts of the complete URL:

=REGEXREPLACE(REGEXREPLACE(A2,"(http(s)?://)?(www\.)?",""),"/.*","")

In practice, this is how it looks like:

How to obtain root domain from URL in Microsoft Excel

For Microsoft Excel, I use this simple formula to extract the domain + subdomain of any URL I have in one cell.

This formula written below examine an URL in the cell A2 and extracts the domain of the URL by removing the inessential parts of the complete URL:

=IF(ISNUMBER(FIND("www.";A2));MID(A2;FIND("www.";A2)+4;IF(ISNUMBER(FIND("/";A2;9));FIND("/";A2;9);LEN(A2)+1)-FIND("www.";A2)-4);MID(A2;FIND("//";A2)+2;IF(ISNUMBER(FIND("/";A2;9));FIND("/";A2;9);LEN(A2)+1)-FIND("//";A2)-2))

And this is how it looks like:

The formula itself is a bit chunky but this is Excel for you… Google Sheets is definitely more user-friendly and arguably as powerful as Microsoft Excel.

Conclusion

And that’s pretty much it for this article. This is a short one but I believe some of you might find it useful so I figured a quick and dirty article would not hurt. if you’re interested in learning more about how to use Google Sheets, I have a considerable amount of articles on the subject so I suggest you head over to our Google Sheets’ category page and just read on whatever you fancy :).

Join the top marketers who read our newsletter each week.

Yaniss Illoul

Share on twitter
Share on linkedin
Share on facebook
Share on reddit

You might also like these posts:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

HELLO!

Get more tutorials, guides and curated content !

In your inbox, once a week.

wait!

Get more tutorials, guides and curated content !

In your inbox, once a week.