How to extract emails, URLs, dates, and regex matches in Google Sheets

Copy-pasted spreadsheet data is rarely structured.

Notes, support exports, CRM fields, and shared documents often combine multiple pieces of information inside a single cell. Finding and copying those values manually gets repetitive very quickly.

The Extract tab in Text Power Tools finds matches in selected cells automatically and writes the joined results back in place.

Built-in extraction patterns

The Extract tab includes presets for common data types:

Pattern	Description
Email addresses	Extracts all email addresses found in the cell.
URLs	Extracts HTTP and HTTPS links.
Phone numbers	Extracts common phone number formats.
#hashtags	Extracts hashtag-style values.
@mentions	Extracts mentions while skipping email addresses.
Dates	Extracts dates in supported formats.
Time values	Extracts 24-hour time values.

All matches found inside a cell are extracted and joined together automatically.

Dates are matched by pattern, not by full calendar validation. If a string looks like a date, it may be extracted as one even if the date itself is not meaningful.

Remove duplicate matches

Enable Unique matches only to keep repeated values from appearing multiple times in the output. That helps when the same email address, URL, or identifier appears more than once in the source text.

Control how matches are joined

Use the Delimiter option to control how extracted matches are combined. You can separate matches with commas, place each match on a new line, or use a custom separator. Leave the delimiter empty if you want each match on its own line.

Use custom regex patterns

If the built-in presets are not enough, you can enter your own regex. The add-on runs it with the global flag, so it grabs every match in the cell, not just the first. That is useful for custom identifiers, codes, references, or structured text formats.