Extract Domain from URL
Extracts the domain part from a URL.
=REGEXEXTRACT(A2, "^(?:https?:\/\/)?(?:www\.)?([^\/]+)")Learning Resources
Want to master Excel? Check out this Top-Rated Course.
How to Extract Domain from URL
For SEO specialists and marketers, extracting the root domain (e.g., "google.com") from a full URL (e.g., "[https://www.google.com/search?q=](https://www.google.com/search?q=)...") is a daily task.
Why not use LEFT/RIGHT?
Using standard text functions is difficult because URLs vary in length. Some start with HTTP, some with HTTPS, and some have "www".
This tool uses a Regular Expression to ignore the protocol (http://) and the "www" prefix, capturing only the core domain name immediately following them.
Pro Tip
If you need to extract the full path or specific parameters, consider using the SPLIT function with "/" as the delimiter.
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More