Extract Hyperlink Addresses from Cells and Shapes...

ASAP Utilities › Web Data › 4. Extract Hyperlink Addresses from Cells and Shapes...

This tool extracts the hyperlink addresses from cells and shapes on your current worksheet and places them into regular cells. It works with all types of hyperlinks that Excel supports, such as:

Web addresses (URLs)

Email addresses (mailto:)

Links to a place in your workbook (like a specific cell or sheet)

Links to files or folders on your computer or network You can choose to get the hyperlinks from:

The selected cells

All shapes or images on the worksheet that contain a hyperlink Shapes can include:

AutoShapes

Freeforms

Pictures

OLE objects You can choose where to place the extracted hyperlink address:

In the original cell, leaving the hyperlink itself unchanged

In the column directly next to the cell or shape (any existing value will be overwritten) This tool is useful when you want to extract, review, or export hyperlink addresses from cells or clickable shapes, without opening or editing each one manually. Your last used settings are automatically remembered for quick reuse. Tip:
If you want to read a hyperlink address directly from a cell using a formula, you can also use the ASAP Utilities worksheet function:
=ASAPGETHYPERLINK()

Screenshots

Web Data › 4 Extract Hyperlink Addresses from Cells and Shapes...

Starting this tool

Click ASAP Utilities › Web Data › 4. Extract Hyperlink Addresses from Cells and Shapes...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Additional keywords for this tool:
Extract hyperlink addresses, Extract links from cells, Extract URLs from cells, Get hyperlink address from cell, Extract email addresses from hyperlinks, Extract links from shapes, Extract links from pictures, List all hyperlinks in Excel, Export hyperlinks from Excel, Get URL from hyperlink, Extract mailto links, Get cell link address, Extract internal links, Extract hyperlinks to next column, Read hyperlink from shape, Extract link without removing hyperlink, Extract hyperlinks from Excel images, Extract hyperlink formula, Extract hyperlinks from selected cells, Show hyperlinks

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Decode URL and HTML Encoded Text in Selected Cells

Create Hyperlinks from Cell Values...

Download

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.