Google Sheets formula builder
REGEXEXTRACT Formula Builder
Create a Google Sheets REGEXEXTRACT formula from a source cell and a predefined or custom regex pattern.
Builder inputs
Choose a pattern type or enter a custom regular expression.
=REGEXEXTRACT(A2, "^(?:https?:\/\/)?(?:www\.)?([^\/\?#]+)")REGEXEXTRACT is a Google Sheets function. In Excel, use TEXTAFTER, TEXTBEFORE, or Power Query for many text extraction jobs.How this formula works
- REGEXEXTRACT returns the first captured group from the pattern.
- The domain pattern ignores http, https, and www prefixes.
- Custom patterns are inserted directly, with double quotes escaped for formula safety.
Sample data
| URL | Result |
|---|---|
| https://www.example.com/pricing | example.com |
| https://docs.google.com/spreadsheets | docs.google.com |
| https://support.example.com/examples | support.example.com |
Common mistakes
- Patterns need a capturing group when you want only part of the text.
- Backslashes must be preserved when writing custom regex patterns.
- Excel does not have REGEXEXTRACT in older desktop builds.
Related formulas
FAQ
Are these formulas generated with AI?
No. The builder uses built-in spreadsheet rules in your browser and does not call an AI service.
Do I need to upload my spreadsheet?
No. Enter ranges and criteria manually. The site does not upload, store, or process spreadsheet files.
Can I copy the generated formula?
Yes. Each output includes a copy button so you can paste the formula into Excel or Google Sheets.