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:
| Preset | Finds |
|---|---|
| Email addresses | name@domain.tld |
| URLs | http:// and https:// links |
| Phone numbers | Flexible international formats |
| #hashtags and @mentions | Unicode-friendly; note that values like #FF5733 (colour codes) also match |
| Dates | MM/DD/YYYY, DD-MM-YYYY, YYYY-MM-DD |
| 24-hour time | HH:MM, optional seconds |
| Custom regex | Your 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)
| Before | After: Email addresses, delimiter ,, unique |
|---|---|
Call asha@acme.io re invoice | asha@acme.io |
cc: ops@acme.io, raj@acme.io; ops@acme.io | ops@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:
- Copy the source column.
- Paste it next to the original (Paste special → Values only).
- 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/2026is ambiguous. The preset readsMM/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
DATEVALUEif your locale differs.
Step by step: emails from form comments
- Duplicate the tab with your form responses.
- Copy the comments column into an empty column as values.
- Select the copied cells. Open Extract.
- Choose Email addresses, type
,in Delimiter, tick Unique matches only, click Apply. - 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:
- A2: Email addresses, delimiter
,→ravi@example.com, ops@example.com - A3: URLs →
https://example.com/docs - 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.
| Cell | Preset | Expected |
|---|---|---|
| A2 | Email addresses | ravi@example.com, ops@example.com |
| A3 | URLs | https://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
-
What happens to the original text after Extract?It is replaced by the matches. Work on a copy of the column.
-
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.
-
How do you get one email per line inside the cell?Leave the delimiter empty; newline is the default.






