Extract Links & Domains from Excel Text

Need to extract links from Excel cells filled with text, notes, and descriptions? You can use Excel’s native features and formulas to find URLs manually, or extract them in one click with XLclick Extract Links.

Download Excel Add-in

Whether you need complete URLs for research or domain names for analysis, XLclick makes it easier to turn messy spreadsheet data into a clean, organized list.

Excel offers ways to manipulate text and extract URLs, but the best method depends on your data structure. Formulas can require complex logic, while manual copying becomes tedious when processing hundreds or thousands of rows.

FeatureNative Excel MethodsXLclick Extract Links
Ease of useMultiple steps or custom formulasOne-click extraction workflow
URL extractionRequires formulas, scripting, or manual workAutomatically extracts links from text
Extraction optionsCustom logic for different URL formatsFull URL or root domain
Output locationHelper columns and copying may be necessaryNew column, selected cells, or new sheet
Original dataSome workflows can overwrite existing cellsPreserve source data with new-sheet output
PreviewManual checking of formula resultsLive preview of the first five results

Which option makes more sense? Native Excel methods work well for simple, predictable data. XLclick is designed for faster, repeatable link extraction, helping you reduce manual work and keep the original content intact when you choose a separate destination.

Free Methods to Extract URLs in Excel

You can extract links from Excel without installing an add-in. Here are three approaches worth knowing, along with their limitations.

1. Extract URLs with Excel Formulas

If your text follows a predictable structure, formulas can help isolate a URL. In Microsoft 365, functions such as TEXTAFTER, TEXTBEFORE, and TEXTSPLIT can process text around known separators. However, extracting arbitrary URLs requires more advanced logic.

How to do it:

1. Add a helper column next to your source data.

2. Identify a consistent pattern, such as URLs always appearing after a label.

3. Create a formula that extracts the relevant text.

4. Fill the formula down and review the results.

Important limitation: URLs vary in length and structure. A formula designed for one pattern may fail when links appear in the middle of sentences, contain query parameters, or have different prefixes. There is no single simple formula that reliably extracts every possible URL from arbitrary text.

2. Use Find and Replace for Known URL Patterns

Excel's Find and Replace feature can help clean up URLs when you already know which text needs to change.

How to do it:

1. Select the relevant cells.

2. Press Ctrl + H.

3. Enter the text you want to find and its replacement.

4. Review the selected range before choosing Replace All.

Important limitation: Find and Replace modifies matching text; it does not automatically identify and extract every URL into a separate list. Broad replacements may also change unrelated content or damage links if used carelessly.

For more advanced workflows, a VBA macro can loop through cells and retrieve hyperlink addresses. This can be useful when your worksheet contains clickable hyperlinks whose destinations differ from their displayed text.

How to do it:

1. Open the Visual Basic Editor in Excel.

2. Create a macro that loops through the required range.

3. Read each cell's hyperlink address and write the result to another column.

4. Test the macro on a copy of your workbook before using it on important data.

Important limitation: VBA requires coding knowledge and may be restricted by your organization's security settings. Hyperlinks stored as actual hyperlink objects also differ from plain URLs written inside cell text, so the macro must account for the type of data you're processing.

Extract Full URLs or Domains with XLclick

URLs buried inside Excel cells, mixed with notes and descriptions? Extract Links pulls every web address into a clean separate column — full URL or domain only, your choice.

Extract Links Settings

To open Extract Links, go to the XLclick tab, find the Fix and Clean group, then click Extract > Links.

The panel walks you through three steps:

1. SELECT DATA — Click Select and highlight the cells containing text with embedded URLs.

2. EXTRACT MODE — Choose what to pull out:

  • Extract root domain — returns only the domain name (e.g. example.com), useful for grouping and analysis.
  • Extract full URL — returns the complete web address including path and parameters (e.g. https://example.com/page).

3. DESTINATION — Choose where to output the extracted links:

  • Write results in a new column to the right — preserves your original text.
  • Overwrite selected cells — replaces content with extracted links.
  • Write results to a new sheet — sends output to a fresh tab.

The LIVE PREVIEW shows the first 5 results. Click Extract Links to run, or Cancel to exit.

A content marketer had a spreadsheet of 500 blog post notes, each cell containing descriptions with source URLs mixed in. She needed a clean list of all links referenced across the content — but extracting them one by one would have taken most of her day.

Extract Links with Extract full URL selected pulled every URL from the notes into a new column instantly. She had a complete link list ready for her SEO audit in under a minute.

A Freelance Analyst Grouping Traffic Sources by Domain

A freelance data analyst received a raw export of referral traffic where each row had a full URL in the source field. His client needed a pivot table grouped by domain — but you can't group by full URLs. Converting 2,000 URLs to root domains manually was not an option.

Using Extract Links with Extract root domain, he output a clean domain column to the right in seconds. The pivot table was built and delivered the same morning.

A small business owner kept product sourcing notes in Excel — each cell contained a mix of supplier name, product details, and a website link. She needed all the supplier URLs in one organized column before sending the file to her procurement partner.

Extract Links pulled every URL from her notes cells in one click. Choosing Write results to a new sheet kept her original notes untouched and gave the partner a clean, separate link list.

A marketing agency exported backlink data from an SEO tool. The referring page column contained full URLs with long paths and query strings, but the client report only needed the referring domains. Manually trimming thousands of URLs was out of the question.

Running Extract Links with Extract root domain processed the entire column instantly. The cleaned domain list went to a new column and was ready for the client report within minutes.

A researcher maintained a spreadsheet of notes and references where each row contained a paragraph of text with a source URL embedded inside. She needed all links extracted and organized before submitting a report — but the URLs were buried at different positions in each cell.

Extract Links found and extracted every URL regardless of its position in the text. Using Write results to a new sheet gave her a clean reference list without altering the original notes.

Author Image
Federico Magni SEO Specialist since 2012

Excel has always been my laboratory. After years of navigating data-heavy workflows, I created XLclick: the definitive add-in that simplifies complex analysis into a single click. It’s built for pros who want to spend less time on spreadsheets and more time on strategy.