Support » Plugin: TablePress » Import Hyperlinks with data from Excel

  • Resolved mtweber

    (@mtweber)


    When I import an excel spreadsheet into TablePress the hyperlinks attached to the data are not imported.

    How do I do this?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Unfortunately, directly importing Excel links is not possible, as those have a different format than links on websites (HTML code). You will need to add them as HTML code to your Excel file as well. One quick way to achieve that might be to use a custom Excel macro to convert the original link. Maybe http://wordpress.org/support/topic/hyperlinks-in-cells?replies=6#post-4710730 is a good starting point for that.

    Regards,
    Tobias

    Thank you for your prompt reply.

    I didn’t explain my problem thoroughly. Let me start over.
    I have webpage of HTML links that I’m trying to re-organize by categories.

    Right now the links are just listed one after another down the page.

    I would like to take that list of unorganized links and display them in a categorized table. (each column alphabetized). The list of links is long and manually moving each link to where it’s new position is very time consuming. I thought that importing the list into Excel then organizing them there, then sorting A-Z would be a shorter process. It worked OK until I the import into Table Press didn’t copy the hyperlinks.

    I may be approaching this all wrong and I’m very willing to hear any suggestions.

    Thank you.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    the approach is correct and should be working. However, my answer also applies 🙂 When you save the table in Excel, the HTML information is basically lost, because Excel stores the links in a different format. That’s why you have to restore it as HTML code again.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.