Keep subdomains
=REGEXEXTRACT(A2,"^(?:https?://)?([^/]+)")Keeps www or another subdomain.
PASTE-READY RECIPE
Extract the Domain from a URL in Google Sheets
Turn a full URL into a clean hostname without the protocol, path or query string.
QUICK ANSWER
The formula and where it fits.
Turn a full URL into a clean hostname without the protocol, path or query string. Use =REGEXEXTRACT(A2,"^(?:https?://)?(?:www\.)?([^/]+)"), then replace the sample ranges with the columns in your sheet.
The captured group stops at the first slash after the hostname.
- Put the source data under one header row.
- Paste the formula into an empty result cell.
- Change the ranges and criteria to match your sheet.
- Check the result against one row you can verify manually.
TRY ITEdit the table.
Edit the table.
Watch the result change.
| A | |
|---|---|
| 1 | URL |
| 2 | |
| 3 | |
| 4 |
FORMULA OUTPUTexample.com · sheetsteps.com · docs.google.comRecalculates from the input cells above
VARIATIONS
Use the version that fits your sheet.
Remove www only
=REGEXREPLACE(REGEXEXTRACT(A2,"^(?:https?://)?([^/]+)"),"^www\.","")Keeps other subdomains.
Whole column
=ARRAYFORMULA(IF(A2:A="","",REGEXEXTRACT(A2:A,"^(?:https?://)?(?:www\.)?([^/]+)")))Applies the extraction down the column.
COMMON ERRORS
When the result looks wrong.
A URL contains leading spaces
Wrap the source in TRIM.
A protocol other than HTTP is present
Extend the opening pattern when mailto or ftp inputs are expected.
QUESTIONS
Answers before you paste.
A URL contains leading spaces
Wrap the source in TRIM.
A protocol other than HTTP is present
Extend the opening pattern when mailto or ftp inputs are expected.
MAKE IT YOURS
Adjust this formula →Change the ranges, labels or criteria.
Send this recipe to the SheetSteps assistant and describe how your columns are arranged.