ysskrishna logoysskrishna

Chapter 5 of 7 · 3 min

Extract emails, URLs, phone numbers and dates

Use the Extract tab's presets to pull patterns out of free text, join multiple matches, and keep only unique values.

Extract finds patterns in each selected cell and replaces the cell's content with the matches. The sidebar has a MATCH PATTERN dropdown, a Delimiter (optional) field ("Leave empty for newline between matches"), a Unique matches only checkbox and Apply.

Built-in presets

From the Marketplace listing:

PresetFinds
Email addressesname@domain.tld
URLshttp:// and https:// links
Phone numbersFlexible international formats
#hashtags and @mentionsUnicode-friendly; note that values like #FF5733 (colour codes) also match
DatesMM/DD/YYYY, DD-MM-YYYY, YYYY-MM-DD
24-hour timeHH:MM, optional seconds
Custom regexYour own pattern (chapter 6)

Delimiter and unique matches

A cell can contain several matches. They are joined with the delimiter:

  • Empty (default): one match per line inside the cell.
  • , : a comma-separated list, good for a CSV export.
  • ; : good for pasting into an email "To" field.

Unique matches only removes duplicates within the cell before joining. Useful when an email appears in both the signature and the body.

Worked example (sample data)

BeforeAfter: Email addresses, delimiter ,, unique
Call asha@acme.io re invoiceasha@acme.io
cc: ops@acme.io, raj@acme.io; ops@acme.ioops@acme.io, raj@acme.io
no contact yet(empty)

Because it replaces in place, keep the original

Extraction is destructive: the notes are gone after Apply. The safe pattern:

  1. Copy the source column.
  2. Paste it next to the original (Paste special → Values only).
  3. Run Extract on the copy.

Now you have the note and the extracted email side by side.

Dates and times

The date preset recognises three layouts. Two warnings:

  • 03/04/2026 is ambiguous. The preset reads MM/DD/YYYY, so in a DD/MM sheet you must check the result.
  • The extracted value is text. To make it a real date, select the column and use Format → Number → Date, or convert with DATEVALUE if your locale differs.

Step by step: emails from form comments

  1. Duplicate the tab with your form responses.
  2. Copy the comments column into an empty column as values.
  3. Select the copied cells. Open Extract.
  4. Choose Email addresses, type , in Delimiter, tick Unique matches only, click Apply.
  5. Use Data → Data clean-up → Remove duplicates across the column if you need one list of unique people.

Practice: one column, three extractions

Sample cell (one cell, typical of a form comment):

Call Ravi on +91 98765 43210 or mail ravi@example.com, docs at https://example.com/docs, cc ops@example.com

Copy it into A2:A4 (three copies), then:

  1. A2: Email addresses, delimiter , → ravi@example.com, ops@example.com
  2. A3: URLs → https://example.com/docs
  3. A4: the phone number preset → the phone number, in the format the preset recognises.

Turn on Unique matches only and paste the same email twice in the cell to see the duplicate disappear.

CellPresetExpected
A2Email addressesravi@example.com, ops@example.com
A3URLshttps://example.com/docs

The formula alternative

=REGEXEXTRACT(A2, "[\w.+-]+@[\w-]+\.[\w.]+") returns only the first email, and returns an error when there is none. Getting every match needs a longer formula (for example with REGEXREPLACE or SPLIT), which is where the add-on's global match is simpler.

Quick check

  1. What happens to the original text after Extract?It is replaced by the matches. Work on a copy of the column.

  2. Your hashtag list contains #FF5733. Why?The hashtag preset is Unicode-friendly and matches colour codes too; filter them out afterwards or use a custom regex.

  3. How do you get one email per line inside the cell?Leave the delimiter empty; newline is the default.

Continue exploring

ProductGoogle WorkspaceGoogle Sheets Text Power Tools

Google Sheets Text Power Tools

Fix messy sheet text in place. Case, trim, strip, and extract without leaving the grid.
Google Sheets Text Power Tools
Text & Data Conversion
Google Workspace Add-ons
Google Sheets
ProductGoogle WorkspaceGoogle Sheets Tab Manager

Google Sheets Tab Manager

Your workbook outgrew the tab bar. Clean it up in batches.
Google Sheets Tab Manager
Google Workspace Add-ons
Google Sheets
Google Apps Script
CourseCover image for Table Converter for Google Sheets: Import and Export Markdown, JSON, HTML and CSV

Table Converter for Google Sheets: Import and Export Markdown, JSON, HTML and CSV

Import Markdown, JSON, HTML and CSV tables into Google Sheets without broken columns, and export any range as clean Markdown, JSON, HTML or CSV.

Google Sheets Table Converter
Google Sheets
+1

6 chapters · 16 min

BlogCover image for How to Delete Multiple Tabs in Google Sheets at Once (Bulk Hide, Rename, Sort)

How to Delete Multiple Tabs in Google Sheets at Once (Bulk Hide, Rename, Sort)

Google Sheets Tab Manager
Google Workspace Add-ons
+1
2 min read
ProductGoogle WorkspaceGoogle Sheets Merge Tools

Google Sheets Merge Tools

Repeatable merges in Google Sheets, without the misclick marathon.
Google Sheets Merge Tools
Google Workspace Add-ons
Google Sheets
Google Apps Script
CourseCover image for Sheets Tab Manager: Delete, Hide, Rename, Colour and Sort Tabs in Bulk

Sheets Tab Manager: Delete, Hide, Rename, Colour and Sort Tabs in Bulk

Delete multiple tabs in Google Sheets at once, hide and unhide in bulk, rename with find and replace, colour and sort tabs A–Z with the free Sheets Tab Manager.

Google Sheets Tab Manager
Google Sheets
+1

6 chapters · 24 min