# Transfer links in an EXCEL sheet to a NUMBERS sheet

**URL:** <https://discourse.hookproductivity.com/t/transfer-links-in-an-excel-sheet-to-a-numbers-sheet/6551>\
**Category:** Discussion & Help\
**Created:** [March 26, 2023, 11:20am UTC](https://discourse.hookproductivity.com/t/transfer-links-in-an-excel-sheet-to-a-numbers-sheet/6551 "2023-03-26T11:20:21Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![GarethM](https://discourse.hookproductivity.com/letter_avatar_proxy/v4/letter/g/90db22/32.png) [@GarethM](https://discourse.hookproductivity.com/u/GarethM)\
**Post date:** [March 26, 2023, 11:20am UTC](https://discourse.hookproductivity.com/t/transfer-links-in-an-excel-sheet-to-a-numbers-sheet/6551/1 "2023-03-26T11:20:21Z")

</div>

I have bunch of hookmark links in an Excel spreadsheet which work fine, but I want to move all these links to new NUMBERS sheet. (The reason is that I cannot get rid of the annoying warning that Excel gives every time I click on a link).

I have opened the Excel sheet in Numbers, but all the links are lost.

Is there a way to move all the links without having to recreate them all again one by one in Numbers?

---

<div class="post-metadata">

**Author:** ![bchend](https://discourse.hookproductivity.com/letter_avatar_proxy/v4/letter/b/dbc845/32.png) [@bchend](https://discourse.hookproductivity.com/u/bchend)\
**Post date:** [March 27, 2023, 6:16pm UTC](https://discourse.hookproductivity.com/t/transfer-links-in-an-excel-sheet-to-a-numbers-sheet/6551/2 "2023-03-27T18:16:45Z")

</div>

When you say all the links are lost, do you mean they disappear in Numbers, or they are not working?

Could you please send us a sample file to [support@cogsciapps.com](mailto:support@cogsciapps.com) so we can have a look?

Thank you!

---

<div class="post-metadata">

**Author:** ![bchend](https://discourse.hookproductivity.com/letter_avatar_proxy/v4/letter/b/dbc845/32.png) [@bchend](https://discourse.hookproductivity.com/u/bchend)\
**Post date:** [March 28, 2023, 5:42pm UTC](https://discourse.hookproductivity.com/t/transfer-links-in-an-excel-sheet-to-a-numbers-sheet/6551/3 "2023-03-28T17:42:42Z")

</div>

It seems when Numbers opens the Excel sheet, the link is lost. I tried editing the link in Numbers, I can see the link field is empty. I googled to see if there is any trick to keep the link intact but no luck yet. Sorry I don’t have the expertise to help.

---

<div class="post-metadata">

**Author:** ![LucB](https://discourse.hookproductivity.com/user_avatar/discourse.hookproductivity.com/lucb/32/2228_2.png) [@LucB](https://discourse.hookproductivity.com/u/LucB)\
**Post date:** [March 28, 2023, 10:44pm UTC](https://discourse.hookproductivity.com/t/transfer-links-in-an-excel-sheet-to-a-numbers-sheet/6551/4 "2023-03-28T22:44:46Z")

</div>

If Excel deletes custom links, then you could try: in Numbers, before exporting to Excel: globally change hook:// custom links [to our universal links](https://hookproductivity.com/help/more/universal-links/). That should do the trick.

---

<div class="post-metadata">

**Author:** ![GarethM](https://discourse.hookproductivity.com/letter_avatar_proxy/v4/letter/g/90db22/32.png) [@GarethM](https://discourse.hookproductivity.com/u/GarethM)\
**Post date:** [March 29, 2023, 3:28am UTC](https://discourse.hookproductivity.com/t/transfer-links-in-an-excel-sheet-to-a-numbers-sheet/6551/5 "2023-03-29T03:28:45Z")

</div>

The universal links solves the issue, BUT I could not figure out how (in Excel) to globally change “hook:/” to  
[https://hookmark.net/hm/hook](https://hookmark.net/hm/hook)

When I do Search & Replace, excel does not find the hyperlink text

Any suggestions how to do this

Thanks

---

<div class="post-metadata">

**Author:** ![LucB](https://discourse.hookproductivity.com/user_avatar/discourse.hookproductivity.com/lucb/32/2228_2.png) [@LucB](https://discourse.hookproductivity.com/u/LucB)\
**Post date:** [March 29, 2023, 3:59am UTC](https://discourse.hookproductivity.com/t/transfer-links-in-an-excel-sheet-to-a-numbers-sheet/6551/6 "2023-03-29T03:59:07Z")

</div>

I would export to a .CSV file and use BBEdit find/replace with regular expressions.

---

<div class="post-metadata">

**Author:** ![GarethM](https://discourse.hookproductivity.com/letter_avatar_proxy/v4/letter/g/90db22/32.png) [@GarethM](https://discourse.hookproductivity.com/u/GarethM)\
**Post date:** [March 29, 2023, 6:03am UTC](https://discourse.hookproductivity.com/t/transfer-links-in-an-excel-sheet-to-a-numbers-sheet/6551/7 "2023-03-29T06:03:17Z")

</div>

Maybe I am doing something wrong. But when I export to CSV this also destroys all the hyperlink text, so the data is not available to edit within any text editor

By the way, for info, by using universal links also solves the issue of Excel giving the annoying warning alert before opening the linked file.

However, my issue remains of how to globally edit many hyperlinks in an excel sheet