Skip to main content
  Tuesday, February 20 2018
  3 Replies
  1.5K Visits
  Subscribe
Add the ability retain links that exist in spreadsheets and convert them to HTML links.

We use spreadsheets that have hundreds of links. DropTables is great for importing the spreadsheets but we still have to go back though and re-insert links which takes a significant amount of time.

I would think it would be possible to have a script to convert the standard spreadsheet link which is


=HYPERLINK("http://somedomain.com","Link")


to


<a href="http://somedomain.com target="_blank">Link</a>
T
Hi,

Thanks for your feedback.
Just to confirm what is the original input format in your spreadsheet, is it a classical link like attached?

i'm asking because the styles preserved on import should be: Cell background color, font color, font size, borders, Links (HTML format).

Cheers,
T
I alswo whould love to see this feature. Super important to me. Now I have to look for alternative sollution which makes me think to switch from full member subscription to single plugins. (cheaper that way.)
N
5 years ago
Hi,

Thanks for your feedback.
Just to confirm what is the original input format in your spreadsheet, is it a classical link like attached?

i'm asking because the styles preserved on import should be: Cell background color, font color, font size, borders, Links (HTML format).

Cheers,


Sorry I missed your reply. We get the spreadsheeds from a 3rd party so I'm not sure exactly how they are inserting them but when I look at the field in Excel is has


=HYPERLINK("http://somedomain.com","Link")


I think they have some sort of application that exports the spreadsheet as there are usually 100 rows with 4-8 columns of links so anywhere from 100 to 900 links which would be pretty time consuming to insert manually.

If I just copy/paste a link into a field it's plain text but automatically turns into a clickable link in Excel.
  • Page :
  • 1
There are no replies made for this post yet.