How to Extract URL From Hyperlink in Excel in Bulk?

In Microsoft Excel, managing hyperlinks can be challenging when dealing with a large data spreadsheet. However, sometimes, you may need to extract URL from hyperlink in bulk to audit links or prepare data for analysis. Well, in this blog, I will cover why you need to extract URLs from hyperlinks and how to extract URL from hyperlink in Excel in bulk.

Quick Navigation:

Why Extract URLs from Hyperlinks in Excel?

How to Extract URL From Hyperlink in Excel in Bulk?

1. Way 1- Extract URL with the Right Click
2. Way 2- Using Insert Menu
3. Way 3- How to Extract URL From Hyperlink in Excel VBA?

Tips to Handle Extracted URLs

Why Extract URLs from Hyperlinks in Excel?

URLs embedded in hyperlinks often contain valuable data. But sometimes, extracting them to enhance the worksheet functionality is necessary. Here are some of the reasons why it is important to extract URLs:

1. Audit for broken links.
2. Analyze the external link performance.
3. Make reports for SEO or other marketing campaigns.

How to Extract URL From Hyperlink in Excel in Bulk?

There is no straightforward method to extract hyperlink URL in Bulk. But in this section, you will learn how to extract URL from hyperlink in Excel using formula, shortcut, or VBA.

So, let’s try them…

Way 1- Extract URL with the Right Click

The very first easy method you can try is extracting the link with the help of Edit Hyperlink menu. For this follow the below instructions carefully:

• Select a cell(s) from which you need to extract the URL.
• After that, right click to select the Edit Hyperlink.

• Now, you will see Edit Hyperlink Simply copy & paste the URL from an Address as before.

Also Read: Uncover the Secrets: Remove Hyperlink in Excel Like a Pro!

Way 2- Using Insert Menu

Many users have reported that using an insert menu they have successfully extracted the hyperlink URL in Bulk so, once you should try this to get your job done.

• Select a cell that holds your hyperlink.
• Next, navigate to Insert tab >> click on Link command from the Links

Note: This will launch the Edit Hyperlink menu that contains both anchor text & address data of your URL.

• At this time, highlight an URL from an Address input within the Edit Hyperlink menu >> press the Ctrl + C shortcut to copy.
• Now, press Esc key to close an Edit Hyperlink
• Choose the new cell & press Ctrl+ V keys together to paste your URL into MS Excel.

Now, you will get a URL from a hyperlink!

Way 3- How to Extract URL From Hyperlink in Excel VBA?

Important note: This method requires technical knowledge to perform.

Running a VBA or macro is another workable method to extract an URL from each hyperlink. However, to save your time & effort, you must use VBA.

Follow the below instructions to create the VBA macro and extract the hyperlinks URL:

• In an opened Excel sheet, press the Alt+ F11 to launch the VBE (Visual Basic Editor).
• Navigate to Insert tab at the top and choose the Module.

• Now, copy and paste the below code to execute:

Sub ExtractURL()

Dim rng As Range

For Each rng In Selection

    rng.Offset(0, 1).Value = rng.Hyperlinks(1).Address

Next rng

End Sub

After running the code, all the hyperlinks will loop in the chosen range & extract an URL from the selected adjacent cell.

But what if you want to extract URL’s from multiple hyperlinks? Do not worry just follow the below steps:

• Select the cell range from which you need to extract a URL.
• Then, press Alt+ F8 keys to open a Macro dialogbox menu to choose & run the macro.
• Now, select ExtractURL macro >> hit on Run.

The macro code will run & place the URL in an adjacent cell!

Also Read: Fix Excel Hyperlink Not Working Problem!

Tips to Handle Extracted URLs

1. Always apply filters to sort & analyze URLs efficiently.
2. After extraction of the URL, check for invalid or duplicate links.
3. Save the extracted URLs in a CSV file.

Related FAQs:

What Is a Hyperlink in Excel?

In MS Excel, a hyperlink is a shortcut that jumps to another location in the same workbook, or opens the document stored on a network server, or the Internet.

How Do I Copy A URL From an Excel Spreadsheet?

To copy a URL from an Excel spreadsheet, you have to right-click on the cell that contains hyperlink and you want to copy or move. Then choose Copy or Cut on a shortcut menu.

What Is the Shortcut for Hyperlink?

Ctrl+K is the keyboard shortcut that can help you to Insert Hyperlink.

Time to Closure

Extracting URLs from hyperlinks in Excel doesn’t have to be a daunting task. Whether you use VBA, formulas, or online tools, there’s a solution suited for every skill level. All you need to do is follow the methods specified in this blog to streamline your workflow and focus on more critical tasks.