A common task is needing to [find all email addresses in a Google Sheets spreadsheet](/content/blog/find-email-addresses-links-images/index.html). This usually happens when a spreadsheet is shared with you after it’s already been formatted and populated and you need to extract all email addresses from it. This can be pretty time consuming if you have to do it manually. Using the Add to Sheets extension, you can easily extract all email addresses from a Google Sheets spreadsheet in just a few clicks.

## [Find email all addresses in Google Sheets](/content/blog/find-email-addresses-google-sheets/#find-email-all-addresses-in-google-sheets/index.html)

In Add to Sheets Pro, you can use the **Pattern Finder** feature to extract all email addresses from websites in seconds, including email addresses from a Google Sheet spreadsheet. Here’s how to do it:

1. Install the [Add to Sheets Chrome extension](https://chromewebstore.google.com/detail/hgilhmbegaanegfbcppneigcmhgoinib) from the Chrome Web Store.
2. Open the Google Sheet spreadsheet that you want to extract email addresses from.
3. Click on the Add to Sheets icon in the Chrome toolbar.
4. Log in with Google if you haven’t already.
5. Click on **Find matches** in the extension in the **Matches** section.

6. In the **Pattern Finder** section, select the **Email** pattern.

7. Click on **Find a pattern > Email Addresses**

The extension will automatically extract all email addresses from the Google Sheets spreadsheet and display them in the **Matches** section.

Extracted email addresses from a Google Sheets spreadsheet. The line numbers are shown because the **Show line numbers** option is enabled in the extension settings.

## [Duplicate email addresses](/content/blog/find-email-addresses-google-sheets/#duplicate-email-addresses/index.html)

If you have duplicate email addresses in the Google Sheets spreadsheet, the extension will only extract each email address once. This means that you won’t have to worry about removing duplicates from the extracted email addresses.

## [Sorting email addresses](/content/blog/find-email-addresses-google-sheets/#sorting-email-addresses/index.html)

The extension does not sort the extracted email addresses. Why? Because Google Sheets is a powerful tool for sorting and managing data. If you need to sort the email addresses, you can configure the extension and [save them to Google Sheets](/content/blog/how-to-save-data-to-google-sheets/index.html) to use the built-in sorting features of Google Sheets.

## [New email addressed added to the Google Sheet](/content/blog/find-email-addresses-google-sheets/#new-email-addressed-added-to-the-google-sheet/index.html)

If new email addresses are added to the Google Sheets spreadsheet after you’ve extracted email addresses from it, you’ll need to **refresh the page (`CMD + Shift + R`)** and **click on Find matches again** to extract the new email addresses. This is because the extension needs to load on the page to be able to extract data from it.

## [Learn how to extract emails from a website](/content/blog/find-email-addresses-google-sheets/#learn-how-to-extract-emails-from-a-website/index.html)

If you’re looking to extract email addresses from any website, you can use the **Pattern Finder** feature to extract email addresses from a website in seconds.

See how to extract email addresses from a website in the video below:

Find All Email Addresses, Links, and Images on Websites in Seconds - YouTube

[Find All Email Addresses, Links, and Images on Websites in Seconds](https://www.youtube.com/watch?v=jmXbnxH5uiM) [Add to Sheets Chrome extension](https://www.youtube.com/channel/UCF9gWe23jTlDKHiqHn1gYYQ)

## [Getting started](/content/blog/find-email-addresses-google-sheets/#getting-started/index.html)

To get started, you’ll need to install the extension from the Chrome Web Store if you haven’t already. You can find the extension by visiting the [Add to Sheets Chrome Web Store page](https://chromewebstore.google.com/detail/hgilhmbegaanegfbcppneigcmhgoinib).