How to Extract Hyperlinks from Excel – Desktop & Online

2026-08-10

  • Excel
  • extract hyperlinks
  • extract emails
  • mailto
  • tutorial

How to extract hyperlinks from excel (and extract emails from excel) comes up whenever a sheet stores real clickable links—websites, mailto: addresses—behind friendly display text like “Click here.” Copying the cell only copies the label, not the URL.

Common pain points:

  • Edit Hyperlink one cell at a time does not scale
  • Blue underlined text hides the true target address
  • Emails mix plain text, mailto links, and display names
  1. Right-click the cell → Edit Hyperlink (or Ctrl+K).
  2. Copy the address (URL or email).

Fine for spot checks; not for whole-table export.

Desktop Excel: formulas vs VBA

Formulas usually return the display value, not the hyperlink target. To batch-read real links you typically need:

  • VBA looping Range.Hyperlinks and writing .Address to a neighbor column
  • Or an add-in

If the sheet only has plain URL text (no hyperlink object), text functions can pull https://... patterns—but they still miss “label ≠ address” cells.

ComTools Extract Hyperlinks from Excel is built for full sheets:

  1. Open /excel-extract-hyperlinks.
  2. Upload .xlsx / .csv.
  3. Pick a worksheet; the tool scans cell hyperlinks, URL text, and emails.
  4. Two columns are appended: Hyperlink and Email (Chinese UI: 超链接 / 邮箱).
  5. Preview header + 50 data rows, then download xlsx.

Multiple hits in one row are joined with semicolons. Files are processed in memory and not stored.

Which tool to use

Goal Use
Extract hyperlinks + emails Extract hyperlinks
Extract embedded pictures Extract images
Keep only some columns Extract columns
Turn URL text into clickable links Excel Format

Landing pages: