Long list of hyperlinks from Excel to Indesign

[Federica370702447a5d]

Hi,

I have a very long document in Excel which I have copied into a table in Indesign. In each cell there are a list of words with hyperlinks. I need to make sure every word has its own hyperlink in Indesign. Considering it's a more than 100 pages document, is there a fast way to do this instead of copy-pasting each single url?
Below it's an image of how the cells look on Excel and on Indesign. Thank you!

[Robert at ID-Tasker]

If you know the number of Hyperlinks in Excel - then this simple script will tell you how many Hyperlinks overall and how many URL Hyperlinks there are in your document:

alert('Number of ALL Hyperlinks = ' + app.activeDocument.hyperlinks.length);
alert('Number of URL Hyperlinks = ' + app.activeDocument.hyperlinkURLDestinations.length);

If you work on a PC and want something more powerful - even free version of my ID-Tasker will show you a lot more info.

[Federica370702447a5d]

Apologies, maybe it's not clear, I don't need to know how many hyperlinks are in the document, I need a fast way of copy pasting them onto the Indesign document. Every word needs to have its own hyperlink like in the Excel document.

[Robert at ID-Tasker]

Apologies, maybe it's not clear, I don't need to know how many hyperlinks are in the document, I need a fast way of copy pasting them onto the Indesign document. Every word needs to have its own hyperlink like in the Excel document.

By @Federica370702447a5d

So you don't have them in the InDesign yet?

What happens if you copy part of your Excel file to InDesign?

I mean when you select range of Cells in Excel, copy, and paste in InDesign.

Or even use Place command and place whole Excel file at once.

Or you can copy contents form Excel to WORD - reformat if needed - then copy from WORD to InDesign - or save WORD document and use Place.

[Federica370702447a5d]

I have the words in Indesign, but without the hyperlinks. If I copy part of the Excel file to Indesign (which is what I did to get the words in there), it copies the words, but without the hyperlinks. 

I cannot place the whole Excel file at once because the table is formatted in a different way. I've tried the Excel to Word to Indesign but the same problem persists, the hyperlinks are not copied over.
The only way I can copy the hyperlinks is to go onto each single word in Indesign, do right click > Hyperlinks > New Hyperlink, and add it to the word. I have a 100 pages document so if I continue doing it this way it will take me forever to finish it 😞

[Robert at ID-Tasker]

Can you share a sample of your Excel file? 

And what do you have set in Clipboard Handling:

https://helpx.adobe.com/uk/indesign/using/adding-text-frames.html#:~:text=Paste%20text%20from%20anot...