Bulk Add Hyperlinks

What it does

You have a column of URL text. Each cell shows https://example.com/page or www.example.com. They're not clickable; they're just strings. Excel won't auto-link them when imported from CSV. The macro walks your selection, detects URL-shaped text, and turns each into a clickable hyperlink. Cells that don't look like URLs are skipped, so you can run it on a column that's mostly notes with a few URLs scattered through.

Real-world example

Picture a research librarian at a small university maintaining the digital reading list for a graduate seminar. The list lives in Excel because it's easy to share with the professor for editing. Each row is one reading: title, author, journal, URL. The URLs come from copy-paste out of databases and arrive as plain text strings. Students open the file, see URLs, can't click. The librarian wants them clickable.

Her current method: click each URL cell, press F2 to enter edit mode, press Enter, Excel auto-creates the hyperlink. Repeat 60 times for the 60 readings on the list. About 5 minutes of mechanical clicking, with three or four cells where the hyperlink doesn't trigger because the cell already had whitespace or some other artifact.

With this macro she selects the URL column, runs the tool, and 60 cells become 60 clickable links in 1 second. The popup confirms count. She saves and shares the file. Students click.

On a 60-link reading list, expect about 5 minutes saved per pass. Across the semester she rebuilds the reading list 4 times (different courses), so about 20 minutes back per term. The bigger win is the URLs that actually work versus the ones where her manual F2/Enter trick silently failed because the cell had a stray space.

How to use

First time? See How to run our tools for the 30-second setup.

1. Select the range of cells containing URL text.
2. Press Alt + F8 (Windows) or Option + F8 (Mac), pick BulkAddHyperlinks, click Run.
3. The macro detects URL-shaped text (starts with http://, https://, or www.), turns each into a clickable hyperlink, and reports added and skipped counts.

FAQ

What counts as a URL?

The macro looks for text starting with http://, https://, or www.. Anything starting with www. gets prefixed with https:// automatically when the hyperlink is added. Other schemes (ftp://, mailto:) aren't auto-detected; if you need them, edit the .bas source: change the NormalizeUrl function to recognize the schemes you need.

What if my cell has prose followed by a URL?

The macro creates a hyperlink that wraps the entire cell, but the URL it links to is whatever the entire cell starts with. If the cell starts with Visit https://example.com for details, the macro skips it because the cell doesn't start with http:// or https:// or www.. To extract URLs from prose, use Extract Email Addresses From Text as a pattern starting point and adapt for URL extraction.

Does it preserve cell formatting?

Yes. The hyperlink underline and blue color get applied (Excel's default for hyperlinks). Cell-level formatting like bold, font size, fill color is preserved. If you want to suppress the blue-underline appearance, format the cell after running.

Can I run it on cells that already have hyperlinks?

Yes. The macro removes any existing hyperlink first, then adds a new one based on the cell's text. So if a hyperlink got out of sync with the cell text, this fixes it.

Can I undo it?

Yes, Ctrl/Cmd + Z right after running. The macro runs entirely offline. No signup, no account, no data leaves your machine.