REGEXMATCH & REGEXEXTRACT in Google Sheets (Easy Guide)
Got messy contact data in one column? Learn how to use REGEXMATCH and REGEXEXTRACT in Google Sheets to pull out clean emails, phone numbers, and domains in seconds.
In this step-by-step tutorial, we start with free-form contact strings (names, emails, and phones jammed together with random delimiters like dashes, commas, slashes, pipes, and colons) and end with four clean columns: a .com flag, the email, the phone number, and the domain — all powered by regex formulas wrapped in ARRAYFORMULA.
You'll learn the exact regex patterns for matching .com addresses, extracting emails with [\w.]+@[\w.]+, pulling phone numbers with \d{3}-\d{3}-\d{4}, and using capture groups to grab just the domain.
⏱ Timestamps:
0:00 - Intro
0:05 - Name the spreadsheet
0:09 - Type the Raw Contact header
0:12 - Enter first two contact rows (different delimiters)
0:17 - Bulk-fill remaining contact rows
0:20 - Review the messy contact list
0:30 - Add 'Has .com?' header and REGEXMATCH formula
1:03 - Add Email header and REGEXEXTRACT email formula
1:29 - Add Phone header and REGEXEXTRACT phone formula
1:57 - Add Domain header and REGEXEXTRACT capture-group formula
2:26 - Final review — messy column on left, four clean columns on right
If you found this helpful, smash that like button and subscribe to Hablo Tech for more Google Sheets tutorials that turn messy data into clean, usable spreadsheets!