• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Long list of hyperlinks from Excel to Indesign

New Here ,
May 02, 2024 May 02, 2024

Copy link to clipboard

Copied

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!

TOPICS
How to , Type

Views

125

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 02, 2024 May 02, 2024

Copy link to clipboard

Copied

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.

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 02, 2024 May 02, 2024

Copy link to clipboard

Copied

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 02, 2024 May 02, 2024

Copy link to clipboard

Copied

quote

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.

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 02, 2024 May 02, 2024

Copy link to clipboard

Copied

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 😞

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 02, 2024 May 02, 2024

Copy link to clipboard

Copied

LATEST

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...

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines