Adding hyperlinks to InDesign from Excel

[s@xorNOJ]

I am creating a book listing in Adobe InDesign, where each book title needs a hyperlink assigned. I copy the links from Excel to InDesign using **Window > Interactive > Hyperlink**. Can someone help me automate this process, possibly with a script? Thanks!

[Robert at ID-Tasker]

@Robert at ID-Tasker 

Just to clarify, are you referring to the Excel file or the InDesign file? Appreciate your help!

By s@xorNOJ

InDesign - contents of the main Story with your text. 

[s@xorNOJ]

@Robert at ID-Tasker 

Apologies for the late reply. I got really busy and was also unwell, so I haven’t had the chance to revisit this until now.

I really appreciate  the time to provide solutions to my issue. Your insights are helpful, and I plan to try them out in the coming days once I’m feeling 100% better. I’ll update here once I’ve tested them.

Thanks again for your help!

[Robert at ID-Tasker]

s@xorNOJ

Of course, no problem, get well first.

[Eugene Tyson]

Hello - some have requested similar before

https://community.adobe.com/t5/indesign-discussions/add-hyperlinks-from-excel-file/td-p/13369415

If it's not working let us know there maybe something in scripting solution for you, but the options in the link might suffice. 

If you need something more specific let us know what you need exactly and how you need it to work.

[Abhishek Rao]

Hi s@xorNOJ,  

I hope the suggestions from Robert and Eugene helped! Were you able to get the hyperlinks added from Excel successfully? If so, feel free to share what worked for you - it could help others with a similar need. 

Looking forward to your update! 

^

Abhishek

[s@xorNOJ]

Hi @Abhishek Rao 
I just shared the files with @Robert at ID-Tasker . A huge thanks to all of you. Let's hope we can find the answer to this.

[Mike Witherell]

By the way, are these external hyperlinks to web addresses in your Excel file?

[s@xorNOJ]

Hi Mike,

Thanks for asking.

Yes, those are external hyperlinks.

[Kasyan Servetsky]

Hi s@xorNOJ ,
Here I made a script for you that makes hyperlinks reading data from Excel.

Hope it helps!
— Kas

[s@xorNOJ]

Hi @Kasyan Servetsky 

Sorry for the delayed response—I’ve been caught up with work and wasn’t feeling well, so I couldn’t check back sooner. I’ll be trying them out in the next few days once I’m fully recovered. I’ll update here once I’ve had a chance to test them.

Thanks again!